We are currently hiring for an experienced Data Engineer for a State of Colorado (OIT) project. This is a remote opportunity; however, candidates must currently reside in Colorado, with a strong preference for candidates within 100 miles of the Denver Metro area.
- Job Title: Data Engineer
- Client: State of Colorado – Office of Information Technology (OIT)
- Location: Remote – Colorado residents only
- Work Arrangement: 100% Remote
- Engagement: - 6 Month Contract (with possibility of extension based on project performance and state funding)
Required Technical Skills:
- Snowflake ETL/ELT – 5+ Years
- Strong hands-on experience developing and managing complex ETL/ELT pipelines using Snowflake.
- Expertise in Snowflake SQL, data transformations, data ingestion, and performance optimization.
- Experience building analytical data models and optimizing warehouse performance.
- Hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC).
- Knowledge of metadata management, data profiling, data cataloging, and automated data quality validation.
- Ability to implement data governance and quality standards.
- Terraform / Infrastructure as Code – 1+ Year
- Experience using Terraform to provision, configure, and maintain cloud infrastructure and resources.
- Understanding of infrastructure automation and configuration management.
- Experience implementing CI/CD pipelines for automated builds, testing, and deployments using Azure DevOps.
- Strong knowledge of Git, branching strategies, pull requests, code reviews, and version control workflows.
Key Responsibilities:
- Design, develop, test, and maintain automated ETL/ELT data pipelines using Snowflake and Informatica.
- Ingest data from multiple state agencies and third-party source systems into a centralized data platform.
- Develop data transformation logic to convert raw data into structured, standardized, and analytics-ready datasets.
- Implement data cleansing, validation, reconciliation, and data quality checks.
- Perform record linkage and identity matching across student and workforce datasets.
- Monitor production data pipelines, troubleshoot failures, and manage scheduled data loads.
- Optimize Snowflake queries, warehouse performance, and data processing costs.
- Collaborate with Data Architects, Data Scientists, and other engineering teams.
- Maintain technical documentation, testing records, and deployment procedures.
Preferred Qualifications:
- Experience working on government or public-sector data projects.
- Background in education, student, or workforce data systems.
- Experience with entity resolution, record linkage, and identity matching.
- Knowledge of FERPA, COPPA, and data privacy regulations.
- Experience with Azure Test Plans and structured software testing.