Application Developer - SLDS Data Engineer

Mavensoft Technologies.•Denver, CO
•Remote

About The Position

The Data Engineer will realize the Data Architect’s vision by technically implementing data pipelines using Snowflake and Informatica. The role focuses on moving data from line-of-business, transactional, and partner-agency source systems into analytical data platforms; building transformations; managing data cleansing and quality; and preparing structured data for analysts and scientists. For the Statewide Longitudinal Data System (SLDS / COdata), the OIT Data Engineer will join the project team in January 2027 under a shared delivery model with a third-party implementor. The position includes a structured knowledge-transfer progression of shadowing, co-running, and checking; leading selected new source ingestions; and progressively assuming production operations and maintenance of the SLDS data foundation and analytics layer. The engagement is a six-month contract, remote in Denver, Colorado, with a requirement that the worker reside in Colorado for the duration. Work includes implementing and operating data ingestion and transformation pipelines, identity matching, data-quality and governance controls, Snowflake performance tuning, testing and release management, operational transition, and collaboration with the Data Architect, Data Scientist / Visualization Designer, Operations Engineers, implementation partner, and agency partners.

Requirements

  • At least 5 years of demonstrated experience building, orchestrating, and optimizing complex ETL/ELT pipelines and transformation logic natively within Snowflake.
  • At least 1 year of hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC) for metadata management, data profiling, cataloging, and automated data-quality validation.
  • At least 1 year of experience using Terraform to provision, configure, and maintain cloud infrastructure and resources.
  • Demonstrated proficiency implementing automated build, test, and release-deployment pipelines using Azure DevOps.
  • Expert proficiency with Git and version-control workflows, including branching strategies, pull requests, automated merge checks, and code reviews.
  • Must currently reside within the State of Colorado for the duration of the engagement.

Nice To Haves

  • Prior experience with public-sector, longitudinal education, and workforce data systems, such as CDE, CDHE, CDLE, CDEC, or the National Student Clearinghouse.
  • Experience with record linkage, entity resolution, and deterministic or probabilistic identity matching across disparate public records.
  • Familiarity with federal and state student/workforce privacy regulations, including FERPA, COPPA, and cell-suppression standards.
  • Experience authoring and executing structured test plans in Azure Test Plans.

Responsibilities

  • Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake to ingest partner-agency and third-party data into the SLDS common data model.
  • Implement transformation logic to convert raw agency feeds into harmonized, linked longitudinal records and analytics-layer models, following naming and modeling standards established with the Data Architect.
  • Execute SLDS identity-matching logic to link newly ingested agency records to longitudinal student and workforce profiles, and handle match exceptions and cross-agency reconciliations.
  • Operate scheduled production feeds, monitor jobs, resolve failures, reload late or corrected files, reconcile row counts, rebuild downstream objects, and respond to data inquiries and export requests.
  • Implement L1 structural and format checks, L2 completeness and de-duplication checks, and L3 referential-integrity and logic checks, as well as layout-change detection and audit trails.
  • Apply data privacy, suppression rules, and compliance standards, including FERPA, COPPA, ADA, and state statutes.
  • Optimize query execution, warehouse compute, and pipeline performance for cost and latency; tune frequently used Snowflake models and performance hot spots.
  • Follow the release process across Development, Test, UAT, and Production using Azure DevOps and Azure Test Plans; author and execute tests, conduct peer code reviews, and maintain release change logs.
  • Ingest and validate annual CDHE postsecondary course-level data and build ETL mappings into the SLDS common data model in coordination with the third-party implementation team.
  • Conditionally ingest and validate postsecondary demographic, Pell Grant eligibility, and disability-classification data, applying privacy protections, cell suppression, and permissible-use requirements.
  • Conditionally ingest, validate, and map PSAT/SAT scores and grade levels, and match assessment records to existing longitudinal student profiles.
  • Shadow and co-run existing feed operations during the January–February 2027 knowledge-transfer period, including data loading, record matching, and troubleshooting.
  • Complete two consecutive feed cycles unaided for the targeted March 2027 operational hand-over sign-off.
  • Support stabilization work by resolving data reliability defects, run variations, and de-duplication issues from the Phase 1 backlog.
  • Maintain and harden the analytics layer from April 2027 onward, including modeling standards, naming conventions, RAW-layer layout-change detection, environment reconciliation, metric enhancements, query profiling, and dashboard back-end performance tuning.
  • Author manual and automated test cases in Azure Test Plans, record execution evidence, and resolve defects before code promotion.
  • Partner with the Data Architect on physical and logical data models and pipeline designs; support Tableau data refreshes and de-identified IHE outcome files; and coordinate with Operations Engineers on Snowflake compute, warehouse auto-shutdown, permissions, and CI/CD promotion pipelines.
  • Create and maintain production pipelines, validation modules, identity-matching routines, analytics transformations, de-identified extraction scripts, design and mapping documents, lineage records, runbooks, test records, release logs, and feed-operation summaries.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service