Snowflake ETL/ELT Data Engineer

Cleo Consulting 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 ETL/ELT Data Engineer
  • Engagement: 6-month contract (possible extension)
  • Work model: Remote/telecommuting; must reside in Colorado (strong preference for Denver Metro)
  • Hours: Monday–Friday, 8:00 AM–5:00 PM MST

Description

The Data Engineer implements the Data Architect’s vision by building Snowflake and Informatica pipelines that ingest, transform, cleanse, and validate data for analytical consumption. In the Statewide Longitudinal Data System (SLDS), you will join under a shared delivery model, lead new source ingestions, and progressively transition into full production operations and upkeep. Responsibilities include transformation and analytics-layer support, identity matching, incident response for scheduled feeds, and performance optimization and governance-compliant data quality validation.

Responsibilities

  • Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake
  • Implement transformation logic to produce harmonized longitudinal records and analytics-layer models
  • Execute SLDS internal matching logic to link ingested records to master longitudinal profiles
  • Operate production pipelines: monitor scheduled runs, resolve failures, reload late/corrected files, reconcile row counts, rebuild downstream objects
  • Implement data quality validations (L1 structure/format, L2 completeness/de-duplication, L3 referential integrity/logic), layout-change detection, and audit trails; enforce privacy, suppression rules, and compliance (FERPA, COPPA, ADA, state statutes)
  • Optimize query execution and warehouse/pipeline performance for cost and latency
  • Follow QA and release promotion practices across Development, Test, UAT, and Production using Azure DevOps and Azure Test Plans (test cases, peer code reviews, release change logs)

Benefits

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

Requirements

  • Minimum 5 years experience building, orchestrating, and optimizing complex ETL/ELT pipelines in Snowflake
  • Minimum 1 year hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC)
  • Minimum 1 year experience using Terraform for infrastructure as code
  • Demonstrated proficiency with CI/CD using Azure DevOps
  • Expert proficiency with Git version control workflows
  • Must 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