JobHabor
Menu

Data Engineer

LanceSoft · Denver, CO · Remote

Strong hiring record · median 9 days open

100100

Hiring signal

Actively hiring

Posted today · Never reposted · How we score

First seen
19 November 2026
Reposted
Not since September 2026
All reasons

In its favour

  • Posted yesterday
  • Still listed on the employer's own board

Did you apply?

Data Engineer at LanceSoft. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

Title

Data Engineer

Duration

01/04/2027 - 06/30/2027

Work Hours

Mon – Fri, 8:00AM – 5:00PM MST

Location

601 East 18th Avenue Suite 250 Denver, Colorado 80203

Position

Remote

Note

Candidate must be within 100 miles

  • Work Arrangement: Remote / Telecommuting (Candidate must reside within the State of Colorado; strong preference for local / Denver Metro candidates)

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

Skills

  • Informatica
  • Snowflake
  • Azure DevOps
  • Azure Test Plans
  • SQL
  • Data Modeling
  • ETL Development
  • Data Validation
  • Data Governance
  • Record Linkage
  • Identity Matching
  • Data Privacy

More jobs at LanceSoft

All 61

Similar roles