Skip to main content
Loading
loadingbar
Loading, Please wait..!!

W2 Role :: Snowflake Data Engineer :: Remote within Colorado

  • W2 Role :: Snowflake Data Engineer :: Remote within Colorado job type Posted on: Nov 19, 2026
  • W2 Role :: Snowflake Data Engineer :: Remote within Colorado experience level Stellent IT LLC
  • W2 Role :: Snowflake Data Engineer :: Remote within Colorado employment type Remote, Remote
  • W2 Role :: Snowflake Data Engineer :: Remote within Colorado employment type Remote
  • W2 Role :: Snowflake Data Engineer :: Remote within Colorado salary Full-time

Point Apply Here APPLY LATER

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 →

Job Title :

W2 Role :: Snowflake Data Engineer :: Remote within Colorado

Job Type :

Full-Time

Job Location :

Remote Remote United States

Remote :

Yes

Jobcon Logo 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

Jobcon Logo Position Details

Posted:

Nov 19, 2026

Reference Number:

52880-6911

Employment:

Full-time

City:

Remote

Job Origin:

CIEPAL_ORGANIC_FEED

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

W2 Role :: Snowflake Data Engineer :: Remote within Colorado    Apply

Click on the below icons to share this job to Linkedin, Twitter!

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

Loading
Please wait..!!