Key skills
PythonSQLETLData EngineeringData WarehousingAnalyticsBISnowflakeAirflowdbtFivetranAWSGlueOracleAgileScrumKanbanCI/CDCollaboration
About this role
Job Description
Would you like to be part of a team that delivers high-quality software to our customers?
Are you a highly visible champion with a ‘can do’ attitude and enthusiasm that inspires others?
About Our Team
Our global team supports products in electronic health records that introduce students to digital charting and prepare them to document care in today’s modern clinical environment. We have a very stable product that we strive to maintain. Our team values trust, respect, collaboration, agility, and quality.
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 Operations BI team is responsible for the Production Data load and ongoing enhancements/development of Journals Data Warehouse, Books Data Warehouse, Oracle Service Cloud Analytics Reporting (OSCAR) Data Warehouse, Platform intelligence, and technology support for Celonis.
As part of Digital Business Solutions (DBS) organization, we work closely in partnership with the Operations Data Management business team to provide timely insight that allows Elsevier to act and meet existing and emerging customer needs and expectations. We support these insights through the provision of data warehouses built for our Journals and Books businesses, and our Customer Support division. This includes day-to-day development and support as well as developing long-term solutions for sustained high quality data and analytics.
This role will be based in the Chennai, India office working alongside the technical lead and business stakeholders based in Oxford, UK and the Amsterdam, Netherlands (although everyone is currently working remotely). The business consumers of the insights are based around the globe.
About the Role
As a Data Engineer in the Operations Business Insights team, you will be responsible for
developing new data pipelines, data migrations and supporting existing data pipelines that load data from various source systems into our Data Mesh.
Responsibilities
Work closely with product owners, tech lead, architects, and data analysts on new data initiatives.
Operate in an agile working environment while collaborating with key stakeholders.
Follow development processes, coding best practices and perform code reviews.
Write and review portions of detailed specifications for the development of data components of moderate complexity.
Work closely with other development team members to understand complex product requirements and translate them into data pipeline designs.
Write comprehensive documentation to facilitate easy understanding, discovery, and reuse by other teams, fostering a culture of knowledge sharing.
All other duties as assigned.
Requirements
We are looking for someone with:
Datawarehouse, SQL, Snowflake, DBT, Python, AWS Glue, Fivetran, Astronomer
Overall Work Exp: 4~5 Years
Expertise in data warehousing, ETL and SQL i.e. data engineering.
Ability to do deep troubleshooting and SQL Optimization.
Strong understanding of dbt cloud for data transformation.
Experience with data migration projects.
Experience supporting, developing, and enhancing data pipelines using AWS Glue, Python and Snowflake.
Proven experience configuring, managing, and optimizing Fivetran connectors, including troubleshooting ingestion failures
Experience in orchestration tools – Airflow/Astronomer.
Experience in release management using CI/CD pipelines.
Experience in Agile software development, with familiarity of Scrum and Kanban ceremonies and artefacts.
Able to work in a team with people from all backgrounds.
Possesses strong analytical and problem-solving skills.
Able to effectively communicate across all levels of the organization.
Database modelling & design (desirable)
Work in a Way that Works for You
We promote a healthy work-life balance across our organization. We offer various well-being initiatives, shared parental leave, study assistance, and sabbaticals to help you meet both your immediate responsibilities and long-term goals.
Working for You
We understand that your well-being and happiness are essential to a successful career. Here are some benefits we offer:
Comprehensive Health Insurance covers you and your immediate family.
Enhanced Health Insurance Options with competitive rates.
Group Life Insurance ensuring financial security for your loved ones.
Group Accident Insurance offering extra protection.
Flexible Working Arrangements to achieve a balanced work-life schedule.
Employee Assistance Program providing support for personal and work-related challenges.
Medical Screening prioritizing your well-being.
Modern Family Benefits including parental and adoption support.
Long-Service Awards recognizing dedication and commitment.
Celebratory New Baby Gift.
Subsidized Meals (location-specific).
Various Paid Time Off options including Casual Leave, Sick Leave, Privilege Leave, Compassionate Leave, Special Sick Leave, and Gazetted Public Holidays.
Free Transport for home-office-home commutes (location-specific).
About the Business
A global leader in information and analytics, we assist researchers and healthcare professionals in advancing science and improving health outcomes for society's benefit. Leveraging our publishing heritage, we combine quality information and extensive data sets with analytics to support visionary science and research, health education, and interactive learning. At Elsevier, your work contributes to addressing the world's grand challenges and fostering a sustainable future. We utilize innovative technologies to support science and healthcare, partnering 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: