Data Engineer: Snowflake Payments, SQL & Python

Shift4; Center Valley (Lehigh County); On-site; USD 90,000 - 120,000; Full time

Job summary

Shift4 is seeking a hands-on Data Engineer to build reliable SQL and Python workloads in Snowflake for payments datasets and reporting.

The role focuses on designing Python jobs, writing performant SQL, and packaging workloads in Docker for scheduled execution. Collaboration with finance and product teams is essential to translate questions into correct queries, with strong emphasis on data quality and security controls.

Qualifications

• 1+ years of data engineering/analytics engineering or backend roles building SQL-heavy data workloads in production.
• Strong SQL skills with window functions, CTEs, joins, and query tuning.

Responsibilities

• Design, write, and maintain Python jobs that execute SQL over Snowflake to produce transaction, settlement, fee, and reconciliation datasets.
• Develop performant, readable SQL using window functions, CTEs, and semi-structured data handling on large tables.
• Package workloads as Docker containers and run them on the existing scheduler.
• Ensure jobs are idempotent, runnable multiple times, parameterized, and observable with logging and alerting.

Skills

SQL

Python

Snowflake

Docker

Git

CI/CD

Unit tests

Data quality

Education

B.S. in CS/Engineering

Tools

Snowpark

Snowflake Python connector

pandas

Polars

dbt

Airflow

S3

Job description

Shift4 is seeking a hands-on Data Engineer to build reliable SQL and Python workloads in Snowflake for payments datasets and reporting.

The role focuses on designing Python jobs, writing performant SQL, and packaging workloads in Docker for scheduled execution. Collaboration with finance and product teams is essential to translate questions into correct queries, with strong emphasis on data quality and security controls.