Application Developer (Data Engineer)

Prismagic Solutions Inc

Denver, CO • 1h ago • On-site

Mid

On-site

60 - 65 USD/yr

  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

Potential salary for Application Developer (Data Engineer) role

Improve your resume now

$60 – $65/year

Quick Facts

  • Role: Data-focused Application Developer / Data Engineer

  • Work: Remote/telecommuting (must reside in Colorado)

  • Engagement: 6-month contract (possible extension)

Description

You will implement and help operationalize data pipelines for SLDS/COdata by ingesting partner agency data, transforming it into a common longitudinal data model, and supporting the analytics layer in Snowflake. The position includes record linkage/identity matching, production incident response for scheduled feed runs, and data quality/governance validation with required privacy compliance. A knowledge-transfer period (shadowing/co-running) prepares you to lead ongoing production operations.

Responsibilities

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

  • Implement transformation logic for harmonized longitudinal records and analytics models aligned to Data Architect standards

  • Execute SLDS internal matching logic to link ingested records to master longitudinal student and workforce profiles

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

  • Implement L1/L2/L3 data validation checks, layout-change detection, and audit trails

  • Enforce data privacy, suppression rules, and compliance (FERPA, COPPA, ADA, and state statutes)

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

  • Follow QA and release promotion across Development, Test, UAT, and Production using Azure DevOps and Azure Test Plans

  • Author and execute test cases; maintain release change logs

  • Lead specific new source ingestions and progressively take over production operations and upkeep

Requirements

  • 5+ years of Snowflake ETL/ELT pipeline development, orchestration, and optimization experience

  • 1+ year experience with Informatica Cloud Data Governance and Catalog (CDGC)

  • 1+ year experience using Terraform for infrastructure provisioning/configuration

  • Demonstrated proficiency with CI/CD using Azure DevOps

  • Expert proficiency with Git/version control workflows

  • Structured testing experience using Azure Test Plans

  • Must currently reside in Colorado for the duration of the engagement

Benefits

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

  • Remote/telecommuting arrangement (Colorado residency required)

  • Structured knowledge transfer (shadowing/co-running) leading to production handover

See similar jobs

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

See more

Unlock Full Resume Report