Data Engineer II, Amazon MGM Studios Data Insights

Mid • On-site

$118,900 - $205,600/yr

Culver City, CA

DESCRIPTION

Amazon Studios Technology is revolutionizing how entertainment decisions are made by building innovative data solutions that unlock insights across the content lifecycle. We're seeking skilled data engineers to join our Data & Insights team and help transform raw data into actionable intelligence that shapes the future of Amazon MGM Studios.

Our mission is to empower 2,400+ customers across Studios and Prime Video organizations with reliable, timely data to drive business decisions. As a data engineer, you'll design and implement data pipelines that integrate diverse sources, ensure data quality, and enable self-service analytics capabilities.

Key job responsibilities
- Design and implement robust, scalable ETL/ELT pipelines across multiple complex data sources
- Create coherent Logical Data Models that drive physical design decisions for significant datasets
- Ensure data quality, consistency, and reliability across the entire analytics ecosystem
- Build and maintain sophisticated automated data validation and monitoring solutions
- Develop and optimize data models that serve diverse business intelligence needs
- Lead performance optimization for data warehouse systems and pipelines
- Implement data structures using advanced best practices in data modeling, ETL/ELT processes, SQL, Oracle, and OLAP technologies
- Make appropriate architectural trade-offs between flexibility, performance, and complexity
- Balance resource usage efficiency with system requirements and business needs

A day in the life
- Develop and optimize mission-critical data pipelines with significant business impact
- Troubleshoot complex data quality issues and implement systematic, scalable fixes
- Partner with senior product and business stakeholders to translate requirements into technical solutions
- Lead optimization efforts for existing ETL/ELT processes to improve performance and reliability
- Support and mentor BI engineers in accessing and utilizing complex data models
- Establish and promote best practices in data system creation, data integrity, testing, and documentation
- Investigate and resolve root causes of complex issues in data integrity and process failures
- Actively participate in code reviews, design discussions, and team planning sessions
- Train peers on how team data solutions are constructed, operated, secured, and integrated
- Identify opportunities for continuous improvement in team processes and data architecture
- Help recruit and interview for the team while mentoring junior engineers

About the team
We transform complex data from 20+ source systems into actionable insights that drive Studios' success. Our work enables teams to make data-driven decisions about content investment, production operations, and business strategy. We maintain high standards for data quality while delivering analytics capabilities that scale with Studios' growing needs.

BASIC QUALIFICATIONS

- 3+ years of data engineering experience
- Experience with data modeling, warehousing and building ETL pipelines

PREFERRED QUALIFICATIONS

- Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
- Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Los Angeles County applicants: Job duties for this position include: work safely and cooperatively with other employees, supervisors, and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees, supervisors, and staff to ensure exceptional customer service; and follow all federal, state, and local laws and Company policies. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness and professionalism, and safeguard business operations and the Company’s reputation. Pursuant to the Los Angeles County Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $118,900/year in our lowest geographic market up to $205,600/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.

Amazon

Amazon.com, Inc. founded in 1994 by Jeff Bezos in the cozy confines of his Seattle garage, Amazon.com, Inc. quickly evolved from a humble online bookstore to a colossal e-commerce powerhouse. Today, it offers an extensive range of products from DVDs and electronics to furniture and groceries. With a global footprint that spans continents—from Canada and the UK to Japan and Brazil—Amazon's presence is truly international. The company has not only diversified into various domains, including acquiring Twitch in 2014 and venturing into the film industry in 2015, but also introduced initiatives like the brand registry program to safeguard intellectual property. Despite the hurdles of labor relations and competitive practices, Amazon remains a dominant force in the global e-commerce landscape.