Data Engineer

Talent Groups

Colorado

Remote

USD 110,000 - 150,000

Full time

19 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Talent Groups seeks an experienced Data Engineer for a State of Colorado (OIT) project. This 6-month contract role is remote for Colorado residents, with preference for Denver area proximity.

You will design and manage Snowflake-based ETL pipelines, govern metadata, and implement CI/CD for cloud deployments, collaborating with architects and scientists. The ideal candidate has strong Snowflake SQL, data modeling, and data quality skills, plus experience with Informatica CDGC and Terraform IaC.

Qualifications

  • 5+ years hands-on experience with Snowflake ETL/ELT pipelines.
  • Expertise in Snowflake SQL, data transformations, ingestion and optimization.
  • Experience with Informatica CDGC and data governance practices.
  • Knowledge of metadata management, data cataloging and automated quality checks.
  • Experience with Terraform IaC in cloud environments.
  • Familiar with CI/CD workflows using Azure DevOps and Git.

Responsibilities

  • Design, develop, test, and maintain automated ETL/ELT data pipelines using Snowflake and Informatica.
  • Ingest data from multiple state agencies and third-party sources into a centralized data platform.
  • Develop data transformation logic to produce structured, analytics-ready datasets.
  • Implement data cleansing, validation, reconciliation, and data quality checks.
  • Perform record linkage and identity matching across datasets.
  • Monitor production data pipelines, troubleshoot failures, and manage scheduled loads.
  • Optimize Snowflake queries and data processing costs.
  • Collaborate with Data Architects, Data Scientists and other teams.
  • Maintain technical documentation, testing records and deployment procedures.

Skills

Snowflake ETL/ELT
Snowflake SQL
Data transformations
Data ingestion
Performance optimization
Informatica CDGC
Metadata management
Data profiling
Data cataloging
Data quality validation
Data governance
Terraform / IaC
Infrastructure automation
CI/CD Azure DevOps
Git / version control

Tools

Azure DevOps
Git
Terraform

Job description

We are currently hiring for an experienced Data Engineer for a State of Colorado (OIT) project. This is a remote opportunity; however, candidates must currently reside in Colorado, with a strong preference for candidates within 100 miles of the Denver Metro area.

  • Job Title: Data Engineer
  • Client: State of Colorado – Office of Information Technology (OIT)
  • Location: Remote – Colorado residents only
  • Work Arrangement: 100% Remote
  • Engagement: - 6 Month Contract (with possibility of extension based on project performance and state funding)

Required Technical Skills:

  • Snowflake ETL/ELT – 5+ Years
  • Strong hands-on experience developing and managing complex ETL/ELT pipelines using Snowflake.
  • Expertise in Snowflake SQL, data transformations, data ingestion, and performance optimization.
  • Experience building analytical data models and optimizing warehouse performance.
  • Hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC).
  • Knowledge of metadata management, data profiling, data cataloging, and automated data quality validation.
  • Ability to implement data governance and quality standards.
  • Terraform / Infrastructure as Code – 1+ Year
  • Experience using Terraform to provision, configure, and maintain cloud infrastructure and resources.
  • Understanding of infrastructure automation and configuration management.
  • Experience implementing CI/CD pipelines for automated builds, testing, and deployments using Azure DevOps.
  • Strong knowledge of Git, branching strategies, pull requests, code reviews, and version control workflows.

Key Responsibilities:

  • Design, develop, test, and maintain automated ETL/ELT data pipelines using Snowflake and Informatica.
  • Ingest data from multiple state agencies and third-party source systems into a centralized data platform.
  • Develop data transformation logic to convert raw data into structured, standardized, and analytics-ready datasets.
  • Implement data cleansing, validation, reconciliation, and data quality checks.
  • Perform record linkage and identity matching across student and workforce datasets.
  • Monitor production data pipelines, troubleshoot failures, and manage scheduled data loads.
  • Optimize Snowflake queries, warehouse performance, and data processing costs.
  • Collaborate with Data Architects, Data Scientists, and other engineering teams.
  • Maintain technical documentation, testing records, and deployment procedures.

Preferred Qualifications:

  • Experience working on government or public-sector data projects.
  • Background in education, student, or workforce data systems.
  • Experience with entity resolution, record linkage, and identity matching.
  • Knowledge of FERPA, COPPA, and data privacy regulations.
  • Experience with Azure Test Plans and structured software testing.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Data Engineer (Snowflake ETL) – Colorado Gov
Remote Data Engineer (Snowflake ETL) – Colorado Gov

Talent Groups • Colorado

Remote
USD 110,000 - 150,000
Senior Data Engineer
Senior Data Engineer

CloudBigD • Boston (MA)

On-site
USD 96,000 - 124,000
Senior Data Engineer
Senior Data Engineer

Robotic Process Automation LLC • Boston (MA)

On-site
USD 96,000 - 124,000
Senior Data Engineer
Senior Data Engineer

Robotics Technologies LLC • Boston (MA)

On-site
USD 90,000 - 120,000
Senior Data Engineer
Senior Data Engineer

Quantum Technologies LLC • Boston (MA)

On-site
USD 86,000 - 123,000
Sr. Data Engineer – Snowflake, ETL, ADO
Sr. Data Engineer – Snowflake, ETL, ADO

Mavensoft Technologies, LLC. • Denver (CO)

On-site
USD 120,000 - 150,000
Application Developer - SLDS Data Engineer
Application Developer - SLDS Data Engineer

Mavensoft Technologies, LLC. • Denver (CO)

On-site
USD 83,000 - 117,000
Application Developer
Application Developer

Apollo Technology Solutions LLC • Denver (CO)

Remote
USD 83,000 - 165,000
Data Engineer (Req. ID 14172610)
Data Engineer (Req. ID 14172610)

ZealHire Inc. • Denver (CO)

Remote
USD 90,000 - 135,000
Data Engineer
Data Engineer

VIVA • Denver (CO)

Remote
USD 120,000 - 160,000