Data Engineer - Snowflake migration

Liberty Personnel Services, Inc.; Harmonville (PA); On-site; USD 110,000 - 150,000; Full time

Job summary

Liberty Personnel Services, Inc. is seeking a hands-on ETL Data Engineer to design, build, and optimize enterprise data solutions in a modern cloud environment. The role requires strong ETL skills, SQL prowess, and expertise in data warehousing and Snowflake migrations.

You will collaborate with stakeholders to deliver scalable data pipelines and analytics. The position emphasizes collaboration, communication, and applying AI techniques to improve data engineering workflows and reporting

Qualifications

• Hands-on experience building and optimizing enterprise ETL pipelines.
• Experience with Snowflake migrations and Snowflake data warehouse architecture.
• Advanced SQL development and performance tuning skills.
• Strong Python and PySpark skills.
• Deep understanding of data modeling, dimensional modeling, and enterprise data warehouses.

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.
• Assist in migrating enterprise data platforms to Snowflake.
• Develop high-performance SQL queries and data transformations.
• Build data pipelines using Azure Synapse Analytics and Azure Data Factory.
• Collaborate with business users and analytics teams to deliver scalable data solutions.
• Apply AI technologies to improve data processing and analytics.

Skills

ETL pipelines

SQL development

Data modeling

Azure data platform

AI in data workflows

Python

PySpark

Snowflake migrations

Dimensional modeling

Collaboration with stakeholders

Tools

Snowflake

Azure Synapse Analytics

Azure Data Factory

Python

Power BI

Job description

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.