Disney Entertainment and ESPN Product & Technology is seeking a Data Engineer to design, build, and maintain data structures for reporting and monitoring key performance indicators, facilitating reporting and monitoring of key performance indicators across various Disney media businesses.
Requirements
- 1+ years work experience implementing data warehousing environments.
- Strong grasp of data modeling principles such as Dimensional modeling and data normalization principles, among others.
- 1+ year(s) experience using analytic SQL, working with traditional relational databases and/or distributed systems such as Hadoop / Hive, Snowflake , Databricks etc
- Experience programming languages (e.g. Python, R, bash) preferred.
- 1+ years of experience with workflow management tools (Airflow)
- Good understanding of SQL Engines and able to conduct advanced performance tuning
- Experience with Databricks, snowflake (or similar) Ecosystem
Responsibilities
- Design table structures and define ETL strategy to build performant Data solutions that are reliable and scalable in a fast growing data ecosystem.
- Develop Data Quality checks for source and target data sets.
- Develop UAT plans and conduct QA.
- Develop and maintain ETL routines using ETL and orchestration tools such as Airflow, Luigi and Jenkins.
- Perform ad hoc analysis as necessary.
- Perform SQL and ETL tuning as necessary.
- Develop and maintain Dashboards/reports using Tableau and Looker
Other
- Partner with technical and non-technical colleagues to understand data and reporting requirements.
- 3+ years of relevant Professional experience.
- Strong communication skills – written and verbal presentations.
- Comfortable working in a fast-paced and highly collaborative environment.
- Bachelor’s Degree in Computer Science, Information Systems or related field
