NHO-owned family of companies delivering gov’t mission support through IT, infrastructure, logistics & environmental services.
Design, develop, and maintain ETL pipelines and data warehouse solutions for NAVSUP.
8 days ago ago
Intermediate (4-7 years)
Full Time
Mechanicsburg, PA
Office Full-Time
Company Size
900 Employees
Service Specialisms
Consulting
Project Management
Engineering
Design
Technical Services
Sector Specialisms
mission & business operations
IT
facilities & infrastructure
logistics
environmental services
Role
Description
schema design
data curation
performance tuning
error handling
etl pipelines
issue escalation
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
Implement robust error handling, logging, and automated monitoring to detect and track data quality issues
Coordinate with analysts and BI developers to validate transformations and resolve mismatches
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
Serve as escalation point for complex data discrepancies and pipeline failures; provide root-cause analysis and permanent fixes
Requirements
data warehouse
etl/elt
sql
python
postgresql
5+ years
Working knowledge of data warehouse concepts, schema design, and performance optimization.
Ability to troubleshoot and remediate data discrepancies and integration issues across multiple source systems.
Familiarity with Salesforce data models is preferred
5+ years of data engineering experience designing ETL/ELT pipelines and data warehouse architecture
Experience implementing data quality checks, logging, and monitoring to detect pipeline failures and data anomalies.
Experience implementing monitoring, logging, and data quality checks
Ability to perform repetitive motions with the hands, wrists, and fingers.
Experience collaborating with BI developers and analysts to validate transformations and definitions.
Advanced SQL skills (PostgreSQL, Redshift)
Ability to engage in and follow audible communications in emergency situations.
Hands-on experience designing and maintaining ETL/ELT pipelines using Python and SQL.
Experience with Python-based ETL development and automation
Ability to sit for prolonged periods at a desk and working on a computer.
Benefits
Information not given or found
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
2003
Year Founded
The company was established in the early 21st century, setting the foundation for its growth and expansion.
$370M
Government Contract Award
Secured a substantial federal contract for modernizing critical military personnel systems.
Top Workplace
Workplace Excellence
Recognized for fostering a positive and innovative work environment by regional authorities.
GovCon Finalist
Industry Recognition
Honored as a finalist in prestigious government contracting awards for its innovative approaches.
Blends national reach with small‑business agility.
Headquartered in Hawai‘i with expansion hubs in Arlington, Denver, Mechanicsburg, PA, Charleston, and Patuxent River.
Services include mission and business operations, custom software/IT, facilities & infrastructure, logistics, and environmental services.
Projects involve modernizing personnel systems and managing complex logistics and environmental programs for federal agencies.
Structured as a Native Hawaiian Organization‑owned group, uniting large and 8(a) small businesses under one agile umbrella.
Culture + Values
We believe in our people. Our employees are the most important part of our success, and we are dedicated to creating an environment where everyone feels empowered to thrive.
We value transparency and integrity. We operate with honesty, openness, and fairness in everything we do.
We are committed to excellence. We constantly strive for high standards, quality, and continuous improvement.
We work as one team. Collaboration and mutual respect are at the heart of how we achieve success.
We are proactive in problem-solving. We take initiative and respond swiftly to challenges, always focused on finding solutions.
Environment + Sustainability
2050 Target
Net-Zero Carbon Emissions
The company aims to achieve net-zero carbon emissions by the year 2050 through comprehensive sustainability efforts.
100% Renewable
Renewable Resources
The company is focused on transitioning to 100% renewable resources to reduce reliance on non-sustainable energy sources.
Significant Waste Reduction
Waste Management Goals
The company has established ambitious goals to significantly reduce waste generation across its operations.
Committed to sustainable business practices that reduce environmental impact.
Active engagement in resource conservation and responsible environmental stewardship throughout its operations.
Inclusion & Diversity
Fosters an inclusive workplace with diverse perspectives.
Supports gender equality and diversity through recruitment and training.
Provides equal opportunities for all employees, regardless of background or gender.