Senior Data Warehouse Engineer
Role details
Job location
Tech stack
Job description
This role will be responsible for designing and developing the STMJ data warehouse and building new data pipelines. This role involves working closely with product owners, architects, data analysts, and data scientists on new data initiatives. You will have the opportunity to work with cloud technologies and modern ETL tools.
This role will be based in Oxford, and you will report to the Software Engineering Lead., * Deliver moderately complex engineering work independently, with support available for more advanced initiatives.
- Contribute to design and architectural decisions across the data warehouse ecosystem.
- Collaborate with cross-functional partners-including product owners, analysts, data scientists, and architects-to translate business needs into scalable data solutions.
- Design and build data ingestion pipelines for a variety of data sources.
- Ensure data pipelines and warehouse components meet operational standards for logging, monitoring, instrumentation, and alerting.
- Support the reliability, performance, and evolution of the STMJ Data Warehouse and related data products.
- Monitor, investigate, and resolve data warehouse incidents in a timely manner.
- Maintain exacting standards of code quality, maintainability, and engineering best practices.
- Develop and maintain comprehensive unit tests and contribute to testing scenarios for peer work.
- Provide guidance to less experienced engineers on ETL patterns, SQL best practices, and data modelling techniques.
Requirements
- Good years of experience in data warehousing, ETL, and SQL (equivalent experience welcomed).
- Degree in Engineering, Computer Science, or equivalent practical experience.
- Clear and effective communication skills across technical and non-technical audiences.
- Ability to understand and discuss technical concepts at an elevated level.
- Strong organizational and time management skills.
- Broad understanding of software development methodologies, tools, and languages.
- Ability to build strong working relationships across teams.
- Strong analytical and critical thinking skills.
- Experience working in Agile environments and familiarity with tools such as Jira, Confluence, and CI/CD practices.
Technical Skills
Essential
- Strong understanding of data warehousing concepts (e.g., Kimball).
- Experience designing, developing, and enhancing data warehouses.
- Hands-on experience with ETL tools and processes (e.g., DBT, Astronomer/Apache Airflow, AWS Glue). Cross-training available.
- Proficiency in writing complex SQL for data extraction and transformation.
- Experience creating dimensional data models.
Desirable
- Experience with Snowflake (training available).
- Experience developing automated tests.
- Familiarity with AWS services (e.g., Glue, S3, Lambda, IAM, SNS, Secrets Manager).
- Experience programming in Python.
- Experience with Terraform.
- Understanding of release management and CI/CD pipelines (e.g., Jenkins).
Benefits & conditions
We promote a healthy work/life balance across the organization. We offer an appealing working prospect for our people. With numerous wellbeing initiatives, shared parental leave, study assistance, and sabbaticals, we will help you meet your immediate responsibilities and your long-term goals.
Working flexible hours - flexing the times when you work in the day to help you fit everything in and work when you are the most productive.
Working for you
We know that your well-being and happiness are key to a long and successful career. These are some of the benefits we are delighted to offer:
-
Comprehensive Pension Plan
-
Home, office, or commuting allowance.
-
Generous vacation entitlement and option for sabbatical leave
-
Maternity, Paternity, Adoption, and Family Care leave
-
Flexible working hours
-
Personal Choice budget
-
Internal communities and networks
-
Various employee discounts
-
Recruitment introduction reward
-
Employee Assistance Program (global)
