Sign up to continueApply now
CENTSTONE SERVICES LLC· Spotted 59m ago

Data Engineer -Snowflake & Informatica - Local to CO

Location
Denver, CO, US
Work mode
Remote
Employment
Contract
Level
Senior
Experience
5+ years
Job function
Software/Internet/AI › Data & Analytics › Data Engineer

Posted Nov 19, 2026Last confirmed open Nov 20, 2026

About this role

Job Title: Data Engineer Snowflake & Informatica - Local to CO

Location: Remote Must Reside in Colorado, USA

Work Arrangement: 100% Remote

Position Type: Contract

Job OverviewWe are seeking an experienced Data Engineer with strong expertise in Snowflake, Informatica Cloud Data Governance and Catalog (CDGC), Terraform, and Azure DevOps to support a Statewide Longitudinal Data System (SLDS) initiative.

The selected candidate will be responsible for developing and maintaining ETL/ELT data pipelines, integrating data from multiple state agencies, implementing data transformations, maintaining data quality, and supporting production data operations.

The role involves collaborating with data architects, data scientists, and implementation partners while gradually transitioning into independent ownership of data pipelines and analytics infrastructure.

Important

Candidates must currently reside in the State of Colorado and remain Colorado residents throughout the engagement. Denver Metro candidates are strongly preferred.

Key Responsibilities

  • Design, develop, test, and deploy ETL/ELT pipelines using Snowflake and Informatica.
  • Integrate data from multiple state agencies and third-party source systems into a common data model.
  • Develop Snowflake SQL transformations, data cleansing routines, and data quality validation processes.
  • Implement Informatica workflows for data ingestion, transformation, and governance.
  • Perform record linkage, identity matching, and reconciliation across multiple data sources.
  • Monitor production pipelines, troubleshoot failures, reload corrected files, and maintain scheduled data feeds.
  • Implement data quality checks covering completeness, duplicate detection, structural validation, and referential integrity.
  • Optimize Snowflake queries, warehouse utilization, and pipeline performance.
  • Develop and maintain automated CI/CD pipelines using Azure DevOps.
  • Use Git for version control, branching, pull requests, and code reviews.
  • Utilize Terraform for infrastructure provisioning and configuration.
  • Develop and execute test cases using Azure Test Plans.
  • Maintain technical documentation, data lineage, operational runbooks, and release records.
  • Collaborate with Data Architects, Data Scientists, and Operations Engineers to support analytics and reporting requirements.
  • Ensure compliance with data privacy and governance requirements, including FERPA and COPPA.

Required Technical Skills

  • Minimum 5 years of experience developing and optimizing ETL/ELT pipelines using Snowflake.
  • Minimum 1 year of hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC).
  • Minimum 1 year of experience with Terraform and Infrastructure as Code (IaC).
  • Strong experience with Azure DevOps and CI/CD pipeline implementation.
  • Expert knowledge of Git, branching strategies, pull requests, and code review processes.
  • Strong SQL, data transformation, data integration, and data quality skills.
  • Experience with production pipeline monitoring, troubleshooting, and performance optimization.

Preferred Qualifications

  • Experience working with public-sector or government data systems.
  • Experience with education, student, and workforce datasets.
  • Familiarity with longitudinal data systems and student/workforce record linkage.
  • Experience with entity resolution and deterministic/probabilistic identity matching.
  • Knowledge of FERPA, COPPA, and data suppression requirements.
  • Experience with Azure Test Plans and structured testing processes.
  • Familiarity with Tableau reporting and analytics data models.

Prefer to apply directly?

Apply on CENTSTONE SERVICES LLC

Company

Back to jobs