Posted in

Senior Data Engineer

Senior Data Engineer

CompanyThe Walt Disney Company
LocationSeattle, WA, USA, Santa Monica, CA, USA, Glendale, CA, USA
Salary$138900 – $195000
TypeFull-Time
DegreesBachelor’s, Master’s
Experience LevelSenior

Requirements

  • 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.
  • 2+ years of work experience implementing and reporting on business key performance indicators in data warehousing environments
  • 2+ years of experience using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift)
  • 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
  • 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.
  • 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.

Preferred Qualifications

  • Masters Degree in a related field
  • Related certification/s
  • 1+ years of experience programming languages (e.g. Python, Pyspark)
  • 1+ years of experience with data orchestration/ETL tools (Airflow, Nifi)
  • Experience with Snowflake, Databricks/EMR/Spark, and/or Airflow.