Data Engineer Snowflake migration

Liberty Personnel Services, Inc.; Radnor (Delaware County); Hybrid; USD 95,000 - 155,000; Full time

Job summary

Liberty Personnel Services, Inc. is seeking a hands-on Data Engineer to lead Snowflake migration efforts and design scalable ETL pipelines in a modern cloud environment. You will collaborate with stakeholders to build enterprise data platforms, optimize data models, and ensure data quality across the warehouse.

The role emphasizes strong SQL, Python/PySpark, and AI-driven improvements to data workflows, with an onsite-hybrid arrangement and regional monthly travel as needed.

Qualifications

• Experience building and optimizing enterprise ETL pipelines.
• Snowflake migrations and data warehouse architecture experience required.
• Advanced SQL development and performance tuning skills.
• Strong Python and PySpark capabilities.
• Deep understanding of data modeling, dimensional modeling, and DW structures.
• Experience with Azure Synapse Analytics, Azure Data Factory, and the Microsoft Azure stack.
• Experience integrating data from APIs and multiple enterprise systems.
• Hands-on experience applying AI technologies in data workflows.
• Excellent communication, presentation, and interpersonal skills.
• Ability to work independently while collaborating with technical and business teams.

Responsibilities

• Design, develop, and optimize scalable ETL pipelines using Python and PySpark.
• Support and enhance enterprise data warehouse solutions with dimensional modeling and star schemas.
• Help drive migration of enterprise data platforms to Snowflake.
• Develop high-performance SQL queries, stored procedures, and data transformations.
• Build and maintain data pipelines using Azure Synapse Analytics and Azure Data Factory.
• Integrate data from APIs, relational databases, and flat files.
• Ensure data quality, governance, security, and performance across the platform.
• Collaborate with business users, analysts, architects, and dev teams to deliver scalable solutions.
• Apply AI technologies and automation to improve data processing and analytics.
• Support reporting and analytics initiatives across the organization.

Skills

ETL design

Snowflake migrations

SQL development

Python

PySpark

Data modeling

Azure Synapse Analytics

Azure Data Factory

APIs integration

AI in data workflows

Communication skills

Independent contributor

Tools

Snowflake

Azure Synapse Analytics

Azure Data Factory

Python

PySpark

Job description

Data Engineer - Snowflake migration

Onsite Hybrid (regional monthly)

We are seeking a hands‑on ETL Data Engineer to design, build, and optimize enterprise data solutions in a modern cloud environment. This role requires someone with strong experience developing ETL pipelines, advanced SQL skills, expertise in data modeling and data warehouse architecture, and experience supporting or leading Snowflake migrations.

This is a highly collaborative position where technical expertise, communication skills, and the ability to work closely with business stakeholders are just as important as engineering ability. Experience applying AI technologies to improve data engineering workflows is highly desirable.

Responsibilities

• Design, develop, and optimize scalable ETL pipelines using Python and PySpark
• Support and enhance enterprise data warehouse solutions with strong dimensional modeling and star schema design
• Participate in and help drive the migration of enterprise data platforms to Snowflake
• Develop high-performance SQL queries, stored procedures, and data transformation processes
• Build and maintain data pipelines using Azure Synapse Analytics and Azure Data Factory
• Integrate data from APIs, relational databases, flat files, and other enterprise data sources
• Ensure data quality, governance, security, and performance across the data platform
• Collaborate with business users, analysts, architects, and development teams to deliver scalable data solutions
• Apply AI technologies and automation techniques to improve data processing and analytics
• Support reporting and analytics initiatives across the organization

Required Qualifications

• Strong experience building and optimizing enterprise ETL pipelines
• Experience with Snowflake migrations and Snowflake data warehouse architecture is required
• Advanced SQL development and performance tuning skills
• Strong experience with Python and PySpark
• Deep understanding of data modeling, dimensional modeling, and enterprise data warehouse structures
• Experience with Azure Synapse Analytics, Azure Data Factory, and the Microsoft Azure data platform
• Experience integrating data from multiple enterprise systems and APIs
• Hands‑on experience utilizing AI technologies within data engineering or analytics workflows
• Excellent communication, presentation, and interpersonal skills
• Ability to work independently while collaborating effectively with technical and business teams

Preferred Qualifications

• Experience with Git, Azure DevOps, and CI/CD pipelines
• Experience with Power BI or Tableau
• Knowledge of data governance, data quality, and cloud data architecture best practices

Why Join Us?

Join a growing organization investing heavily in modern data architecture and AI initiatives. You'll play a key role in designing scalable data solutions, leading Snowflake migration efforts, and building enterprise‑class ETL pipelines that power critical business decisions.