Job description

Job Title: Marketing Data Analyst Location: Orlando, FL (HYBRID) Duration: 6 Months About the Role: We re looking for a highly analytical and detail-oriented Data Analyst to join the Operations team within the in-house creative agency. This role will focus on transforming operational and project data into actionable insights, with a strong Client on Power BI dashboards and executive-level reporting. The ideal candidate will also have a solid understanding of project management workflows and be comfortable collaborating with cross-functional teams in a creative environment. Key Responsibilities: Overall • You will have room to run with ideas, and the trust to execute. That trust is built on how you show up: thinking things through, sweating the details, and following through. • Your ability to work independently and unblock others: How well you can move projects forward on your own, and how you help teammates overcome data challenges or confusion. • 5+ years of experience in data analysis, business intelligence, or a related field, with a track record of delivering analytics solutions (dashboards, reports, and data models) from concept to insight. • Proficiency in Power BI: hands-on experience building interactive dashboards and reports. • You can create effective data visualizations and have strong DAX skills for custom measures and calculations. • You think critically about what the numbers are showing and why. • You take pride in delivering work that is correct and reliable. • Unique combination of technology and people skills. • You can dive into technical data problems but also excel at collaborating with others. • You communicate complex data concepts in clear, approachable terms and build trust with clients and team members alike. • Excellent problem-solving and troubleshooting skills, paired with a hands-on, proactive attitude. • You can document your work, write clear explanations, and present findings or recommendations to stakeholders confidently. • You ll help cultivate a thoughtful, kind, and continuously learning team culture. Data Analytics & Insights • You ll gather requirements from stakeholders and translate business needs into interactive reports that drive decision-making. • Expect to iterate on designs and refine visuals to tell clear data stories • Perform Data Modeling & Analytics: Develop robust data models and analytical workflows to support reporting and deeper analysis. • This includes shaping and transforming data (using Power Query, SQL, or Python) to ensure reliable, analyzable datasets. • You ll define relationships, calculations, and measures (DAX) that yield accurate insights. • Partner with Stakeholders: Work directly with clients and team members to understand key business questions and KPIs. • Throughout the full project lifecycle, you ll translate business needs into data solutions. • You will explain your analyses and dashboards clearly to both technical and nontechnical stakeholders, ensuring insights are understood and actionable • Ensure Data Quality and Integrity: Take ownership of data accuracy end-to-end. • You ll validate and test data, troubleshoot discrepancies, and implement checks so that every report is trusted. • Maintain documentation of data definitions and assumptions. • At every step, uphold best practices for data governance and security. • Optimize and Iterate: Continuously improve the performance and usability of our analytics solutions. • You ll optimize SQL queries and Power BI data models for efficiency, ensuring quick load times and up-to-date data. • Incorporate feedback from users to enhance functionality and refine metrics as needs evolve. • Contribute to Data Strategy: Look beyond immediate requests to identify new opportunities where data can add value. • You might research emerging BI features, propose new analytics methodologies, or develop internal tools to push our data capabilities forward. • We expect you to think strategically about how to leverage data for maximum impact. • Improve Yourself and the Team: During times you re not assigned to a client project, you won t be idle. • You might build internal analytics tools, research new technologies or techniques (e.g., a new Azure analytics service or Python library), or help with recruiting and mentoring. • You ll help push our data craft and capabilities forward. • Mentor and Share Knowledge: Lead by example in fostering a data-driven culture. Data Visualization • Design and Build Dashboards: Create and maintain insightful, visually compelling dashboards and reports in Power BI, PowerPoint, and Excel. • Present findings in a clear, concise manner to stakeholders. • Translate complex data into actionable insights for business decisions. • Build and maintain interactive dashboards using Power BI to track KPIs, resource utilization, and project timelines. • Translate data into compelling visual stories that inform creative and strategic decisions and provide high-level insights for senior leadership. Operations & Project Management Support • Identify trends, gaps, and opportunities to improve marketing and creative processes. • Lead in shaping and transforming data (using Power Query, SQL, or Python) to ensure reliable, analyzable datasets. • Collaborate with project management and operations teams to understand data needs and improve reporting processes. • Support resource planning and capacity forecasting using Epicflow, identifying opportunities to create efficiencies in project execution. • Help standardize reporting and improve visibility into overall project health and team performance. • Present findings to stakeholders in a clear and concise manner. • Support the project management team with data-driven insights and occasional operational assistance. Cross-Functional Collaboration • Highly detail-oriented, self-motivated, organized, and adaptable. • Work closely with project management, creative, and operations teams to align data insights with business goals and inputs on creative execution. • Collaborate with IT, other business units, and internal teams to coordinate and execute User Acceptance Testing (UAT) plans for Workfront, Power BI, and Epicflow platforms. • Act as a bridge between technical data systems and non-technical stakeholders. Qualifications: • 3 5 years of experience in data analytics, business analytics, marketing operations and/or creative operations. • Sufficient experience with Power BI and strong data visualization skills. • Experience with Workfront and Epicflow (or similar project/resource management tools). • Advanced skills in Excel, PowerPoint and Word are required. • Thorough understanding of creative team operations and project management. • Excellent interpersonal, written and oral communication and storytelling abilities. Data Analyst • An ability to combine technical expertise with business acumen and communication skills to design, develop and communicate solutions to complex business problems is required. • Ability to remain adaptable and flexible, to work under pressure, and to maintain productivity in fast-paced operational and creative environments. • Excellent verbal and written communication skills and the ability to present to management. Preferred: • Experience in a creative agency or in-house brand/marketing team. • Understanding of creative and production workflows and timelines. • Bachelor s or master s degree in data science, statistics, computer science, marketing or a related field. • Advanced Power Query, SQL, or Python skills: able to write and optimize complex queries to manipulate and retrieve data from relational databases. • Experience with Python for data analysis or automation - you can use libraries (e.g., pandas, NumPy) to clean, analyze, or augment data, and script repetitive tasks to streamline workflows. • High proficiency in Excel: adept in advanced formulas, pivot tables, and data analysis in spreadsheets for quick ad-hoc analysis or data modeling when needed. • Relevant certifications such as Microsoft Power BI Data Analyst Associate or Azure Data Engineer/Analyst certifications.

Requirements