Nakupuna Companies ยท 1 day ago
Data Engineer
Mechanicsburg, Pennsylvania
Full-time
Onsite
Senior Level
5+ years expNakupuna Solutions is looking for a Data Engineer who designs, builds, and maintains data pipelines and data warehouse infrastructure. This role involves executing data integration work independently and supporting the Naval Supply Systems Command (NAVSUP) by ensuring reliable and scalable data integration for reporting and analytics.
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
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
Must be a U.S. Citizen
Must have an active Secret clearance
Preferred
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