Amazon Data Engineer Amazon MGM Studios Insights 

United States, California 

716062305

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- 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-solvingA day in the life- 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- Investigate and resolve issues in data integrity, process failures

- 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