Snowflake Data Engineer

Liberty Personnel Services, Inc.; West Conshohocken (PA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Liberty Personnel Services, Inc. is seeking a hands-on Data Engineer to design, build, and optimize enterprise data solutions in a modern cloud environment.

The role focuses on ETL pipelines, Snowflake migrations, and data warehouse architecture, with emphasis on advanced SQL, Python, and PySpark. You'll collaborate closely with business stakeholders and analytics teams to deliver scalable data solutions, apply AI techniques to improve workflows, and support reporting initiatives across the

Qualifications

• Experience building enterprise ETL pipelines.
• Experience with Snowflake migrations and data warehouse architecture.
• Advanced SQL development and performance tuning.
• Hands-on Python and PySpark experience.
• Strong data modeling, including dimensional modeling.
• Experience with Azure Synapse Analytics and Azure Data Factory.
• Experience integrating data from multiple enterprise sources and APIs.
• Hands-on AI in data engineering workflows is a plus.
• Excellent communication and collaboration skills.
• Ability to work independently while collaborating with teams.

Responsibilities

• Design, develop, and optimize scalable ETL pipelines using Python and PySpark.
• Support data warehouse solutions with dimensional modeling and star schema.
• Drive migration of enterprise data platforms to Snowflake.
• Develop high-performance SQL queries and data transformations.
• Build 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 developers.
• Apply AI technologies to improve data processing and analytics.
• Support reporting and analytics initiatives across the organization.

Skills

ETL pipelines

Advanced SQL

Python

PySpark

Data modeling

Communication

Independent work

Tools

Snowflake migrations

Snowflake data warehouse

Azure Synapse Analytics

Azure Data Factory

APIs integration

Git

Azure DevOps

CI/CD

Power BI

Tableau

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.