Loading, Please wait..!!
Snowflake Data Engineer
-
Posted on: Nov 19, 2026
-
, Colorado
-
Onsite
-
CTC
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Snowflake Data Engineer roles in Colorado.
View Salary Guide →Job Title :
Snowflake Data Engineer
Job Type :
Contract
Job Location :
Colorado United States
Remote :
No
Job Description :
Position : Snowflake Data Engineer
Location : Remote Candidate must live in Colorado
Duration : Long term contract
Role overview
The Client is seeking a Data Engineer to build and operate Snowflake and Informatica data pipelines for its Statewide Longitudinal Data System (SLDS), also known as COdata. The system links education and workforce records from multiple agencies to support reporting on program participation, completion, equitable access, and wage outcomes.
You'll work with the Data Architect and a third-party implementation partner to onboard new data sources, improve data quality, and take ownership of production pipeline operations. The transition starts with shadowing and jointly running feeds in January and February. The March target is to run two consecutive feed cycles independently and receive formal handover approval.
Key responsibilities
- Build and maintain data pipelines. Design, test, and deploy automated Informatica workflows and Snowflake SQL transformations that map partner agency data to the SLDS common data model.
- Onboard agency data. Lead ingestion of annual postsecondary course data from the Colorado Department of Higher Education. Additional feeds may include postsecondary demographic, Pell Grant eligibility, and disability data, as well as PSAT/SAT assessment results.
- Link and reconcile records. Apply identity-matching rules to connect incoming records to existing student and workforce profiles. Investigate match exceptions and resolve cross-agency discrepancies.
- Own production feed operations. Monitor scheduled jobs, troubleshoot failures, reload late or corrected files, reconcile row counts, and rebuild downstream tables and views.
- Automate data quality and privacy controls. Validate file structure, completeness, duplicates, referential integrity, and business rules. Detect layout changes, maintain audit trails, and apply de-identification and cell suppression rules where required.
- Maintain the analytics layer. Build and tune Snowflake tables, views, and metrics. Support Tableau dashboard refreshes and prepare de-identified outcome files for participating higher education institutions.
- Test, release, and document changes. Use Azure DevOps and Azure Test Plans to manage releases across development, test, UAT, and production. Maintain source-to-target mappings, data lineage, runbooks, test evidence, and release logs.
Required qualifications
| Skill | Minimum requirement |
| Snowflake ETL/ELT | 5+ years building, orchestrating, and optimizing complex data pipelines and transformations directly in Snowflake |
| Informatica CDGC | 1+ year of hands-on experience with Informatica Cloud Data Governance and Catalog for metadata management, data profiling, cataloging, and automated data quality validation |
| Terraform | 1+ year provisioning, configuring, and maintaining cloud resources using infrastructure as code |
| Azure DevOps | Demonstrated experience building automated CI/CD pipelines for builds, tests, and deployments |
| Git | Expert proficiency with branching, pull requests, automated merge checks, and code reviews |
Preferred qualifications
- Experience with public-sector education or workforce data, especially statewide longitudinal data systems.
- Experience with record linkage, entity resolution, and deterministic or probabilistic identity matching across data sources.
- Familiarity with FERPA, COPPA, state student and workforce data privacy requirements, and cell suppression standards.
- Experience writing and executing structured test cases in Azure Test Plans.
Position Details
Posted:
Nov 19, 2026
Reference Number:
1805-46931
Employment:
CTC
City:
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

