Senior Snowflake Data Engineer

Paramount Software Solutions, Inc

Denver, CO, United States of America • 1h ago • Remote

Senior

Remote

  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: Senior Data Engineer (Snowflake + Informatica)

  • Engagement: 6-month contract (possible extension)

  • Work arrangement: Remote (must reside in Colorado)

Description

The Data Engineer will realize the Data Architect’s vision by implementing data pipelines in Snowflake and Informatica—ingesting partner agency data into a longitudinal data platform. The role includes ETL/ELT development, transformation and analytics-layer support, record linkage/identity matching, production feed operations with incident response, and data quality and governance compliance. The engineer will participate in structured knowledge transfer and progressively take over production operations and upkeep of the SLDS foundation and analytics layer.

Responsibilities

  • Design, develop, test, and deploy automated ETL/data pipelines in Informatica and Snowflake for partner-state ingestion

  • Implement transformation logic to harmonize and link longitudinal student/workforce records to the common data model

  • Execute SLDS internal matching logic for identity linkage and reconcile match exceptions across agencies

  • Maintain operational ownership of scheduled feed runs: monitoring, failure resolution, reloading corrected/late files, row-count reconciliation, and downstream rebuilds

  • Implement multi-level data validation (structural/format, completeness/de-duplication, referential integrity/logic) and enforce privacy/suppression rules and compliance

  • Optimize Snowflake query execution and warehouse compute for cost and latency

  • Follow unified release process across Dev/Test/UAT/Production using Azure DevOps and Azure Test Plans

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

Key Activities (Examples)

  • CDHE Courses ingestion: validate and map annual postsecondary course files into the SLDS common data model

  • Conditional ingestion (postsecondary SES & Disability; PSAT/SAT assessments) including privacy protections and identity matching

  • Knowledge transfer and operational transition (shadowing/co-running), then run feed cycles unaided and take full production operations

  • Stabilization and analytics-layer hardening: RAW-layer layout-change detection, reconciliation across environments, metric/calc enhancements

  • Cross-functional collaboration: testing/release management, model review with Data Architect, and Tableau/dashboard data support

Benefits

  • 6-month contract with possible extension based on project performance and state funding

  • Remote/telecommuting opportunity (Colorado residency required)

See similar jobs

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

See more

Unlock Full Resume Report