Nakupuna Companies ยท 15 hours ago
Data Engineer
Mechanicsburg, PA
Full-time
Onsite
Mid, Senior Level
$125K/yr - $140K/yr
5+ years expNakupuna Solutions is seeking a Data Engineer to design, build, and maintain data pipelines and data warehouse infrastructure. This role involves executing data integration work independently and supporting the Naval Supply Systems Command (NAVSUP).
Environmental ConsultingInformation TechnologyManagement Consulting
No H1B
Security Clearance RequiredU.S. Citizen Only
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
Qualification
Required
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
This position requires a bachelor's degree in Engineering, Computer Science, or equivalent
Must be a U.S. Citizen
Must have an active Secret clearance
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 working on a computer
Preferred
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
Company
Nakupuna Companies
Nakupuna Companies provides management consulting services specializing in IT, facilities support, and environmental services.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Jason Greenawalt
Chief Executive Officer
Steven Wright
Chief Financial Officer
Recent News
2025-08-13
2025-06-25
Company data provided by crunchbase