Data Engineer – ETL, Data Warehouse & AWS

Nakupuna Companies; Mechanicsburg (Cumberland County); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading technology firm is seeking a Data Engineer in Mechanicsburg, PA to design, build, and maintain ETL/ELT pipelines using Python and SQL. The ideal candidate will have 5+ years of experience in data engineering and will be responsible for optimizing data warehouse performance and ensuring data quality. This mid-senior level position is full-time and requires strong collaboration skills with business intelligence developers and analysts. Must be a U.S. Citizen and hold a Secret clearance.

Qualifications

• 5+ years of data engineering experience designing ETL/ELT pipelines and data warehouse architecture.
• Advanced SQL skills (PostgreSQL, Redshift).
• Experience with Python-based ETL development and automation.
• Familiarity with Salesforce data models is preferred.
• Experience implementing monitoring, logging, and data quality checks.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines using Python and SQL.
• Implement robust error handling and automated monitoring.
• Define schemas and curate unified student datasets.
• Optimize AWS Redshift and PostgreSQL performance.
• Serve as escalation point for data discrepancies and pipeline failures.

Skills

ETL/ELT pipelines using Python

SQL and data warehouse concepts

Data quality checks and monitoring

Troubleshooting data discrepancies

Collaboration with BI developers and analysts

Education

Bachelor's degree in Engineering or Computer Science

Tools

PostgreSQL

AWS Redshift

Salesforce

Python

Job description

A leading technology firm is seeking a Data Engineer in Mechanicsburg, PA to design, build, and maintain ETL/ELT pipelines using Python and SQL. The ideal candidate will have 5+ years of experience in data engineering and will be responsible for optimizing data warehouse performance and ensuring data quality. This mid-senior level position is full-time and requires strong collaboration skills with business intelligence developers and analysts. Must be a U.S. Citizen and hold a Secret clearance.