Lead Data Engineer

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.

Job Summary:
The Ad Platforms team is responsible for building and operating the technology that supports Disney's industry-leading, multi-billion dollar global advertising business. Working across all of Disney's streaming brands and linear channels, this team's scope is wide ranging - they impact everything from core infrastructure development that powers Disney's proprietary ad server, to reimagining viewer-first ad experiences and formats. This team's award-winning, in-house built technologies are the backbone of Disney's ad business and a critical element of the Company's streaming future.
The Lead Data Engineer 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. You will also help mentor and guide other more junior data engineers in their data pipeline development.
Responsibilities and Duties of the Role:

• Lead the successful design and implementation of complex technical problems.
• Lead and contribute to the design and growth of our Data Products and Data Warehouses around Linear and Addressable BI data.
• Use sophisticated analytical thought to exercise judgement and identify innovative solutions.
• Partner with technical and non-technical colleagues to understand data and reporting requirements, and Collaborate with Data Product Managers, Data Architects and other Data Engineers to design, implement, and deliver successful data solutions
• Design table structures and define ETL pipelines to build performant Data solutions that are reliable and scalable in a fast growing data ecosystem.
• Develop Data Quality checks
• Develop and maintain ETL routines using ETL and orchestration tools such as Airflow
• Serve as an advanced resource to other Data Engineers on the team, and mentor and coach more junior members of the team helping to improve their skills, knowledge, and productivity.

Required Education, Experience/Skills/Training:
Basic Qualifications

• 7+ years of data engineering experience developing large data pipelines.
• Strong understanding of data modeling principles including Dimensional modeling, data normalization principles.
• Strong 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.
• Excellent conceptual and analytical reasoning competencies.
• Comfortable working in a fast-paced and highly collaborative environment.
• Familiarity with Agile Scrum principles and ceremonies

Preferred Qualifications

• 5+ years of experience using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift), required.
• 3+ years of experience programming languages (e.g. Python, Pyspark), preferred.
• 3+ years of experience with data orchestration/ETL tools (Airflow, Nifi), preferred.
• Experience with Snowflake, Databricks/EMR/Spark & Airflow a plus.
• Experience with Java, Kafka, Flink and AWS

Required Education

• Bachelor's Degree in Computer Science, Information Systems or related field, or equivalent work experience.
• Master's Degree a plus.