DeveloperJobs.io
← Back to all jobs

Job Description

Lead the design and operation of enterprise data pipelines across ingestion, transformation, validation, and production support.

Responsibilities

  • Design, build, test, and deploy automated ETL/ELT pipelines using Snowflake and Informatica
  • Create ingestion workflows that integrate 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 components

Requirements

  • Experience in Snowflake ETL/ELT development, data pipelines, and transformation
  • Experience with Informatica Cloud Data Governance and Catalog (CDGC)
  • Experience with Terraform for Infrastructure as Code (IaC)
  • Strong proficiency in Snowflake SQL, data transformations, and pipeline optimization
  • Experience implementing CI/CD pipelines using Azure DevOps
  • Strong 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: Denver, CO (onsite)

Compensation: USD 78 - 78 per hourly

Similar Jobs