Data Engineer II

Job Posting Title:

Data Engineer II

Req ID:

10096478

Job Description:

Disney Entertainment & ESPN Technology

On any given day at Disney Entertainment & ESPN Technology, we’re reimagining ways to create magical viewing experiences for the world’s most beloved stories while also transforming Disney’s media business for the future. Whether that’s evolving our streaming and digital products in new and immersive ways, powering worldwide advertising and distribution to maximize flexibility and efficiency, or delivering Disney’s unmatched entertainment and sports content, every day is a moment to make a difference to partners and to hundreds of 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.

About The Team

The Product & Data Engineering team is responsible for end to end development for Disney’s world-class consumer-facing products, including streaming platforms Disney+, Hulu, and ESPN+, and digital products & experiences across ESPN, Marvel, Disney Studios, NatGeo, and ABC News. The team drives innovation at scale for millions of consumers around the world across Apple, Android, Smart TVs, game consoles, and the web, with our platforms powering core experiences like personalization, search, messaging and data.

The Data Engineer II will contribute to the Company’s success by partnering with business, analytics and infrastructure teams to design and build data pipelines to facilitate measuring subscriber movements and metrics. Collaborating across disciplines, they will identify internal/external data sources, design table structure, define ETL strategy & automated Data Quality checks.

Responsibilities

• Partner with technical and non-technical colleagues to understand data and reporting requirements.

• Work with engineering teams to collect required data from internal and external systems.

• 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.

• 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

Preferred Qualifications

• 2+ years of work experience implementing and reporting on business key performance indicators in data warehousing environments, required.

• 2+ years of experience using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift), required.

• 1+ years of experience programming languages (e.g. Python, Pyspark), preferred.

• 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 experien