Logo of Huzzle

Home

Matches

Explore

Manage

Data Engineer II

image

The Walt Disney Company

Aug 13, 2024

Applications are closed

  • Job
    Full-time
    Mid Level
  • Santa Monica

Requirements

  • Basic Qualifications
  • 3+ years of relevant data engineering experience.
  • 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
  • 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.

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

FAQs

What is the primary focus of the Data Engineer II role at Disney Entertainment & ESPN Technology?

The primary focus is to design and build data pipelines that facilitate measuring subscriber movements and metrics while collaborating with business, analytics, and infrastructure teams.

What type of experience is required for this position?

A minimum of 3 years of relevant data engineering experience is required.

What qualifications are preferred for this role?

Preferred qualifications include 2+ years of experience in implementing and reporting on business key performance indicators in data warehousing environments, experience with analytic SQL, and programming languages such as Python or Pyspark, among others.

What educational background is needed to apply for this position?

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

Are there opportunities for growth within the team?

Yes, by working on innovative products and collaborating with various teams, there are numerous opportunities for professional development and growth.

What tools and technologies will the Data Engineer II work with?

The role involves working with ETL and orchestration tools such as Airflow, SQL databases, and possibly tools like Snowflake, Databricks, or EMR/Spark.

How important are communication skills for this position?

Strong communication skills, both written and verbal, are crucial for collaborating with technical and non-technical colleagues and presenting findings effectively.

Is prior experience with Agile practices important for this role?

Yes, familiarity with Agile Scrum principles and ceremonies is considered beneficial for the position.

What is the hiring range for the Data Engineer II position?

The hiring range varies by location; for example, it is $102,500 to $137,500 in Santa Monica, CA, and $112,300 to $144,000 in San Francisco, CA.

Do Data Engineer II employees have the opportunity to perform ad hoc analysis?

Yes, performing ad hoc analysis as necessary is part of the responsibilities of the role.

image

The Walt Disney Company

Entertainment & Media
Industry
10,001+
Employees

Mission & Purpose

From classic animated features and exhilarating theme park attractions to cutting edge sports coverage, and the hottest shows on television, The Walt Disney Company has been making magic since 1923, creating unforgettable stories that connect with audiences around the world. And we’re just getting started! The key to our success…. The Cast, Crew, Imagineers and Employees who honor Disney’s rich legacy by stretching the bounds of imagination to create the never-before-seen, bringing unparalleled entertainment experiences to people of all ages. Begin a career that delivers unparalleled creative content and experiences to audiences around the world and just imagine the stories you could be part of… What is #LifeAtDisney like? It’s a series of magical moments with cast members and employees developing and telling our stories in the most innovative ways. Whether it’s a day spent as a Disney VoluntEAR, or celebrating the release of a new interactive experience, retail product or movie, our days are filled with the knowledge that we are creating entertainment experiences the whole family can enjoy. Follow @DisneyCareers on Facebook, Twitter and Instagram for a peek behind-the-curtain, and discover how you could connect to a world of stories with Disney!