Data Engineer II

Disney Entertainment and ESPN Product & Technology Technology is at the heart of Disney’s past, present, and future. Disney Entertainment and ESPN Product & Technology is a global organization of engineers, product developers, designers, technologists, data scientists, and more – all working to build and advance the technological backbone for Disney’s media business globally.

The team marries technology with creativity to build world-class products, enhance storytelling, and drive velocity, innovation, and scalability for our businesses. We are Storytellers and Innovators. Creators and Builders. Entertainers and Engineers. We work with every part of The Walt Disney Company’s media portfolio to advance the technological foundation and consumer media touch points serving millions of people around the world.

A few reasons why we think you’d love working for Disney Entertainment & ESPN Technology

• Building the future of Disney’s media business: DE&E Technologists are designing and building the infrastructure that will power Disney’s media, advertising, and distribution businesses for years to come.
• Reach & Scale: The products and platforms this group builds and operates delight millions of consumers every minute of every day – from Disney+ and Hulu, to ABC News and Entertainment, to ESPN and ESPN+, and much more.
• Innovation: We develop and execute groundbreaking products and techniques that shape industry norms and enhance how audiences experience sports, entertainment & news.

Commerce, Data & Identity Commerce, Data & Identity provides the core product management functions for areas crucial to Disney’s media businesses. These include initiatives and products that power digital commerce, identity, and growth, as well as those that reach uniquely across The Walt Disney Company enterprise, such as messaging and privacy, among others. Additionally, it is responsible for the data engineering, science, and products for Disney Entertainment & ESPN, along with their interconnection with other parts of The Walt Disney Company.

Job Summary The Data Engineer II partners with business, analytics and infrastructure teams to design and build data pipelines to measure Subscriber and Commerce Movements and Metrics. Responsibilities include identifying internal/external data sources, build ETLs & automated Data Quality checks.

Responsibilities And Duties Of The Role

• Partner with technical and non-technical colleagues to understand data and reporting requirements.
• Contribute to the design of table structures and defining ETL pipelines to build performant Data solutions that are reliable and scalable in a fast growing data ecosystem.
• Develop Data Quality checks, write code, complete programming, write tests, perform testing and debug code.
• Develop and maintain ETL routines using ETL and orchestration tools such as Airflow
• Implement database deployments using tools like Schema Change
• Perform ad hoc analysis as necessary.
• Perform SQL and ETL tuning as necessary.

Basic Qualifications

• 3+ years of relevant data engineering experience.
• Good understanding of data modeling principles including Dimensional modeling, data normalization principles.
• Good understanding of SQL Engines and able to conduct advanced performance tuning.
• Experience using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift)
• Ability to think strategically, analyze and interpret market and consumer information.
• Strong communication skills – written and verbal presentations.
• Strong conceptual and analytical reasoning competencies.
• Comfortable working in a fast-paced and highly collaborative environment.
• Familiarity with Agile Scrum principles and ceremonies
• Experience working with Python

Preferred Qualifications

• 2+ years of work experience implementing and reporting on business key performance indicators in data warehousing environments, required.
• 1+ years of experience with data orchestration/ETL tools (Airflow, Nifi), preferred.
• Experience with Snowflake, Databricks/EMR/Spark, and/or Airflow.

Required Education

• Bachelor’s Degree in computer science, information systems, or related field or equivalent work experience.

The hiring range for this position in Santa Monica is $106,900-$143,300 per year, in New York City and Seattle is $112,000-$150,100 per year, and in San Francisco is $117,100-$156,900 per year. The base pay actually offered will take into account internal equity and also may vary depending on the candidate’s geographic region, job-related knowledge, skills, and experience among other factors. A bonus and/or long-term incentive units may be provided as part of the compensation package, in addition to the full range of medical, financial, and/or other benefits, dependent on the level and position offered.