Mid-Level Data Engineer

Overview

Nakupuna Prime is looking for a Data Engineer to design, build, and maintain 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 escalate complex issues to senior engineering as needed. This effort supports the United States Naval Community College (USNCC).

Responsibilities

The following reflects management’s definition of essential functions for this job but does not restrict the tasks that may be assigned. Management may assign additional duties and responsibilities to this job at any time due to reasonable accommodation or other reasons.

• 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

Qualification/Skills:

• 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. The following are desirable levels of experience:

• 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
  
  

Military Installation Access and Security Clearance: This position requires access to military installations. Must be able to qualify for and obtain base access and pass a background check. Must be a U.S. citizen.

Location: This position is hybrid. Work will be done on site at least three (3) days a week in Arlington, VA. Remote candidates will be considered. Occasional travel may be required.

Physical Requirements: The ideal candidate must at a minimum be able to meet the following physical requirements of the job with or without a reasonable accommodation:

• 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.
• Ability to walk for extended periods throughout the work day including moving between buildings and covering long distances by foot.