
Data Engineer
LanceSoft · Denver, CO · Remote
Strong hiring record · median 9 days open
- 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
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- Systems AdministratorLanceSoft · Charlestown, MAtoday
- IT - Full Stack Developer IV Full Stack Developer IVLanceSoft · Richfield, MN · USD 80–85/hrtoday
- 6M04I4 (6M4) - Product Security Engineering 4LanceSoft · Oklahoma City, OKtoday
- Senior Business Analyst/Data DeveloperLanceSoft · Quincy, MA · USD 55–65/hrtoday
- Applications Engineering - Contractor - L5LanceSoft · Melbourne, FLyesterday
Similar roles
- Senior Battery Data EngineerRedwood Materials · San Francisco, California, United Statestoday
- Manager, Data EngineeringBarkleyOKRP · Kansas City, MO, Denver, CO · Chicago, IL · New York, NY +1today
- SLDS Data EngineerCrescens · Denver, COtoday
- Data EngineerICONMA · Newark, NJtoday
- Senior Data Platform EngineerGtt · Atlanta, GAtoday
- BI Analyst - TableauAPN Consulting · Remote, NYtoday