Data Engineer

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

Data Engineer – Nakupuna Companies

Join to apply for the Data Engineer role at Nakupuna Companies.

Overview

Nakupuna Solutions is looking for a Data Engineer who designs, builds, and maintains data pipelines and data warehouse infrastructure to ensure reliable, scalable, and secure data integration that supports reporting and analytics. This is a mid-level role expected to execute data integration work independently and elevate complex issues to senior engineering as needed. This effort supports the Naval Supply Systems Command (NAVSUP).

Responsibilities

• Design, build, and maintain ETL/ELT pipelines using Python and SQL to ingest data from Salesforce Education Cloud, flat files, and API endpoints into the data warehouse.
• Implement robust error handling, logging, and automated monitoring to detect and track data quality issues.
• Define schemas and curate unified student datasets with targeted completeness and accuracy for downstream reporting and modeling.
• Optimize AWS Redshift and PostgreSQL performance through tuning, query optimization, and storage management.
• Serve as escalation point for complex data discrepancies and pipeline failures; provide root‑cause analysis and permanent fixes.
• Coordinate with analysts and BI developers to validate transformations and resolve mismatches.

Qualifications

• Hands‑on experience designing and maintaining ETL/ELT pipelines using Python and SQL.
• Working knowledge of data warehouse concepts, schema design, and performance optimization.
• Experience implementing data quality checks, logging, and monitoring to detect pipeline failures and data anomalies.
• Ability to troubleshoot and remediate data discrepancies and integration issues across multiple source systems.
• Experience collaborating with BI developers and analysts to validate transformations and definitions.

Education and Experience

This position requires a bachelor’s degree in Engineering, Computer Science, or equivalent.

• 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.

Clearance Requirements

Must be a U.S. Citizen. Must have an active Secret clearance.

Physical Requirements

• Ability to perform repetitive motions with the hands, wrists, and fingers.
• Ability to engage in and follow audible communications in emergency situations.
• Ability to sit for prolonged periods at a desk and work on a computer.

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Information Technology

Industries

Business Consulting and Services