Sr Data Engineer

Overview

On Site
USD 136,038.00 - 182,490.00 per year
Full Time

Skills

Data Analysis
Data acquisition
Data engineering
Requirements elicitation
Data validation
Amazon S3
Apache Airflow
Relational databases
Big data
SQL
Software development
Computer science
Streaming
Digital marketing
Data warehouse
Data
Science
Analytics
Media
Distribution
Television
Optimization
Modeling
Extract
transform
load
ELT
Database
POC
Scripting
Software deployment
Quality assurance
Acceptance testing
Python
Docker
gitlab
Snow flake schema
PostgreSQL
Cloud computing
Amazon Web Services
Databricks
GitHub
Tableau
Mathematics
Recruiting
Finance

Job Details

The Disney Decision Science and Integration (DDSI) analytics consulting team is responsible for supporting clients across The Walt Disney Company including Disney Parks, Experiences and Products (e.g., Walt Disney World, Disneyland, Disney Cruise Line), Disney Media & Entertainment Distribution (e.g., Disney+, ESPN+, Hulu), Studios Content (e.g., The Walt Disney Studios, Disney Theatrical Group), General Entertainment Content (e.g., 20th Television, ABC Entertainment, ABC News) and ESPN and Sports Content. DDSI leverages technology, data analytics, optimization, statistical and econometric modeling to explore opportunities, shape business decisions and drive business value.

The team is involved in various activities ranging from data acquisition and validation, designing and implementing ETL/ELT data pipelines, designing and implementing databases, and evolving our next generation data platform to fulfill the needs of our applications, data services, ad-hoc analytics and self-service/POC initiatives.

Responsibilities

The Data Engineering team (within DDSI) is looking to fill a Senior Data Engineer role responsible for designing and implementing ETL/ELT data pipelines, designing and implementing database schema/tables/views, and building batch processes leveraging Airflow for several projects.

This Senior Data Engineer will be responsible for partnering with our Studios or Enterprise Technology team members in various activities around data requirements gathering, data validation scripting and review, developing and monitoring ETL/ELT data pipelines, designing and implementing database schema/tables/views, plus deployment across multiple environments such as DEV, QA/UAT and PROD.

The role will leverage a multitude of technologies to fulfill the work including, but not limited to SQL, Python, Docker, Gitlab, Airflow, Snowflake, Looker and PostgreSQL.

Basic Qualifications:
  • 3+ years experience with Python
  • 4+ years experience with SQL
  • 3+ years experience designing, building and maintaining ETL/ELT data pipelines
  • 2+ years experience with cloud based technologies, preferably AWS and S3
  • Experience using Apache Airflow, Databricks
  • 2+ years leveraging, designing and building relational databases
  • 2+ years of experience using Gitlab/Github
  • Experience working with large datasets and big data technologies, preferably cloud-based, such as Snowflake, Databricks, or similar
  • Experience with SQL Query optimization based on runtime and cost
  • Participate in driving best practices around data engineering software development processes

Preferred Qualifications
  • Experience with Snowflake, Airflow, Gitlab, , Tableau
  • Master's degree in Computer Science, Mathematics, Engineering, or a related field
  • Experience in streaming, media, or digital marketing domain

Minimum Qualifications
  • Bachelor degree in Computer Science, Mathematics, Engineering, or a related field
  • Must have 5+ years experience in a Data Engineering role in the field and not including academic experience.
  • SQL, Python, Snowflake, Gitlab, Airflow, AWS S3 and Relational Databases
  • 2+ years experience working on a cloud platform
  • 2+ years experience working with data lakes, data warehouses and application databases

The hiring range for this position in Burbank is $136,038 - $182,490 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.

About The Walt Disney Company