Data Engineer: Snowflake Migration & ETL Expert

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

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.