Data Engineer, Studios Analytics

Amazon is a global technology and entertainment company with Amazon MGM Studios and Prime Video Finance Analytics organizations supporting content planning, evaluation, and optimization. The Data Engineer will build and own data pipelines, models, and governed datasets that power content performance reporting and products used by Studios leadership. The role also focuses on data quality, automation, integrated reporting, and enabling self-service access to content data.

Responsibilities

• Build, optimize, and own data pipelines (ETL/ELT) and logical/physical data models for content performance datasets that serve as the source of truth for title-level launch KPIs
• Own ongoing data quality, monitoring, and SLAs for your datasets, ensuring reporting surfaced in applications is accurate, timely, and trusted by Studios leadership
• Take single-threaded ownership of the data behind the content performance products enabling the team to prioritize and deliver data changes independently
• Partner with BIEs, product development, and the financial reporting team to deliver integrated title-level and portfolio-level data (including feeds into web applications and downstream reporting)
• Consume upstream governed data (e.g., P&L from the Economics team) correctly and consistently, upholding metric governance so definitions remain consistent across Prime Video
• Automate manual and ad-hoc data processes, build tooling for data lineage, quality, and discoverability, and reduce operational toil
• Contribute to design reviews, data modeling decisions, and technical trade-offs, leaving data solutions better and easier to maintain than you found them
• Enable self-service access to underlying content data for analysts and BIEs, minimizing bottlenecks

Preferred

• Master's degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field
• Experience using Cloud Storage and Computing technologies such as AWS Redshift, S3, Hadoop, etc
• Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
• 6+ years of business intelligence and analytics experience
• Experience in digital media or marketing strategy, data analysis, analytics & visualization
• Familiarity with data governance, lineage, and metadata management practices
• Computer Science
• Information Systems
• Mathematics
• Cloud Storage
• Cloud Computing
• AWS Redshift
• Amazon S3
• Hadoop
• Hive
• Apache Spark
• Amazon EMR
• Business Intelligence
• Data Analytics
• Digital Media
• Marketing Strategy
• Data Analysis
• Data Visualization
• Data Governance
• Data Lineage
• Metadata Management

Benefits

• Sign-on payments
• Restricted stock units (RSUs)
• Health insurance including medical, dental, vision, prescription, Basic Life & AD&D insurance, and option for Supplemental Life plans
• Employee Assistance Program (EAP)
• Mental Health Support
• Medical Advice Line
• Flexible Spending Accounts
• Adoption and Surrogacy Reimbursement coverage
• 401(k) matching
• Paid time off
• Parental leave

Company

• Online retail and cloud computing services
• Seattle, Washington, USA
• https://amazon.com/
• Founded in 1994
• 10001+ employees

Qualifications

• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field
• 3+ years of data engineering experience
• 3+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• Experience in scripting for automation (e.g. Python) and advanced SQL skills
• Experience in building analytic or scientific data products or solutions
• Experience building data pipelines or automated ETL processes
• Knowledge of distributed systems as it pertains to data storage and computing
• Experience working with data warehousing, data quality
• Master's degree in Computer Science, Engineering, Information Systems, Mathematics, or a related field
• Experience using Cloud Storage and Computing technologies such as AWS Redshift, S3, Hadoop, etc
• Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
• 6+ years of business intelligence and analytics experience
• Experience in digital media or marketing strategy, data analysis, analytics & visualization
• Familiarity with data governance, lineage, and metadata management practices

Required skills

• Data Engineering, ETL/ELT, Data Pipelines, Python, Advanced SQL, Data Warehousing, Distributed Systems, Data Quality, AWS Redshift, Amazon S3, Hadoop, Hive, Apache Spark, Amazon EMR, Data Governance

Preferred skills

• 6+ years of business intelligence and analytics experience

Experience

• 3+ years