About the role
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.
Requirements:
- Minimum and Preferred. Inclusive of Licenses/Certs (include functional experience as well as behavioural attributes and/or leadership capabilities)
- 5+ years of relevant data engineering experience.
- Strong understanding of data modelling principles, including Dimensional modeling data normalisation principles.
- Good understanding of SQL Engines and able to conduct advanced performance tuning.
- Ability to think strategically, analyse, 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
Preferred Qualifications:
- 2+ years of work experience implementing and reporting on business key performance indicators in data warehousing environments, required.
- 2+ years of experience using analytic SQL, working with traditional relational databases and/or distributed systems (Snowflake or Redshift), required.
- 1+ years of experience with programming languages (e. g., Python, Pyspark), preferred.
- 1+ years of experience with data orchestration/ETL tools (Airflow, NiFi), preferred.
- Experience with Snowflake, Databricks/EMR/Spark, and/or Airflow.
- Bachelor's Degree in computer science, information systems, or a related field or equivalent work experience.