Job description
*** This role requires someone to work out of the Disney offices 4 days/week and may require relocation***
The Disney Decision Science and Integration (DDSI) 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.
What you will do:
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.
What you will need:
- 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
- 3+ years experience in a Data Engineering role
- SQL, Python, 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
- Experience using Apache Airflow, Databricks
- 2+ years leveraging, designing and building relational databases
- 2+ years of experience using Gitlab/Github
- 2+ years of experience using Docker
- Experience working with large datasets and big data technologies, preferably cloud-based, such as Snowflake, Databricks, or similar
- Participate in driving best practices around data engineering software development processes
What will set you apart:
- Experience with Airflow, Gitlab, Snowflake, Tableau
- Master’s degree in Computer Science, Mathematics, Engineering, or a related field
- Experience in streaming, media, or digital marketing domain
Minimum Qualifications & Education
- Bachelor degree in Computer Science, Mathematics, Engineering, or a related field
- 3+ years experience in a Data Engineering role
- SQL, Python, 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 California is $ $136,038.00-$182,490.00 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.