Senior Data Warehouse Engineer

Location: Oxford

Time Type: Full time

Job Description

                                       Senior Data Warehouse Engineer   

                    Are you enthusiastic about building strong partnerships? 
Do you thrive on negotiating deals and driving value through vendor relationships? 
                                 

About the team: 

Elsevier is an analytics company with the mission of “Helping Researchers & Healthcare Professionals Advance Science & Improving Health Outcomes for the Benefit of Society”. The value and quality of Elsevier’s content and supporting data are critical to the success of this mission. The STMJ (Science Technology Medical Journals) Business Intelligence squad is responsible for the enhancement/development of the STMJ Data Warehouse and other related products. 

About the role:   

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.

 Key responsibilities: 

• 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).

Why join us? 

Join our team and contribute to a culture of innovation, collaboration, and excellence. If you are ready to advance your career and make a significant impact, we encourage you to apply. 

Work in a way that works for you 
 

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) 

 
About the business – 

A global leader in information and analytics, we help researchers and healthcare professionals advance science and improve health outcomes for the benefit of society. Building on our publishing heritage, we combine quality information and vast data sets with analytics to support visionary science and research, health education and interactive learning, as well as exceptional healthcare and clinical practice. At Elsevier, your work contributes to the world’s grand challenges and a more sustainable future. We harness innovative technologies to support science and healthcare to partner for a better world.

We know your well-being and happiness are key to a long and successful career. We are delighted to offer country specific benefits. Click here to access benefits specific to your location.

We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form or please contact 1-855-833-5120.

Criminals may pose as recruiters asking for money or personal information. We never request money or banking details from job applicants. Learn more about spotting and avoiding scams here.

Please read our Candidate Privacy Policy.

We are an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law.

USA Job Seekers:

EEO Know Your Rights.