Lead Data Engineer
The Walt Disney Company
full-time
Posted on:
Location Type: Hybrid
Location: Santa Monica • California, New York, Washington • 🇺🇸 United States
Visit company websiteSalary
💰 $152,200 - $204,100 per year
Job Level
Senior
Tech Stack
AirflowAmazon RedshiftDistributed SystemsETLPySparkPythonSparkSQL
About the role
- Lead the successful design and implementation of complex technical problems.
- Lead and contribute to the design and growth of our Data Products and Data Warehouses around Content movements and metrics.
- Use sophisticated analytical thought to exercise judgement and identify innovative solutions.
- Partner with technical and non-technical colleagues to understand data and reporting requirements.
- Collaborate with Data Product Managers, Data Architects and other Data Engineers to design, implement, and deliver successful data solutions.
- 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.
- Serve as an advanced resource to other Data Engineers on the team, and mentor and coach more junior members of the team helping to improve their skills, knowledge, and productivity.
Requirements
- 7+ years of data engineering experience developing large data pipelines.
- Strong understanding of data modeling principles including Dimensional modeling, data normalization principles.
- Good understanding of SQL Engines and able to conduct advanced performance tuning.
- 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.
- 4+ years of work experience implementing and reporting on business key performance indicators in data warehousing environments, required.
- 5+ years of experience using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift), required.
- 3+ years of experience programming languages (e.g. Python, Pyspark), preferred.
- 3+ years of experience with data orchestration/ETL tools (Airflow, Nifi), preferred.
- Experience with Snowflake, Databricks/EMR/Spark & Airflow a plus.
Benefits
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data engineeringdata modelingDimensional modelingdata normalizationSQLperformance tuninganalytic SQLETLdata orchestrationdata quality checks
Soft skills
analytical reasoningstrategic thinkingcommunicationcollaborationmentoringcoachingproblem-solvingjudgmentinnovationadaptability