Senior Data Engineer - Commerce Data Solutions

Disney Entertainment and ESPN Product and TechnologyTechnology is at the heart of Disney’s past, present, and future. Disney Entertainment and ESPN Product and Technology (DEEPandT) is a global organization of engineers, product developers, designers, technologists, data scientists, and more – all working to build and advance the technological backbone for Disney’s media business globally.

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

Here are a few reasons why we think you’d love working here:

Building the future of Disney’s media:

Our Technologists are designing and building the products and platforms that will power our media, advertising, and distribution businesses for years to come.

Reach, Scale and Impact:

More than ever, Disney’s technology and products serve as a signature doorway for fans'' connections with the company’s brands and stories. Disney+. Hulu. ESPN. ABC. ABC News… and many more. These products and brands – and the unmatched stories, storytellers, and events they carry – matter to millions of people globally.

Innovation:

We develop and implement groundbreaking products and techniques that shape industry norms, and solve complex and distinctive technical problems.

Commerce, Data and Identity (CDI) provides the core product management functions for areas crucial to Disney’s media businesses. These include initiatives and products that power digital commerce, identity, and growth, as well as those that reach uniquely across The Walt Disney Company enterprise, such as messaging and privacy, among others. Additionally, it is responsible for the data engineering, science, and products for Disney Entertainment and ESPN, along with their interconnection with other parts of The Walt Disney Company.

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

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

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

Additional Information#DISNEYTECH

#CDI

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