Loading, Please wait..!!
W2 Role :: Snowflake Data Engineer :: Remote within Colorado
-
Posted on: Nov 19, 2026
-
Remote, Remote
-
Remote
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for W2 Role :: Snowflake Data Engineer :: Remote within Colorado roles in Remote.
View Salary Guide →Find your match !
Job Title :
W2 Role :: Snowflake Data Engineer :: Remote within Colorado
Job Type :
Full-Time
Job Location :
Remote Remote United States
Remote :
Yes
Job Description :
Role: Snowflake Data Engineer Statewide Longitudinal Data System
Location: Remote within Colorado . Candidates must currently reside in Colorado and remain in the state throughout the engagement. Denver metro candidates are strongly preferred
Type: January 4 June 30, 2027, with possible extension based on project performance and state funding
W2 Role
Role overview
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.
Ankita Singh -Recruitment Manager
Email- | Ext: 138 Contact No : 201-581-4822
STELLENT IT A Nationally Recognized Minority Certified Enterprise
"Happiness can be found, even in the darkest of times, if one only remembers to turn on the light."
- JK Rowling
Position Details
Posted:
Nov 19, 2026
Reference Number:
52880-6911
Employment:
Full-time
City:
Remote
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

