
Data Engineer
RedSalsa Technologies, Inc.
Denver, CO • 1h ago • Hybrid
Senior
Hybrid
Match your resume with similar open roles
Upload your resume to automatically match with active openings similar to this role.
Quick Facts
Role: Data Engineer
Duration: 6+ month contract (possible extension)
Work model: Remote/telecommuting (must reside in Colorado)
Description
Support a statewide longitudinal data system (SLDS/COdata) by designing, building, testing, and deploying automated ETL/ELT pipelines using Informatica and Snowflake. Implement transformations into the common data model, perform record linkage/identity matching, and gradually take over production feed operations and upkeep of the analytics layer. Execute data quality validations and privacy/compliance governance (FERPA, COPPA, ADA, and state statutes) and promote changes using Azure DevOps and Azure Test Plans.
Responsibilities
Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake for data ingestion.
Implement transformation logic to harmonize and link longitudinal records aligned to core naming/modeling standards.
Execute internal matching logic to link newly ingested records to master longitudinal student/workforce profiles.
Own production pipeline operations: monitor scheduled runs, resolve failures, reload late/corrected files, reconcile row counts, and rebuild downstream objects.
Implement multi-level validation (L1–L3) and enforce data privacy, suppression rules, and compliance standards (FERPA, COPPA, ADA, state statutes).
Optimize Snowflake compute/query performance for cost and latency.
Author and execute test cases, conduct peer code reviews, and maintain release change logs across Dev, Test, UAT, and Production using Azure DevOps.
Key Activities & Knowledge Transfer
Ingest and validate CDHE course data and other conditional postsecondary and assessment feeds, map them to the SLDS common data model, and validate per agreements.
Shadow and co-run third-party feed operations (Jan–Feb 2027), then run feed cycles unaided for hand-over sign-off (target March 2027).
Stabilize data reliability defects and harden analytics layer models and RAW layer practices (April 2027 onward).
Deliverables
Production ETL/ELT pipelines, cleansing/validation modules (L1–L3), and identity matching/linkage routines.
Analytics layer transformation objects (views/tables/metric models) and de-identified/suppressed extraction scripts.
ETL design and mapping specifications, lineage/dependency documentation, operational runbooks, and governance/testing/release artifacts.
Requirements
5+ years of Snowflake-native ETL/ELT pipeline and transformation development/optimization
1+ year hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC)
1+ year experience with Terraform (IaC)
Proficiency with CI/CD using Azure DevOps
Expert proficiency with Git and version control workflows (branching, PRs, reviews)
Ability to author and execute test cases in Azure Test Plans
Must currently reside in the State of Colorado for the duration of the engagement
Benefits
6-month contract with potential extension
Remote/telecommuting; must be based in Colorado (preferred: Denver Metro)
See similar jobs
Explore similar jobs and use your resume score to choose where to apply next
See more
Data Engineer
Syntricate
Mid
Technology
Denver, CO · On-site
N/A
1h ago

Snowflake ETL/ELT Data Engineer
Cleo Consulting Inc.
Senior
Technology
Remote
N/A
1 days ago
Snowflake Data Engineer
Innosoul inc
Senior
Technology
Remote
N/A
1 days ago

Application Developer (Data Engineer)
Prismagic Solutions Inc
Mid
Technology
Denver, CO · On-site
N/A
1h ago

Snowflake Data Engineer
Apex Systems
Mid
Technology
Denver, CO · On-site
N/A
1h 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 Snowflake Data Engineer
Paramount Software Solutions, Inc
Senior
Technology
Denver, CO, United States of America · Remote
N/A
1h ago

Senior Data Engineer (Snowflake & Informatica)
Info Origin Inc.
Senior
Technology
Denver, CO · On-site
N/A
1h ago

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

Data engineer
co.brick Talents
Mid
Technology
Gliwice, SL, Poland · Remote
250k zł - 354k zł/yr
7 days ago
Unlock Full Resume Report
ATS Pass
Missing keywords
Tailored AI suggestions
Job match analysis
Interview-focused insights