Sr. Data Engineer

工作概要:

This role is based out of the Burbank are and will require relocation if not local. This is not a remote role.

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
• 5+ years experience in a Data Engineering role in the field not counting 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,100.00 to $160,000.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.