Quick overview
Job description
Snowflake Data Engineer
The Snowflake Data Engineer will be responsible for implementing data pipelines using Snowflake and Informatica to support the Statewide Longitudinal Data System (SLDS / COdata). The role focuses on moving data from state agencies and third-party source systems into analytical data platforms, building transformations, managing data cleansing and quality, and preparing structured data for analysts and data scientists. The selected candidate will join the project team in January 2027 and work with a third-party implementation partner through a structured knowledge-transfer process, gradually assuming responsibility for production operations and maintenance of the SLDS data foundation and analytics layer.
Responsibilities
- Design, develop, test, and deploy automated ETL/data pipelines using Informatica and Snowflake.
- Build transformation logic to convert raw agency data into harmonized, linked longitudinal records and analytics models.
- Perform record linkage and identity matching to connect newly ingested records with existing student and workforce profiles.
- Monitor production pipelines, troubleshoot failed jobs, reload corrected files, and reconcile source data.
- Implement data quality checks covering structural validation, completeness, de-duplication, and referential integrity.
- Enforce data privacy, suppression rules, and compliance requirements, including FERPA, COPPA, ADA, and state statutes.
- Optimize Snowflake queries, warehouse compute, and pipeline performance.
- Support testing, code reviews, and release management across Development, Test, UAT, and Production environments using Azure DevOps and Azure Test Plans.
- Collaborate with the Data Architect, Data Scientist, Visualization Designer, and Operations Engineers.
Requirements
<>Required Skills- Snowflake ETL/ELT: Building, orchestrating, and optimizing complex ETL/ELT pipelines and transformation logic within Snowflake. 5 Years
- Informatica CDGC: Hands-on experience with Informatica Cloud Data Governance and Catalog for metadata management, data profiling, cataloging, and automated data quality validation. 1 Year
- Terraform / Infrastructure as Code (IaC): Provisioning, configuring, and maintaining cloud infrastructure and resources. 1 Year
- CI/CD & DevOps: Implementing automated build, test, and release deployment pipelines using Azure DevOps. Demonstrated Proficiency
- Git / Version Control: Branching strategies, pull requests, automated merge checks, and code reviews. Expert Proficiency
- Location Requirement: Must currently reside within the State of Colorado for the duration of the engagement. Mandatory
- Experience with public sector, longitudinal education, and workforce data systems, such as CDE, CDHE, CDLE, CDEC, and National Student Clearinghouse.
- Experience with record linkage, entity resolution, and deterministic/probabilistic identity matching across disparate public records.
- Familiarity with federal and state student/workforce privacy regulations, including FERPA, COPPA, and cell suppression standards.
- Experience authoring and executing structured test plans in Azure Test Plans.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- RI

MDM Data EngineerRecently posted
RightTalents · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
MySQLOracleSQL+16TechnologySalary not listed - AG

Data Migration ConsultantRecently posted
ASCII Group LLC · Houston, TX · On-site · Posted 19 Nov 2026 🇺🇸
MySQLSQLAWS+5$80/hr - AS
Data Integration EngineerRecently posted
Abacus Service Corporation · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
ETLTechnologySalary not listed - AT

Lead Data Engineer / ArchitectRecently posted
Aivanta Tech Inc · Cary, NC · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLScalaApache Spark+17TechnologySalary not listed - VC

Senior Kafka Engineer / AdministratorRecently posted
VAK Consulting LLC · Denver, CO · On-site · Posted 19 Nov 2026 🇺🇸
EngineeringSalary not listed - CO

Entry-Level Data EngineerRecently posted
Collabera LLC · Tampa, FL · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLPythonTechnology$22 - $24/hr - CC
Sr. Data Engineer - SDE 26-17080Recently posted
Compu-Vision Consulting, Inc. · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
MySQLOracleSQL+16TechnologySalary not listed - HU

Data EngineerRecently posted
HUMAC INC. · United States · On-site · Posted 19 Nov 2026 🇺🇸
GitETLSnowflake+4TechnologySalary not listed - CA

Senior Data Engineer - Databricks
Capgemini America, Inc. · NY · On-site · Posted 2 Nov 2026 🇺🇸
SQLGitApache Spark+11Technology$133k - $153k/yr - CG
Sr. Data Engineer with Security ClearanceRecently posted
Contact Government Services, LLC · Los Angeles, CA · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLShellGit+10Technology$144.8k - $209.1k/yr - CG
Senior Database Administrator with Security ClearanceRecently posted
Contact Government Services, LLC · Dallas, TX · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLAWSVMware+4Technology$89.3k - $121.2k/yr - CG
Senior Database Administrator with Security ClearanceRecently posted
Contact Government Services, LLC · New York, NY · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLAWSVMware+4Technology$89.3k - $121.2k/yr