Data Engineer

Syntricate

Denver, CO • 1h ago • On-site

Mid

On-site

  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 (Client Data Engineer for SLDS)

  • Focus: ETL/ELT pipelines, transformations, identity matching, and production operations

Description

Build and operate automated data pipelines in Informatica and Snowflake to ingest partner agency and third-party data into a common longitudinal data model. Implement transformation logic, data cleansing and quality validation (L1–L3), and identity matching/linkage to harmonize records into master longitudinal profiles. Progressively take operational ownership of scheduled feed runs, incident response, and analytics layer upkeep, including performance tuning and controlled releases.

Responsibilities

  • Design, develop, test, and deploy ETL/data pipelines in Informatica and Snowflake

  • Transform raw feeds into harmonized, linked longitudinal records and analytics layer models aligned to naming/modeling standards

  • Execute record linkage and internal matching logic; handle match exceptions and cross-agency reconciliations

  • Maintain production pipeline operations: monitor scheduled feed runs, resolve failures, reload late/corrected files, reconcile row counts, and rebuild downstream objects

  • Implement data quality and governance compliance checks (L1 structural/format, L2 completeness/de-duplication, L3 referential integrity/logic), layout-change detection, and audit trails; enforce privacy, suppression rules, and compliance standards (FERPA, COPPA, ADA, and state statutes)

  • Optimize query execution, warehouse compute, and pipeline performance for cost and latency; tune heavily used models and performance hot spots

  • Author and execute test cases in Azure Test Plans, conduct peer code reviews, and follow unified release processes across Development, Test, UAT, and Production using Azure DevOps

  • Collaborate with the Data Architect on data model/pipeline design and support integration for analytics/visualizations and de-identified outcome extraction

Benefits

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

  • Remote/telecommuting (must reside within the State of Colorado)

See similar jobs

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

See more

Unlock Full Resume Report