Back to Jobs
Recently postedTechnology

Snowflake & Informatica Data Engineer

Stellar Professionals LLCUnited States🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationUnited States
SQLGitETLSnowflakeTerraformAzureCI/CDAzure DevOps

Job description

Position Title: Senior Snowflake & Informatica Data Engineer

Location: Denver, CO (Must currently reside within the State of Colorado—within 100 miles / Denver Metro strongly preferred—for the duration of the engagement)

Work Arrangement: Remote

Interview Process: Either Webcam or In-Person Interview

Role Summary

Seeking a Senior Data Engineer to design, build, and maintain automated ETL/ELT data pipelines using Snowflake and Informatica for a Statewide Longitudinal Data System (SLDS). Joining under a shared delivery model, this role executes structured knowledge transfer from an implementation partner, leads new agency data ingestions, enforces multi-tier data quality and privacy rules, and transitions into full production ownership of the analytics data foundation.

Key Responsibilities
  • Data Ingestion & ETL/ELT Pipelines: Design, build, test, and deploy automated Informatica workflows and Snowflake SQL transformation pipelines to ingest and harmonize partner agency feeds into a common longitudinal data model.

  • Record Linkage & Analytics Layer: Execute internal identity-matching logic to link student and workforce records across agencies, maintain analytics-layer tables/views, and optimize Snowflake compute and query performance.

  • Data Quality & Privacy Governance: Implement L1 (structural), L2 (completeness/deduplication), and L3 (referential integrity) validation rules, layout-change detection, and cell-suppression standards compliant with FERPA, COPPA, and state statutes.

  • Production Operations & DevOps: Transition from shadowing/co-running to full operational ownership of scheduled feed runs, while managing code reviews, Azure Test Plans, and CI/CD releases in Azure DevOps.

Required Skills & Qualifications
  • Snowflake ETL/ELT: Minimum 5 years of demonstrated experience building, orchestrating, and optimizing complex ETL/ELT pipelines and transformation logic natively within Snowflake.

  • Informatica CDGC: Minimum 1 year of hands-on experience using Informatica Cloud Data Governance and Catalog (CDGC) for metadata management, data profiling, cataloging, and automated quality validation.

  • Infrastructure as Code (IaC): Minimum 1 year of experience utilizing Terraform to provision, configure, and maintain cloud infrastructure.

  • DevOps & Version Control: Demonstrated proficiency implementing automated build, test, and release pipelines in Azure DevOps, paired with expert Git version control skills (branching strategies, PRs, code reviews).

Preferred Qualifications
  • Prior experience working with public-sector, longitudinal education, or workforce data systems.

  • Experience with deterministic/probabilistic record linkage and entity resolution across disparate public datasets.

  • Familiarity with federal/state privacy regulations (FERPA, COPPA, cell suppression) and authoring structured test cases in Azure Test Plans.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs