Senior Data Engineer

Disneyland Hong Kong; Seattle, San Francisco, New York, Santa Monica (WA, CA, NY, CA); On-site; USD 145,000 - 195,000; Full time

Job summary

Disneyland Hong Kong is seeking a Senior Data Engineer to join their Commerce Data Solutions team. This role involves designing and building data pipelines, collaborating with various teams, and ensuring data quality. The ideal candidate will have extensive experience in data engineering and a solid understanding of data modeling principles. Join us to help shape the future of Disney’s media business and create magical experiences.

Qualifications

• 5+ years of relevant data engineering experience.
• Strong understanding of data modeling and SQL performance tuning.
• Bachelor’s Degree in computer science or related field.

Responsibilities

• Design and build data pipelines for measuring subscriber movements.
• Develop and maintain ETL routines using tools like Airflow.
• Collaborate with teams to understand data and reporting requirements.

Skills

Data modeling principles

SQL Engines

Analytic SQL

ETL processes

Agile Scrum principles

Education

Bachelor’s Degree in computer science

Tools

Airflow

Snowflake

Pyspark

Job description

On any given day at Disney Entertainment & ESPN Product & 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 Product & Technology:

Building the future of Disney’s media business: Our 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:

Commerce Data Solutions builds and maintains best in class data products enabling business teams to analyze and measure subscriber movements and support revenue generation initiatives. The Senior 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.

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.

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

Implement database deployments using tools like Schema Change

Perform ad hoc analysis as necessary.

Perform SQL and ETL tuning as necessary.

Basic Qualifications:

5+ years of relevant data engineering experience

Strong understanding of data modeling principles including dimensional modeling & data normalization principles.

Good understanding of SQL Engines and able to conduct advanced performance tuning.

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

2+ years of 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.

Excellent conceptual and analytical reasoning competencies.

Comfortable working in a fast-paced and highly collaborative environment.

Familiarity with Agile Scrum principles and ceremonies

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

Preferred Qualifications:

Masters Degree in a related field, and/or related certification/s

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

1+ years of experience with data orchestration/ETL tools (Airflow, Nifi)

Experience with Snowflake, Databricks/EMR/Spark, and/or Airflow.

#DISNEYTECH

工作概要:

On any given day at Disney Entertainment & ESPN Product & 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 Product & Technology:

• Building the future of Disney’s media business: Our 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:

Commerce Data Solutions builds and maintains best in class data products enabling business teams to analyze and measure subscriber movements and support revenue generation initiatives. The Senior 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.

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.

• 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

• Implement database deployments using tools like Schema Change

• Perform ad hoc analysis as necessary.

• Perform SQL and ETL tuning as necessary.

Basic Qualifications:

• 5+ years of relevant data engineering experience

• Strong understanding of data modeling principles including dimensional modeling & data normalization principles.

• Good understanding of SQL Engines and able to conduct advanced performance tuning.

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

• 2+ years of 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.

• Excellent conceptual and analytical reasoning competencies.

• Comfortable working in a fast-paced and highly collaborative environment.

• Familiarity with Agile Scrum principles and ceremonies

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

Preferred Qualifications:

• Masters Degree in a related field, and/or related certification/s

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

• 1+ years of experience with data orchestration/ETL tools (Airflow, Nifi)

• Experience with Snowflake, Databricks/EMR/Spark, and/or Airflow.

#DISNEYTECH

The hiring range for this position in Santa Monica, CA is $138,900 to $186,200 per year and in New York, NY and Seattle, WA is $145,400 to $195,000 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.

其他資訊:

DISNEYTECH

Disability Accommodation for Employment Applications

The Walt Disney Company and its Affiliated Companies are Equal Employment Opportunity employers and welcome all job seekers including individuals with disabilities and veterans with disabilities. If you have a disability and believe you need a reasonable accommodation in order to search for a job opening or apply for a position, visit the Disney candidate disability accommodations FAQs Link opens in new window . We will only respond to those requests that are related to the accessibility of the online application system due to a disability.