> Markdown version of [/jobs/ext/4800818-data-engineer-snowflake-informatica-azure-devops](https://www.wearedevelopers.com/jobs/ext/4800818-data-engineer-snowflake-informatica-azure-devops). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - Snowflake, Informatica & Azure DevOps - **Company:** OP Consulting Group LLC - **Location:** United States (Remote available) - **Contract:** Contract - **Skills:** Query Performance, Business Analytics Applications, Data Analysis, Business Logic, Microsoft Azure, Big Data, Cloud Computing, Code Review, Continuous Integration, Data Validation, Data Cleansing, Information Engineering, Data Files, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Profiling, Data Security, Data Systems, Data Warehousing, Meta-Data Management, Operational Databases, Raw Data, Release Management, SQL Databases, Test Execution Engine, Enterprise Data Management, Data Ingestion, Informatica Powercenter, Delivery Pipeline, Snowflake, Informatica Cloud, Software Troubleshooting, Infrastructure as Code (IaC), Git, Git Flow, Data Lineage, Tools for Reporting, Entity Resolution, Terraform, Software Version Control, Data Pipelines - **Published:** November 20, 2026 - **Apply:** https://www.dice.com/job-detail/776e123a-6a03-47dc-ba15-f26266e4027b ## About the Role * Snowflake ETL/ELT - Minimum 5 Years: Demonstrated experience designing, building, orchestrating, and optimizing complex ETL/ELT data pipelines and transformation logic natively within Snowflake. * Informatica CD- Minimum 1 Year: Hands-on experience with Informatica Cloud Data Governance and Catalog for metadata management, data profiling, cataloging, and automated data quality validation. * Terraform - Minimum 1 Year: Experience utilizing Infrastructure as Code (IaC) to provision, configure, and maintain cloud infrastructure and resources. * Azure DevOps: Demonstrated proficiency implementing automated build, testing, and deployment pipelines. * Git / Version Control: Expert knowledge of branching strategies, pull requests, automated merge checks, and code review processes. * Strong experience with SQL, data transformation, data cleansing, and enterprise data integration. * Knowledge of data warehousing, data modeling, data governance, and analytical data platforms. * Ability to troubleshoot complex data pipeline failures and optimize query performance., * Previous experience working with public sector, education, or workforce data systems. * Experience handling large-scale longitudinal datasets and complex data integration environments. * Knowledge of record linkage, entity resolution, and deterministic/probabilistic identity matching. * Familiarity with FERPA, COPPA, and applicable data privacy and suppression standards. * Experience developing structured test plans and executing tests using Azure Test Plans. * Experience supporting enterprise data modernization and cloud-based analytics initiatives. * Strong troubleshooting, analytical, communication, and documentation skills., * Extension: Possible, based on project performance and funding. * Work Arrangement: Remote / Telecommuting * Location Requirement: Must currently reside in Colorado and remain within the state for the duration of the engagement. * Preferred Location: Denver Metro Area * Local Candidates: Strongly preferred. Important: Candidates must meet the required technical experience and location requirements to be considered. ## Description We are seeking an experienced Data Engineer with strong expertise in Snowflake, Informatica, Azure DevOps, and enterprise data integration to support a large-scale data modernization and analytics initiative. The Data Engineer will be responsible for designing, developing, testing, deploying, and maintaining enterprise ETL/ELT pipelines that integrate data from multiple source systems into centralized analytical platforms. The ideal candidate will have hands-on experience with Snowflake data engineering, Informatica Cloud Data Governance and Catalog (CDGC), Terraform, CI/CD automation, data quality management, and complex data transformation processes. The role involves close collaboration with Data Architects, Data Scientists, reporting teams, and implementation partners to ensure reliable, scalable, and secure data integration and analytics solutions., * Design, develop, test, and deploy automated ETL/ELT pipelines using Informatica and Snowflake. * Integrate data from multiple enterprise systems, external partners, and third-party sources into centralized analytical platforms. * Develop data mapping and transformation processes to standardize and harmonize data from disparate source systems. * Implement automated data ingestion, validation, cleansing, and reconciliation processes. * Support the integration of structured data into enterprise data warehouse and analytics environments., * Develop and maintain transformation logic to convert raw data into structured, standardized, and analytics-ready datasets. * Implement data models and transformation processes aligned with established architecture standards. * Support longitudinal data analysis, reporting, and business intelligence requirements. * Develop and maintain Snowflake tables, views, and analytical models. * Optimize SQL queries, transformation processes, and warehouse performance. 3. Record Linkage & Data Quality Management * Implement record linkage and identity-matching processes across multiple data sources. * Develop data validation and reconciliation routines to ensure data accuracy and consistency. * Implement data quality checks, including: + Level 1: Structural and format validation. + Level 2: Completeness and duplicate detection. + Level 3: Referential integrity and business logic validation. * Maintain audit trails, data lineage, and metadata documentation. * Support compliance with applicable data privacy, security, and governance requirements. 4. Production Pipeline Operations & Support * Monitor and maintain scheduled ETL/ELT workflows and production data pipelines. * Troubleshoot pipeline failures, data loading errors, and transformation issues. * Manage late-arriving or corrected data files and execute necessary reloads. * Reconcile source and target record counts to ensure data completeness. * Maintain operational documentation, incident response procedures, and pipeline runbooks. * Optimize Snowflake compute utilization, query execution, and pipeline performance for cost efficiency and reliability. 5. Testing, CI/CD & Release Management * Develop and execute manual and automated test cases for data pipelines and transformation processes. * Utilize Azure DevOps and Azure Test Plans for testing, defect tracking, and release management. * Support deployment activities across Development, Test, UAT, and Production environments. * Conduct peer code reviews and enforce version control best practices. * Maintain detailed release documentation, change logs, and deployment records. * Ensure successful validation and testing before production releases. 6. Knowledge Transfer & Operational Transition * Collaborate with implementation partners and technical teams during knowledge-transfer activities. * Participate in shadowing, co-running, and independent execution of production data operations. * Support the transition of data pipeline ownership from implementation teams to internal operations. * Develop technical documentation and operational procedures for long-term maintenance. * Independently manage production feed cycles, troubleshoot issues, and support operational continuity. 7. Cross-Functional Collaboration * Partner with Data Architects to review logical and physical data models and pipeline designs. * Collaborate with Data Scientists and reporting teams to prepare datasets for analytical and visualization requirements. * Support Tableau dashboards and other reporting solutions through reliable data integration. * Coordinate with infrastructure and operations teams on Snowflake resource management, permissions, and CI/CD processes. * Participate in technical discussions, design reviews, and solution planning activities., * Production-ready Informatica and Snowflake ETL/ELT pipelines. * Automated data cleansing, validation, and reconciliation modules. * Record linkage and identity-matching routines. * Snowflake transformation objects, analytical tables, and reporting views. * Data mapping specifications and source-to-target documentation. * Data lineage diagrams and technical architecture documentation. * Operational runbooks and incident response procedures. * Azure Test Plans, test execution records, and defect logs. * Release documentation and deployment change logs. * Production monitoring reports and data quality summaries.