Senior Data Engineer
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