Snowflake dbt Data Migration Engineer

Elsevier; Philadelphia (Philadelphia County); Hybrid; USD 70,000 - 110,000; Part time

Job summary

A leading research and information analytics company is seeking a Data Migration Engineer in Philadelphia. This part-time role demands expertise in dbt and Snowflake, as well as proficiency in Python and AWS. The successful candidate will design and maintain data pipelines, ensuring seamless data integration across platforms. Apply your skills to help drive data-driven decision-making in a supportive team environment.

Qualifications

• Current experience with dbt and Snowflake is required.
• Extensive Python development skills for automation and data processing.
• Solid understanding of AWS services related to data engineering.
• Understanding of AWS data engineering services and Git basics.

Responsibilities

• Designing, implementing, and maintaining data pipelines using dbt and Snowflake.
• Developing and automating Python scripts for data transformation.
• Managing data workflows and deployments across AWS.
• Collaborate with teams for secure, efficient data integrations.
• Troubleshoot data pipelines and optimize performance.
• Apply CI/CD best practices in data workflows.
• Contribute to ETL orchestration using Matillion.

Skills

dbt

Snowflake

Python

AWS

SQL

Git

Tools

Matillion

Airflow

Dagster

Airflow

Dagster

AWS

Job description

Talent Acquisition Partner – Technology RELX

We’re looking for an experienced Data Migration Engineer with 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

Seniority level

Mid‑Senior level

Employment type

Part‑time

Job function

Information Technology

Industries

Technology, Information and Media

Location: Philadelphia, PA