ETL Data Engineer Python Snowflake Job at Liberty Personnel Services, Inc., Bala Cynwyd, PA

WEZCa01UeXFpVVBOQ2ZLeTc2Nm9BaHVi
  • Liberty Personnel Services, Inc.
  • Bala Cynwyd, PA

Job Description

Job Details:

ETL Data Engineer (Python / PySpark / Azure Synapse)
Location: Hybrid 

Position Overview

We are seeking a hands-on Data Engineer to join a growing organization focused on building and optimizing scalable, cloud-native data pipelines. This role is centered on designing and delivering robust ETL solutions using Python, PySpark, and Microsoft Azure data services, with a strong emphasis on modern data warehouse architecture and high-performance data processing.

The environment is evolving toward a Snowflake-based architecture in the next 6 months, so experience with or exposure to cloud data platform migrations is a strong plus.

Key Responsibilities

  • Design, build, and maintain scalable ETL data pipelines using Python and PySpark
  • Develop and optimize ETL workflows within Microsoft Azure ecosystem
  • Leverage Azure Synapse Analytics for pipelines, notebooks, and distributed data processing
  • Build and manage data workflows using Azure Data Factory, including linked services, triggers, and monitoring
  • Develop secure and efficient data solutions leveraging Azure Key Vault
  • Integrate data from multiple sources including REST APIs, relational databases, flat files (CSV), and external systems
  • Design and implement scalable data warehouse models using star schema and dimensional modeling best practices
  • Ensure data quality, governance, lineage, security, and performance tuning across pipelines
  • Collaborate closely with data architects, analysts, and business stakeholders to translate requirements into scalable data solutions
  • Support reporting and analytics use cases across tools such as Power BI and Tableau
  • Participate in modernization efforts including lakehouse architectures, Git-based development, and Azure DevOps CI/CD workflows
  • Explore and apply hands-on AI/ML techniques for data enrichment and automation where applicable

Required Skills & Experience

  • Strong hands-on experience with Python and PySpark
  • Deep expertise in ETL pipeline development and optimization
  • Strong SQL skills with experience in complex query development and tuning
  • Solid understanding of data warehousing concepts, including dimensional modeling and star schema design
  • Experience working in Microsoft Azure data ecosystem, including Synapse and related services
  • Familiarity with data lake / lakehouse architectures
  • Experience integrating diverse data sources (APIs, databases, files)
  • Strong understanding of data quality, governance, and performance optimization principles
  • Excellent communication skills with ability to work directly with technical and non-technical stakeholders
  • Strong interpersonal skills and ability to thrive in a collaborative, fast-paced environment

Nice to Have

  • Exposure to Snowflake or cloud data warehouse migrations (expected platform transition within ~6 months)
  • Experience with Git, Azure DevOps, or CI/CD pipelines
  • Familiarity with Power BI or Tableau
  • Experience applying AI/ML techniques in data engineering workflows

Why This Role

This is a high-impact engineering role in a modern data environment where you will help shape the evolution of enterprise data architecture—from Azure Synapse-based systems toward a next-generation Snowflake-centric platform. You will work across engineering, analytics, and business teams in a highly collaborative and technically forward-thinking organization.

To apply, p lease submit your resume to  bk@libertyjobs.com

Please add me on LinkedIn — I look forward to connecting with you.

Boyd Kelly
Liberty Personnel Services

484-567-2099
bk@libertyjobs.com

Jobs: 
LinkedIn: 

#libertyjobs
#IT
#midsenior
#LI-hybrid

#LI-BK1

Job Tags

Similar Jobs

O2B Early Education

Preschool Teacher / Lead Teacher Job at O2B Early Education

 ...required. CDA, Associates Degree, or higher (preferred but not required) CPR/First Aid Experience working with children 0-13 years-old (preferred but not required) We are willing to train! Benefits ~50% off of preschool or afterschool tuition for full-time... 

THE EDUCATIONAL EQUALITY INSTITUTE

Volunteer Opportunity: English Teachers for Ukrainian Parliamentary Staff Job at THE EDUCATIONAL EQUALITY INSTITUTE

The Educational Equality Institute (TEEI), in partnership with the Verkhovna Rada (Ukrainian Parliament), seeks passionate Volunteer English Teachers to deliver engaging online English language training sessions for Ukrainian parliamentary staff. Volunteers will play a...

Gulf Distributing Services

Warehouse Order Puller Job at Gulf Distributing Services

JOB SUMMARYThe Warehouse Order Pullers are responsible for efficient, safe, and accurate loading of the delivery trucks and performing...  ...environment is usually quiet.6. Occasionally (more than 10%) weekend and/or overtime work. Equal Employment Opportunity Policy... 

Infinity Quest UK

Agile Consultant/Agile Coach Job at Infinity Quest UK

 ...About the client/Project (optional) The German Insurance client's Sales and CRM Train is looking for support from an Agile consultant/coach. As the train has matured over the years it has moved further away from agile principles and the essence of the SAFe framework... 

Assurity Transportation Solutions

Owner Operator CDL A Dedicated Home Weekends Job at Assurity Transportation Solutions

 ...deserve along with the pay you deserve.. No Forced Dispatch Dedicated Customer accounts, contract freight, general freight, drop...  ...NOW for an Amazing year The sky's the limit! CDL A Owner Operator Positions with great pay and home time for work/life balance....