Data Engineer at Nakupuna Companies in Mechanicsburg, PA | Kablio

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.

Articles

Careers

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.

Articles

Careers