Data Engineer I

$85,300 - $85,300/Yr

Disney - Santa Monica, CA

Full-time - Entry Level

Santa Monica, CA

Motion Picture and Sound Recording Industries

About the position

At Disney Entertainment & ESPN Technology, we are dedicated to reimagining the viewing experience for our audience while transforming Disney's media business for the future. Our Product & Data Engineering team plays a crucial role in this mission, focusing on the end-to-end development of Disney's consumer-facing products, including popular streaming platforms like Disney+, Hulu, and ESPN+. We are committed to driving innovation at scale, impacting millions of consumers globally across various devices such as Apple, Android, Smart TVs, game consoles, and the web. Our platforms are designed to enhance core experiences like personalization, search, messaging, and data, ensuring that our audience enjoys seamless access to their favorite content. As a Data Engineer I, you will be instrumental in the success of our company by collaborating with business, analytics, and infrastructure teams to design and build data pipelines that measure subscriber movements and metrics. This role requires a collaborative approach, as you will work across disciplines to identify both internal and external data sources, design table structures, and define ETL strategies along with automated data quality checks. Your contributions will help us maintain the high standards of our data solutions, ensuring they are reliable and scalable in our fast-growing data ecosystem. In this position, you will partner with both technical and non-technical colleagues to understand data and reporting requirements, work with engineering teams to collect necessary data from various systems, and contribute to the design of table structures and ETL pipelines. You will also be responsible for developing and maintaining ETL routines using tools like Airflow, implementing database deployments, and performing ad hoc analyses as needed. Your expertise in SQL and ETL tuning will be essential in optimizing our data processes and ensuring the integrity of our data solutions.

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.
• Work with team on developing 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.

Requirements

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

Nice-to-haves

• Experience implementing and reporting on business key performance indicators in data warehousing environments.
• Knowledge of using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift).
• At least 1 year of experience programming languages (e.g. Python, Pyspark).
• Experience with data orchestration/ETL tools (Airflow, Nifi).
• Experience with Snowflake, Databricks/EMR/Spark, and/or Airflow.

Benefits

• Medical, financial, and/or other benefits depending on the level and position offered.