Data Engineer, Amazon MGM Studios Data Insights

- 2+ years of data engineering experience
- Experience with data modeling, warehousing and building ETL pipelines
- Experience with SQL
- Experience with one or more scripting language (e.g., Python, KornShell)
- Knowledge of basics of designing and implementing a data schema like normalization, relational model vs dimensional model
- Knowledge of writing and optimizing SQL queries in a business environment with large-scale, complex datasets
- Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala)
- Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc.
- Experience with big data technologies such as: Hadoop, Hive, Spark, EMR

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 $91,200/year in our lowest geographic market up to $185,000/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 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 ETL pipelines across multiple data sources
- Ensure data quality and consistency across the analytics ecosystem
- Build automated data validation and monitoring solutions
- Create and maintain data models that serve business intelligence needs
- Optimize data warehouse performance and reliability
- Implement data structures using best practices in data modeling, ETL/ELT processes, SQL, Oracle, and OLAP technologies
- Data gathering/manipulation, modeling and problem-solving

A day in the life
- Develop new data pipelines for business-critical metrics
- Troubleshoot data quality issues and implement fixes
- Collaborate with product and business stakeholders to understand requirements
- Optimize existing ETL processes for better performance
- Support BI engineers in accessing and utilizing data models
- Collaborate with engineers to help adopt best practices in data system creation, data integrity, test design, analysis, validation, and documentation
- Investigate and resolve issues in data integrity, process failures
- Help to continuously improve team processes and standards

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.