Snowflake Data Engineer
Innosoul 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 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
Snowflake ETL/ELT Data Engineer
Cleo Consulting 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

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

Snowflake Data Engineer (Energy sector project)
Link Group
Mid
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.

Senior Data Engineer (Snowflake & Databricks)
Itransition
Senior
Technology
Warsaw, Poland · Remote
N/A
15 days ago
Senior Data Engineer (Snowflake)
Acaisoft
Senior
Technology
Warsaw, Poland · Remote
N/A
12 days ago

Snowflake Engineer
Experis Manpower Group
Mid
Technology
Kraków, Poland · Remote
N/A
11 days ago
Data Engineer (Snowflake)
Godel Technologies Europe
Mid
Technology
Warsaw, Maz, Poland · Remote
11k zł - 17k zł/yr
1 days ago
Unlock Full Resume Report
ATS Pass
Missing keywords
Tailored AI suggestions
Job match analysis
Interview-focused insights