Business Intelligence Engineer, Studios Analytics
Description
We are looking for a Business Intelligence Engineer to join a dedicated, LA-based Studios Analytics team embedded alongside Amazon MGM Studios leadership. Reporting to the Senior Manager of Studios Analytics, you will build the dashboards, automated reporting, and AI-assisted tooling that give Studios leaders and the Strategy organization real-time visibility into content performance and portfolio health. You will translate the questions of senior content decision-makers into clear, reliable analytical products — and you will do it as part of a larger central technical organization, leveraging shared infrastructure, governed datasets, and established tooling rather than building in isolation.
This is a hands-on, delivery-focused role for someone who is energized by turning messy content and performance data into trusted, self-service reporting that leadership relies on daily.
Key job responsibilities
- Design, build, and maintain dashboards, automated reporting, and analytical tooling that surface title-level performance (launch KPIs, completion, retention) and portfolio views for Studios leadership, primarily through FrameOne and related surfaces.
- Automate high-volume, manual workflows — including templated title-level reporting, talent-facing presentations, and slate/portfolio summaries — with a bias toward scalable, reusable solutions over one-off outputs.
- Partner directly with Studios Strategy, Finance, and content stakeholders to refine ambiguous requests into specific, well-scoped deliverables, anticipating downstream needs.
- Write efficient, well-tested SQL and BI logic against governed datasets, ensuring your solutions are maintainable, performant, and resistant to data quality issues.
- Uphold central metric governance — using the single-source-of-truth definitions for content metrics so that Studios reporting is consistent with official Prime Video and finance reporting.
- Apply AI-assisted tooling to accelerate delivery, in partnership with the organization's AI enablement function.
- Collaborate closely with data engineers, product development, and the financial reporting team to deliver integrated, dependency-light solutions.
- Enable self-service access to underlying data where appropriate, reducing reporting bottlenecks for business stakeholders.
About the team
This role sits on a newly-expanded LA Studios Analytics team embedded with Studios but part of the broader 40+ person central Prime Video Finance Analytics organization. This structure is deliberate: you'll have the proximity of a small, focused team partnering directly with Studios VPs and Strategy, with the leverage of shared central infrastructure, governed data, and a dedicated AI enablement function behind you.
