Senior Data Warehouse Engineer

## .**Are you enthusiastic about** **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).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** **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 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** **.**Please read our .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:***. **Senior Data Warehouse Engineer**Elsevier is a global leader in advanced information and decision support for science and healthcare. We believe that by working together with the communities we serve, we can shape human progress to go further, happen faster, and benefit all.We support continuous discovery and uphold the highest standards of content integrity, reliability, and reproducibility so the communities we serve can advance their field of science, healthcare or innovation with confidence. By combining high-quality content with powerful analytics, we transform complexity into clarity and deliver mission-critical insights that help professionals make better decisions when it matters most.We deliver insights that help research institutions, governments, and funders achieve their goals. We help researchers discover and share knowledge, collaborate, and accelerate innovation. We help librarians provide verified, quality information to universities. We help innovators turn knowledge into new products. We help health professionals improve patient care and educators train the next generation of doctors and nurses. Connecting quality content and innovative technologies, we make progress go further and happen faster. And by championing inclusion and sustainability, we ensure progress benefits all.With 9,500 employees, over 2,300 technologists in 5 major tech hubs, and more than 60 locations across the globe, we are committed to supporting the scientific and healthcare communities around the world.#J-18808-Ljbffr…