DataJobs.io
← Back to all jobs

Job Description

Seeking a Senior Data Engineer in Denver, CO to build and run enterprise data pipelines across analytics and governance layers.

Responsibilities

  • Design, develop, test, and deploy automated ETL/ELT pipelines using Snowflake and Informatica
  • Create data ingestion workflows to bring data from multiple source systems into centralized analytical platforms
  • Develop complex SQL transformations, data cleansing routines, and data validation processes
  • Implement data quality checks for completeness, accuracy, duplicate detection, and referential integrity
  • Support data modeling, transformation logic, and analytics-layer development
  • Run data reconciliation, troubleshoot pipeline failures, and manage production data operations
  • Optimize Snowflake queries, warehouse utilization, and overall pipeline performance
  • Apply metadata management, data profiling, cataloging, and governance practices
  • Use Terraform to provision and configure infrastructure

Requirements

  • Experience with Snowflake ETL/ELT development, data pipelines, and transformation
  • Experience with Informatica Cloud Data Governance and Catalog (CDGC)
  • Experience using Terraform for Infrastructure as Code (IaC)
  • Strong proficiency in Snowflake SQL, data transformations, and data pipeline optimization
  • Experience implementing CI/CD pipelines using Azure DevOps
  • Strong working knowledge of Git, branching strategies, pull requests, and version control workflows
  • Experience implementing data quality validation, data cleansing, and metadata management
  • Strong troubleshooting, analytical, and problem-solving skills

Technologies

  • Snowflake
  • Informatica
  • Informatica Cloud Data Governance and Catalog (CDGC)
  • ETL, ELT
  • SQL
  • Terraform
  • Azure DevOps
  • Git
  • CI/CD

Preferred Qualifications

  • Experience working with government or public-sector data systems
  • Knowledge of education, student, and workforce data platforms
  • Experience with record linkage, entity resolution, and identity matching
  • Familiarity with FERPA, COPPA, data privacy, and data suppression requirements
  • Experience with Azure Test Plans and structured test execution
  • Experience supporting Tableau reporting and analytical data models

Location & Compensation

  • Location: Denver, CO (onsite)
  • Pay: USD 78 per hour

Similar Jobs