Snowflake Data Engineer

Excelraise, LLC
United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience required
1 year minimum
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Microsoft Azure Cloud Computing Code Review Continuous Integration Data Architecture Data Cleansing Data Governance Data Integrity Extract Transform Load (ETL) Data Migration Data Profiling
+12 more
Data Systems DevOps Meta-Data Management Release Management Delivery Pipeline Snowflake Informatica Cloud Git Git Flow Terraform Software Version Control Data Pipelines

Job description

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., * 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

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…