Quick overview
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 SummarySeeking 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.
-
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).
-
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
- II

Senior Data Engineer / Software Engineer (SQL, Databricks, Java, Spark)Recently posted
Intuitive Insights LLC · Houston, TX · On-site · Posted 19 Nov 2026 🇺🇸
DockerOraclePL/SQL+18TechnologySalary not listed - GT
Senior Data Engineer with AIRecently posted
Goldenpick Technologies LLC · Dallas, TX · Hybrid · Posted 19 Nov 2026 🇺🇸
DockerNeo4jSQL+23TechnologySalary not listed - SS

Data Engineer with Autosys & StonebranchRecently posted
Softcom Systems · Weehawken Township, NJ · Hybrid · Posted 19 Nov 2026 🇺🇸
ShellETLNumPy+5TechnologySalary not listed - LO
Data Engineer – Cloud Security (AWS)Recently posted
Logicplanet, Inc. · Milpitas, CA · On-site · Posted 19 Nov 2026 🇺🇸
AWSEncryptionCDK+4TechnologySalary not listed - AM

Data Engineer Lead - W2Recently posted
Ampcus Inc · Columbus, OH · Hybrid · Posted 19 Nov 2026 🇺🇸
Apache SparkETLSnowflake+9TechnologySalary not listed - RD

Data Engineer (EDA)Recently posted
Randstad Digital · Irving, TX · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLETLSnowflake+1Technology$69 - $70/hr - FL
Senior PostgreSQL DBARecently posted
Flexton Inc · Los Angeles, CA · Remote · Posted 19 Nov 2026 🇺🇸
MySQLOracleSQL+25TechnologySalary not listed - PS

Senior Snowflake Data Engineer (Informatica) Remote (Local)Recently posted
Paramount Software Solutions, Inc · Denver, CO · Remote · Posted 19 Nov 2026 🇺🇸
SQLGitETL+6TechnologySalary not listed - GA

Staff Data EngineerRecently posted Auto Apply
Gamechanger · GameChanger Remote - US · Remote · Posted 18 Nov 2026 🇺🇸
SQLAWSMLOps+8Technology$170k - $185k/yr - TH

Data EngineerRecently posted
The Hollister Group · Pittsburgh, PA · On-site · Posted 19 Nov 2026 🇺🇸
SQLAWSETL+7Technology$75k - $85k/yr - VN

Data EngineerRecently posted
Virtual Networx · Boston, MA · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLETLDatabricks+4TechnologySalary not listed - EG

Data EngineerRecently posted
Eliassen Group · Pittsburgh, PA · On-site · Posted 19 Nov 2026 🇺🇸
JavaTechnologySalary not listed
