Snowflake & Informatica Data Engineer

Stellar Professionals
Denver, CO, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

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

Tech stack

Query Performance Data Analysis Microsoft Azure Cloud Computing Code Review Continuous Integration Data Deduplication Data Governance Data Integrity Extract Transform Load (ETL) Data Profiling Data Systems
+12 more
DevOps Meta-Data Management Data Ingestion Delivery Pipeline Snowflake Informatica Cloud Infrastructure as Code (IaC) Git Git Flow Terraform Software Version Control Data Pipelines

Job description

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. < data-path-to-node=”14” dir=”ltr”>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.

Requirements

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

< data-path-to-node=”18” dir=”ltr”>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.

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…