2,398,867open jobs
149,645companies
293,344added this week
Browse all
Location
Remote (United States)
Employment
Contractor

First seen by Alion on Nov 19, 2026.

Overview
Company
Impact
Profile match
Explore our core services including ERP program execution, PMO advisory, and specialized workforce solutions designed to strengthen program governance and delivery.
Job 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.

Required Qualifications & Technical Skills

  • 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.

Key Responsibilities

1. Data Ingestion & Pipeline Engineering
  • 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.

2. Data Transformation & Analytics Support
  • 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.

Preferred Qualifications

  • 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.

Expected Deliverables

  • 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.

Work Arrangement & Contract Details

  • Position: Data Engineer

  • Contract Duration: 6 Months

  • 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.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,398,867 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Similar stack
Same company
In your city
Remote (Brazil) · Full-Time · Barueri
Python
SQL
Databases
Databricks
Microsoft Fabric
AI/ML
Machine Learning
DevOps
Azure
Git
Analytics
Power BI
ETL/ELT
Apply
Data Scientist 7 hours ago
Remote (Italy) · Freelance · Italy
Python
SQL
Databases
Databricks
AI/ML
Scikit-learn
TensorFlow
Machine Learning
Apply
$85k – $125k per year · Remote (United States) · Full-Time · Indianapolis
Python
JavaScript
SQL
Python
pySpark
Databases
MySQL
PostgreSQL
AI/ML
Spark
Dagster
Frontend
D3.js
DevOps
Rest API
Terraform
CloudFormation
Datadog
CI/CD
Git
AWS
Docker
Kubernetes
Amazon EKS
AWS Lambda
Amazon S3
Amazon ECS
HPC
Analytics
ETL/ELT
Dimensional Modeling
Management
Agile
Apply
Data Engineer 6 hours ago
Remote (United States) · Contractor
Databases
Snowflake
DevOps
Terraform
Azure DevOps
Azure
CI/CD
Git
Analytics
ETL/ELT
Informatica
Apply
Staff Data Engineer 5 hours ago
Remote (United States) · Contractor · 7+ years exp · Chicago
Python
Go
JavaScript
Java
SQL
Scala
Java
Spring Boot
Databases
PostgreSQL
Apache Kafka
Google BigQuery
Google Cloud Spanner
Google Bigtable
AI/ML
Cursor
Claude
Hadoop
Spark
Airflow
Gemini
Frontend
React.js
Material UI
DevOps
Terraform
GCP
CI/CD
Apply
See all jobs
This is one of many
2,398,867 more open roles from verified company boards, updated every day.