Data Engineer

RedSalsa Technologies, Inc.

Denver, CO • 1h ago • Hybrid

Senior

Hybrid

  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: 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

Unlock Full Resume Report