Back to Jobs
Recently postedTechnology

Snowflake Data Engineer

Excelraise LLCUnited States🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationUnited States
GitETLSnowflakeTerraformAzureCI/CDAzure DevOps

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
<>Preferred Skills
  • 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