Senior Data Engineer (Snowflake & Informatica)

Info Origin Inc.

Denver, CO • 1h ago • On-site

Senior

On-site

  1. Select offer
  2. Add resume
  3. Analyze
  4. Improve
  5. Apply
  6. Auto-send · soon

Match your resume with similar open roles

Upload your resume to automatically match with active openings similar to this role.

PDF up to 10 MB

Your resume is private & secure

Quick Facts

  • Role: Data Engineer focused on Snowflake and Informatica pipeline implementation

  • Emphasis: Automated ETL/data pipelines, transformations, data quality, identity matching, and production operations

Description

You will realize the Data Architect’s vision by implementing data pipelines in Snowflake and Informatica. The role ingests partner/agency data into a shared longitudinal common data model, builds transformation logic, performs record linkage/identity matching, and maintains production reliability through monitoring, incident response, and data validation. A structured knowledge-transfer phase (Jan–Apr 2027) precedes progressive ownership of production operations and ongoing upkeep of the SLDS data foundation and analytics layer.

Responsibilities

  • Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake

  • Implement transformations to harmonize and link longitudinal records into analytics-layer data models

  • Execute internal matching logic to link newly ingested records to master longitudinal student/workforce profiles; manage match exceptions and reconciliations

  • Operate scheduled feed runs: monitor execution, resolve failures, reload late/corrected files, reconcile row counts, and rebuild downstream objects

  • Implement data validation at multiple levels (structural/format, completeness/de-duplication, referential integrity/logic) and enforce privacy/suppression and compliance requirements (FERPA, COPPA, ADA)

  • Optimize Snowflake compute and pipeline/query performance for cost and latency

  • Use Azure DevOps release processes across Development/Test/UAT/Production; author/execute tests and conduct peer code reviews

Benefits

  • Structured knowledge-transfer and operational handover (shadowing/co-running through formal sign-off)

  • Opportunity to harden and maintain the analytics layer and improve metrics for downstream use cases (participation, completion, equitable access, wage outcomes)

Requirements

  • Minimum 5 years building and optimizing ETL/ELT pipelines and transformation logic in Snowflake

  • Minimum 1 year hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC)

  • Minimum 1 year experience with Terraform for infrastructure as code

  • Proficiency implementing CI/CD build/test/release pipelines using Azure DevOps

  • Expert proficiency with Git version control workflows (branching, PRs, code reviews, merge checks)

  • Currently reside in the State of Colorado for the duration of the engagement

See similar jobs

Explore similar jobs and use your resume score to choose where to apply next

See more

Unlock Full Resume Report