Snowflake Data Engineer

Innosoul inc

1h ago • Remote

Senior

Remote

  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: Snowflake Data Engineer

  • Type/Duration: 6-month contract (possible extension)

  • Work arrangement: Remote/telecommuting; must reside in Colorado (strong preference for Denver Metro)

Description

The Data Engineer will implement and optimize Snowflake and Informatica data pipelines to support a statewide longitudinal data platform. The role includes transformations, data cleansing and quality management, and analytics-ready output, with a structured knowledge-transfer plan to progressively take over production operations and maintenance of the data foundation.

Responsibilities

  • Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake to ingest partner/state agency data into the common data model.

  • Implement transformation logic to harmonize raw feeds into linked longitudinal records and analytics-layer models.

  • Execute record linkage and identity matching to connect newly ingested records to master longitudinal student/workforce profiles; manage match exceptions and reconciliations.

  • Maintain production pipeline operations: monitor scheduled runs, resolve failures, reload late/corrected files, reconcile row counts, and rebuild downstream objects.

  • Implement data quality validation (L1 structural/format, L2 completeness/deduplication, L3 referential integrity/logic) and maintain audit trails.

  • Enforce privacy, suppression, and compliance rules (FERPA, COPPA, ADA, and applicable state statutes).

  • Optimize query execution and warehouse performance for cost and latency; tune heavily used models and performance hot spots.

  • Support QA and release promotion using Azure DevOps and Azure Test Plans: author/execute test cases, perform peer code reviews, and maintain release change logs.

Requirements

  • 5+ years building/orchestrating/optimizing ETL/ELT pipelines and transformations natively in Snowflake

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

  • 1+ year using Terraform for infrastructure provisioning/configuration

  • CI/CD implementation experience using Azure DevOps

  • Expert proficiency with Git and version control workflows

  • Must currently reside within Colorado for the duration of the engagement

Benefits

  • 6-month contract with potential extension based on project performance and state funding

See similar jobs

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

See more

Unlock Full Resume Report