Amazon Studios Technology is revolutionizing how entertainment decisions are made by building innovative data solutions that unlock insights across the content lifecycle. Were 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 2400 customers across Studios and Prime Video organizations with reliable timely data to drive business decisions. As a data engineer youll 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.
- 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 Companys 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
for more information. If the country/region youre applying in isnt 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 $91200/year in our lowest geographic market up to $185000/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 This position will remain posted until filled. Applicants should apply via our internal or external career site.