
Snowflake ETL/ELT Data Engineer
Cleo Consulting Inc.
1h ago • Remote
Senior
Remote
Match your resume with similar open roles
Upload your resume to automatically match with active openings similar to this role.
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 moreSnowflake Data Engineer
Innosoul inc
Senior
Technology
Remote
N/A
1h ago

Snowflake Data Engineer (Energy sector project)
Link Group
Mid
Technology
Warsaw, Poland · Remote
N/A
15 days ago

Snowflake Data Engineer / Architect
Link Group
Mid
Technology
Warsaw, Poland · Remote
N/A
15 days ago

Data engineer
co.brick Talents
Mid
Technology
Gliwice, SL, Poland · Remote
250k zł - 354k zł/yr
6 days ago

Senior Data Engineer (Snowflake & Databricks)
Itransition
Senior
Technology
Warsaw, Poland · Remote
N/A
15 days ago
Tailor Resume to fit the Job Offer
Use AI to find out how well the skills on your resume fit this job description.

Snowflake Data Engineer (Energy sector project)
Link Group
Mid
Technology
Warsaw, Poland · Remote
N/A
15 days ago
Senior Data Engineer (Snowflake)
Acaisoft
Senior
Technology
Warsaw, Poland · Remote
N/A
12 days ago
Data Engineer / Senior Data Engineer
Sigmoidal AI
Senior
Technology
Wrocław, DS, Poland · Remote
30k zł - 36k zł/yr
7 days ago

Data Engineer (with Snowflake & Airflow)
TQLO SP. Z O.O.
Senior
Technology
Warsaw, Maz, Poland · Remote
N/A
15 days ago
Unlock Full Resume Report
ATS Pass
Missing keywords
Tailored AI suggestions
Job match analysis
Interview-focused insights