REQUIREMENTS:
- US Citizen, Greencard, OPT-EAD (no sponsorship needed)
- No C2C, C2H, Corp to Corp
- Has Marketing or Digital Marketing Experience
- 3–5 years of experience in data analytics, business analytics, marketing operations and/or creative operations.
Data Analyst – Marketing & Creative Operations
Location: Orlando, FL
Department: Data Analytics / Agency Operations
Reports to: Assistant Director, Agency Operations
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 emphasis 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 Analyst
* 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 non-technical 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.
• 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
