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