Snowflake Data Engineer

Apex Systems

Denver, CO • 1h ago • On-site

Mid

On-site

55 - 60 USD/yr

  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

Potential salary for Snowflake Data Engineer role

Improve your resume now

$55 – $60/year

Quick Facts

  • Role: Data Engineer (Remote)

  • Assignment: 6-month contract with possible extension

Description

You will implement data pipelines that translate a data architecture vision into production-ready ingestion, transformation, matching, and analytics-layer data in the SLDS platform. The role uses Informatica and Snowflake to ingest partner agency data, build harmonized longitudinal records, enforce data quality and privacy compliance, and maintain scheduled feed operations with incident response. You will join the project team in January 2027 and transition from shadowing/co-running to full production operations ownership after structured knowledge transfer.

Requirements

  • Must reside in the State of Colorado for the full engagement

  • 5+ years of Snowflake ETL/ELT pipeline development, orchestration, and optimization

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

  • 1+ year Terraform experience

  • Proficiency using Azure DevOps for automated CI/CD build, test, and release deployments

  • Expert Git/version control proficiency (branching, PRs, automated merge checks, code reviews)

Responsibilities

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

  • Transform raw feeds into harmonized longitudinal and analytics layer data models following naming/modeling standards

  • Execute SLDS record linkage and identity matching logic, including match exception handling and cross-agency reconciliation

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

  • Implement data quality validations (L1 structural/format, L2 completeness/deduplication, L3 referential integrity/logic), layout-change detection, audit trails, and governance enforcement (privacy, suppression, and compliance)

  • Optimize Snowflake compute, query execution, and pipeline performance for cost and latency

  • Follow unified release processes across Development, Test, UAT, and Production using Azure DevOps and Azure Test Plans

  • Author/execute test cases, perform peer code reviews, and maintain release change logs

  • Support knowledge transfer and operational transition (shadowing/co-running in Jan–Feb 2027; unaided feed cycles by March 2027; full production operations from March 2027 onward)

Benefits

  • Supplemental insurance options: medical, dental, vision, life, and disability

  • ESPP and 401(k) with typical contribution start after ~30 days and company match after 12 months

  • HSA option and EAP (up to 8 free counseling sessions)

  • Professional development, certification prep/discounts, and on-demand training after 6+ months tenure

  • Career coaching and access to a benefits resource package

See similar jobs

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

See more

Unlock Full Resume Report