Senior Data Engineer

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 touchpoints serving millions of people around the world.

Responsibilities:

• Partner with technical and non-technical colleagues to understand data and reporting requirements. — 10%
• Work with engineering teams to collect required data from internal and external systems. — 25%
• Design table structures and define ETL pipelines to build performant Data solutions that are reliable and scalable in a fast-growing data ecosystem. — 30%
• Develop Data Quality checks
• Develop and maintain ETL routines using ETL and orchestration tools such as Airflow — 10%
• Implement database deployments using tools like Schema Change
• Perform ad hoc analysis as necessary. — 15%
• Perform SQL and ETL tuning as necessary. — 10%

Requirements:

• 5+ years of relevant data engineering experience.
• Strong understanding of data modelling principles, including Dimensional modeling data normalisation principles.
• Good understanding of SQL Engines and able to conduct advanced performance tuning.
• Ability to think strategically, analyse, and interpret market and consumer information.
• Strong communication skills - written and verbal presentations.
• Excellent conceptual and analytical reasoning competencies.
• Fomfortable 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 with 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.
• Bachelor's Degree in computer science, information systems, or a related field or equivalent work experience.