Senior Analytics Engineer

The Senior Analytics Engineer will serve as a crucial bridge between data engineering and analytics within our movie studio’s Strategy & Analytics team. In this forward-looking role, you will design and automate the transformation of raw data into actionable insights, fueling strategic projects like audience forecasting, content recommendation systems, and FAST channel programming decisions. You are expected to bring an automation-first mindset and leverage AI-native tools to enhance our analytics workflows. This includes using AI/LLM assistants for coding and analysis, implementing innovative frameworks for autonomous data analysis, and exploring new protocols (like MCP) for context management in AI systems. You will ensure our analytics data models and pipelines (on Azure and Snowflake) are scalable, efficient, and ready to incorporate the latest in AI-driven automation, thus future-proofing our analytics capabilities.

Reports to: SVP, Strategy & Analytics
Exemption Status: Exempt
Pay Rate: $120k - $180k, if annualized DOE
Paid Time Off: Holidays, Vacation, Paid Sick Leave, Personal Days
Compensation: Full benefits package including 401(K) with match, medical, dental, vision, and more
Work Location: Remote

KEY RESPONSIBILITIES:
• Data Modeling & Transformation: Develop and maintain well-structured analytics datasets and data models that support business KPIs and data science initiatives. Use tools like SQL and dbt (or similar) on our Azure/Snowflake platform to transform raw data into reliable, analyticsready tables. Ensure that data models enable critical use cases such as financial forecasting, user engagement analysis for recommendations, and content performance for FAST channels.

• Analytics Pipeline Automation: Automate and orchestrate analytics workflows to reduce manual effort and turnaround time. Build automated data transformation pipelines, scheduling and monitoring them. Implement data quality checks, anomaly detection, and documentation as part of the pipeline to ensure trust in the insights delivered. Continuously seek out repetitive reporting or analysis tasks that can be scripted or automated – applying an automation-first approach to everything from data validation to dashboard refreshes.

• AI-Enhanced Insights Generation: Leverage AI and LLM tools to improve and scale analytics. For example, use AI assistants (ChatGPT, Copilot, etc.) to accelerate writing complex SQL, Python analysis scripts or to generate preliminary insights from data. Experiment with agentic LLM frameworks (e.g., LangChain, AutoGPT) to create intelligent analytical agents that can autonomously perform tasks like generating reports, monitoring metrics, or answering data questions by pulling from live data. Innovate in how we use AI to surface insights faster and more proactively to the business.

• LLM Context Management: Collaborate in exploring and adopting emerging approaches for integrating AI into our analytics stack. This may involve using the Model Context Protocol (MCP) and similar concepts to provide rich context to AI systems or conversational analytics tools, ensuring that any AI-driven analysis has access to relevant data securely and effectively.

• Cross-Functional Collaboration: Work closely with strategy analysts, content teams, and other business stakeholders to understand analytical needs and translate them into data solutions. Ensure that the data in our warehouse and the metrics defined are aligned with business definitions and requirements. Partner with the Senior Data Engineer and potentially data scientists to ensure that data pipelines and models are optimized for analysis and machine learning use cases. Participate in designing experiments or prototyping ML models (e.g., for recommendations or churn forecasting) and help integrate their outputs into our data ecosystem for ongoing use.

• Innovation & Future-Proofing: Act as a thought leader in the adoption of new analytics and BI technologies. Continuously evaluate new tools (BI platforms, automation tools, AI APIs) that could enhance our analytics capabilities. Champion a culture of innovation and continuous improvement, using cutting-edge AI/ML and automation techniques to future-proof our analytics workflows. This includes staying current with industry trends in AI-driven analytics, and ensuring our studio’s analytics infrastructure remains ahead of the curve.

QUALIFICATIONS & EXPERIENCE:
• Education & Experience: Bachelor’s or Master’s in Data Science, Analytics, Computer Science, or related field. 5+ years of experience in analytics engineering, business intelligence, or data analysis/engineering roles, with a focus on building data models and analytics solutions at scale.

• Data Warehousing & SQL Skills: Expert SQL skills with experience in developing optimized, complex queries. Strong experience in data modeling for analytics (star/snowflake schema design, dimensional modeling) and working with modern cloud data warehouses (Snowflake preferred, or Redshift/BigQuery). Familiarity with transformation frameworks like dbt and ability to enforce data governance best practices (documentation, lineage, testing).

• Programming & Analysis: Proficiency in a programming language for data analysis (Python or R preferred) to create scripts for data processing, automation, and potentially ML model prototyping. Experience using Python libraries for data (SKLearn, Pandas, PySpark, etc.) and willingness to explore machine learning libraries or techniques for advanced analytics.

• BI Tools & Visualization: Experience with BI and reporting tools (e.g., Tableau, Power BI, or similar) and designing dashboards or reports that communicate insights effectively. Knowledge of how to enable self-service analytics for business users is a plus.

• AI/Automation Proficiency: Proven automation-first mindset – constantly looks for
opportunities to eliminate manual work through clever automation. Experience using or implementing workflow orchestration (Airflow, etc.) and scripting routine tasks. Comfort with AI productivity tools: using GitHub Copilot or ChatGPT to assist in coding and troubleshooting, using AI for data exploration or report generation. Eagerness to integrate AI into analytics processes for greater efficiency.

• Emerging Tech & LLM Familiarity: Strong interest in staying at the cutting edge of data and AI tech. Familiarity with LLM-based tools and frameworks – for instance, understanding how LangChain or AutoGPT can be used to create autonomous analytics or data query agents. Any experience experimenting with such frameworks to solve real problems is a big plus. Awareness of Model Context Protocol (MCP) or similar concepts for providing context to AI systems is appreciated, indicating a forward-looking perspective on AI integration.

• Analytical Mindset & Business Acumen: Excellent analytical and problem-solving abilities with keen attention to detail. Able to understand complex business questions and find data-driven answers. Demonstrated ability to translate business requirements into technical specifications and ultimately into tangible insights. Experience in the media/entertainment domain (e.g., streaming analytics, content performance) is a bonus, but a strong curiosity and ability to quickly learn the business is essential.

• Collaboration & Communication: Exceptional communication skills to work with crossfunctional teams and convey technical information to non-technical stakeholders. Experience collaborating with data engineers, product or strategy managers, and possibly mentoring junior analysts/engineers. Comfortable in an agile, fast-moving environment. Enthusiasm for teamwork and driving positive change through data and innovation.

Join us in pushing the boundaries of analytics and data engineering through AI and automation. This role offers the opportunity to influence the future of our studio’s data strategy, implement cutting-edge technologies, and ensure that we remain at the forefront of innovation in the entertainment industry. If you are passionate about leveraging modern AI tools, automating relentlessly, and building future-proof data solutions, we encourage you to apply and help shape the next era of data-driven decision-making at Shout! Studios.

How to Apply
To apply for this position, please send in a cover letter and resume detailing your experience and interest via email to: jobs@shoutfactory.com.

Shout! Studios is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.