Na Ali'i Consulting & Sales, LLC.-posted about 11 hours ago
Full-time • Mid Level
Hybrid • Arlington, VA
501-1,000 employees

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).

  • 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.
  • 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 able to qualify for and obtain base access and pass a background check.
  • Must be a U.S. citizen.
  • Familiarity with Salesforce data models is preferred
  • Experience implementing monitoring, logging, and data quality checks
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service