Data Engineer (Req. ID 14172610)

ZealHire Inc.

Denver (CO)

Remote

USD 90,000 - 135,000

Full time

14 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

ZealHire Inc. is recruiting a Data Engineer for a state government client in Denver, Colorado. This is a 6-month remote assignment, but the candidate must reside in Colorado.

The start date is January 2027, and the role focuses on implementing data pipelines using Snowflake and Informatica to support the SLDS / COdata initiative. You will own ingestion, transformations, data quality, governance, and production operations, collaborating with a 3rd party implementor and government partners.

Job description

USC/GCNeed LinkedIn, VISA DLWe are recruiting for a Data Engineer for our state government client in Denver, CO. This is a 6-month remote assignment. However, the candidate must reside in the state of Colorado

The Data Engineer is responsible for realizing the vision of the Data Architect through the technical implementation of data pipelines using Snowflake and Informatica. Data Engineers are technical coding experts focused on moving data from line-of-business, transactional, or partner agency source systems into analytical data platforms, building transformations, managing data cleansing and quality, and presenting structured data for consumption by analysts and scientists.

In the context of the Statewide Longitudinal Data System (SLDS / COdata) an OIT Data Engineer is expected to join the project team in January 2027 under a shared delivery model with a 3rd party implementor. The OIT Data Engineer will participate in a structured knowledge-transfer progression (shadowing, co-running, and checking), leading specific new source ingestions, and progressively will take over production operations and upkeep of the SLDS data foundation and analytics layer.

1. Scope of Responsibilities
  • Data Ingestion & Pipeline Engineering: Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake to ingest data from partner state agencies and third parties into the SLDS common data model.
  • Transformation & Analytics Layer Support: Implement transformation logic to convert raw agency feeds into harmonized, linked longitudinal records and analytics layer data models, adhering to core naming and modeling standards established with the Data Architect.
  • Record Linkage & Identity Matching: Execute the SLDS internal matching logic to link newly ingested agency records to master longitudinal student and workforce profiles, handling match exceptions and cross-agency reconciliations.
  • Production Pipeline Operations & Incident Response: Maintain operational ownership of scheduled feed runs, monitoring job execution, resolving run failures, reloading late or corrected files, reconciling row counts, and rebuilding downstream objects.
  • Data Quality & Governance Compliance: Implement L1 (structural/format), L2 (completeness/de-duplication), and L3 (referential integrity/logic) validation checks, layout-change detection, and audit trails; enforce data privacy, suppression rules, and compliance standards (FERPA, COPPA, ADA, and state statutes).
  • Performance Optimization & Platform Stewardship: Optimize query execution, warehouse compute, and pipeline performance for cost and latency; identify and tune heavily used models and performance hot spots in Snowflake.
  • Quality Assurance, Code Review & Promotion: Adhere to the unified release process across Development, Test, UAT, and Production environments using Azure DevOps and Azure Test Plans; author and execute test cases, conduct peer code reviews, and maintain release change logs.
2. Activities Performed
A. Ingestion & Pipeline Development (OIT-Led Feeds)
  • CDHE Courses Data Ingestion:
    • Ingest and validate annual postsecondary course-level data files from CDHE per data sharing agreements.
    • Build ETL mapping processes from CDHE course files into the SLDS common data model based on design specifications provided by 3rd party implementation partner.
    • Pair with 3 party implementation team during ETL construction, validation, and promotion.
  • Postsecondary SES & Disability Data Ingestion (Conditional):
    • Ingest and validate demographic, Pell Grant eligibility, and disability classification codes from postsecondary sources.
    • Apply mandated privacy protections, cell suppression rules, and permissible-use governance requirements.
  • PSAT/SAT Assessment Data Ingestion (Conditional):
    • Ingest, validate, and map section/composite assessment scores and grade levels from the College Board or CDE.
    • Execute identity matching to connect assessment records to existing longitudinal student profiles.
B. Knowledge Transfer & Operational Transition (Jan-April 2027)
  • Shadowing & Co-running (Jan-Feb 2027):
    • Shadow 3rd party implementation partner engineers on day-to-day operations of existing data feeds (e.g., NSC, K-3, CDEC, and Phase 1 feeds).
    • Co-run live feed cycles, handle data loading, execute record matching, and troubleshoot exceptions alongside 3rd party implementation partner.
  • Readiness Gate Execution (Target: March 2027):
    • Run two consecutive feed cycles completely unaided to achieve formal operational hand-over sign-off.
  • Full Production Operations (March 2027 Onward):
    • Execute recurring feed schedules, rebuild downstream objects, reconcile row counts against source files, and triage failed jobs.
    • Address ad-hoc data inquiries and export requests from OIT leadership and partner agencies.
C. Data Stabilization & Analytics Layer Upkeep
  • Stabilization Backlog Support: Resolve identified data reliability defects, run variations, and de-duplication issues transitioned from the Phase 1 stabilization backlog.
  • Analytics Layer Hardening & Maintenance (April 2027 Onward):
    • Apply object modeling standards, naming conventions, and layout-change detection into the RAW layer.
    • Perform ongoing reconciliation of analytics layer outputs across non-production and production environments.
    • Implement metric and calculation enhancements prioritizing downstream use cases (program participation, completion, equitable access, and wage outcomes).
    • Conduct query profiling and performance tuning on dashboard back-end models.
D. Cross-Functional Collaboration & Testing
  • Testing & Release Management: Author manual and automated test cases in Azure Test Plans; record execution evidence and resolve defect bugs before promoting code.
  • Cross-Role Support:

$000,000 - $000,000 Salary range is not shown on the candidate portal

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Application Developer - SLDS Data Engineer
Application Developer - SLDS Data Engineer

Mavensoft Technologies, LLC. • Denver (CO)

On-site
USD 83,000 - 117,000
Sr. Data Engineer – Snowflake, ETL, ADO
Sr. Data Engineer – Snowflake, ETL, ADO

Mavensoft Technologies, LLC. • Denver (CO)

On-site
USD 120,000 - 150,000
Senior Data Engineer
Senior Data Engineer

CloudBigD • Boston (MA)

On-site
USD 96,000 - 124,000
Application Developer
Application Developer

Apollo Technology Solutions LLC • Denver (CO)

Remote
USD 83,000 - 165,000
Senior Data Engineer
Senior Data Engineer

Robotics Technologies LLC • Boston (MA)

On-site
USD 90,000 - 120,000
Senior Data Engineer
Senior Data Engineer

Quantum Technologies LLC • Boston (MA)

On-site
USD 86,000 - 123,000
Senior Data Engineer
Senior Data Engineer

Robotic Process Automation LLC • Boston (MA)

On-site
USD 96,000 - 124,000
Data Engineer
Data Engineer

VIVA • Denver (CO)

Remote
USD 120,000 - 160,000
Data Engineer
Data Engineer

Talent Groups • Colorado

Remote
USD 110,000 - 150,000
SLDS Data Engineer
SLDS Data Engineer

Ampcus Inc • Denver (CO)

On-site
USD 120,000 - 170,000
Health, dental, vision insurance
Group term life insurance
401(k) retirement savings plan