Fast Facts

Join Elsevier as a Data Migration Engineer, specializing in Snowflake and dbt to design and optimize scalable data pipelines in AWS.

Responsibilities: Key responsibilities include designing and maintaining data pipelines, developing Python scripts for data processing, managing workflows in AWS, troubleshooting performance issues, and contributing to CI/CD practices.

Skills: Proficiency in dbt, Snowflake, Python, SQL, and familiarity with AWS services and ETL tools like Matillion are essential.

Qualifications: Current and extensive experience in dbt and Snowflake is required, along with knowledge of workflow orchestration frameworks and collaborative development practices.

Location: This is a home-based position in Pennsylvania, United States.

Compensation: $70200 - $117100 / Annually

Are you an experienced Data Migration Engineer with an expertise in Snowflake and dbt (Data Build Tool)

About the role, we are seeking a Data Migration Specialist with extensive experience in dbt (Data Build Tool) and Snowflake, and solid proficiency in Python within the AWS ecosystem. The role involves developing, maintaining, and optimizing scalable data pipelines and integrations that enable data-driven decision-making across platforms. Please do not apply without current and extensive dbt and Snowflake.

About the team, this diverse team provides post-sale technical support services to our University customers, including installation, troubleshooting, problem resolution and maintenance of products and services.

Key Responsibilities

• Designing, implementing, and maintaining data pipelines using dbt and Snowflake
• Developing and automating Python scripts for data transformation, validation, and delivery
• Managing data workflows and deployments across the AWS ecosystem (S3, Lambda, ECS, IAM, etc.)
• Collaborating with internal and external teams to deliver efficient, secure data integrations
• Troubleshooting and resolving data pipeline or performance issues
• Applying best practices for CI/CD, testing, and version control in data workflows
• Contributing to ETL orchestration and scheduling using Matillion

Required Skills & Experience

• Possess current experience with dbt and Snowflake (required). Please do not apply with this experience.
• Experience with Matillion ETL or similar data orchestration tools
• Familiarity with Airflow, Dagster, or other workflow orchestration frameworks
• Have current and extensive Python development skills for automation and data processing
• Possess a solid understanding of AWS services related to data engineering
• Experience with SQL, schema design, and performance optimization
• Possess familiarity with Git and collaborative development practices

Elsevier employs 10,000 people worldwide, including over 2,500 technologists. We have supported the work of our research and health partners for more than 140 years. Growing from our roots in publishing, we offer knowledge and valuable analytics that help our users make breakthroughs and drive societal progress.

Digital solutions such as ScienceDirect, Scopus, SciVal, ClinicalKey and Sherpath support strategic research management, R&D performance, clinical decision support, medical education, and nursing education. Researchers and healthcare professionals rely on over 2,800 journals, including The Lancet and Cell; 46,000+ eBook titles; and iconic reference works, such as Gray's Anatomy. With the Elsevier Foundation and our external Inclusion & Diversity Advisory Board, we work in partnership with diverse stakeholders to advance inclusion and diversity in science, research and healthcare in developing countries and around the world. 

U.S. National Base Pay Range: $70,200 - $117,100. Geographic differentials may apply in some locations to better reflect local market rates. This job is eligible for an annual incentive bonus. We know that your wellbeing and happiness are key to a long and successful career. These are some of the benefits we are delighted to offer: ● Health Benefits: Comprehensive, multi-carrier program for medical, dental and vision benefits ● Retirement Benefits: 401(k) with match and an Employee Share Purchase Plan ● Wellbeing: Wellness platform with incentives, Headspace app subscription, Employee Assistance and Time-off Programs ● Short-and-Long Term Disability, Life and Accidental Death Insurance, Critical Illness, and Hospital Indemnity ● Family Benefits, including bonding and family care leaves, adoption and surrogacy benefits ● Health Savings, Health Care, Dependent Care and Commuter Spending Accounts ● In addition to annual Paid Time Off, we offer up to two days of paid leave each to participate in Employee Resource Groups and to volunteer with your charity of choice

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.