Data Engineer
Senior Data Engineer (Snowflake & Informatica) Job Title (Standard LinkedIn Taxonomy): Senior Data Engineer / Data Engineer / ETL Developer
Job Type: Full-Time Contract (6 Months, with strong potential for extension)
Location: Remote
Work Schedule: Monday – Friday, Standard Business HoursJob Overview
We are seeking a highly technical Senior Data Engineer to design, build, optimize, and operate cloud-based data ingestion and transformation pipelines using Snowflake and Informatica. In this role, you will partner closely with Data Architects, Data Scientists, and third-party implementation specialists to ingest multi-source data feeds into an enterprise longitudinal data foundation, build scalable analytics layer models, manage identity-matching workflows, and transition into full production ownership.
Key Responsibilities:
Data Ingestion & Pipeline Engineering: Design, develop, test, and deploy automated ETL/ELT workflows in Informatica and Snowflake to ingest multi-source feeds into a unified enterprise data model.
Data Transformation & Analytics Modeling: Build and maintain SQL transformation pipelines to convert raw feeds into harmonized, linked longitudinal records and analytics-ready models for downstream BI tools (e.g., Tableau).Identity Matching & Record Linkage: Execute and troubleshoot record-linkage logic to match newly ingested records to master profiles, resolving match exceptions and cross-source reconciliations.
Data Quality & Privacy Governance: Implement multi-tier validation checks (structural, completeness/deduplication, and referential integrity), automated layout-change detection, and strict data suppression/privacy rules (FERPA, COPPA, ADA).Production Operations & Knowledge Transfer: Participate in structured operational transition—shadowing and co-running live data cycles before assuming full production ownership, job monitoring, incident triage, and row-count reconciliation.
Snowflake Performance Optimization: Tune SQL queries, warehouse compute sizing, auto-shutdown policies, and high-usage data models for optimal latency and cost efficiency.
CI/CD, Testing & Documentation: Adhere to structured release workflows across Dev, Test, UAT, and Prod using Azure DevOps and Azure Test Plans; conduct peer code reviews and maintain technical specifications, data lineage maps, and operational runbooks.
Required Qualifications & Technical Skills:
Snowflake ETL/ELT: Minimum 5+ years of hands-on experience designing, orchestrating, and optimizing complex ETL/ELT data pipelines and SQL transformations natively within Snowflake.
Informatica CDGC: Minimum 1+ year of hands-on experience with Informatica Cloud Data Governance and Catalog (CDGC) for metadata management, profiling, cataloging, and automated data quality rules.
Infrastructure as Code (IaC): Minimum 1+ year of experience provisioning and maintaining cloud infrastructure using Terraform.
DevOps & CI/CD: Proven proficiency building and managing automated build, test, and release pipelines in Azure DevOps.
Version Control: Expert knowledge of Git workflows (branching strategies, pull requests, automated checks, and peer code reviews).Location & Residency: Must currently reside in the State of Colorado for the entire duration of the assignment.
Preferred Qualifications:
Prior experience supporting longitudinal education, workforce, or public-sector data platforms.
Hands-on experience with entity resolution, deterministic/probabilistic record linkage, and master identity matching across disparate datasets.
Strong working knowledge of federal/state data privacy standards (such as FERPA, COPPA, and statistical cell suppression).Experience authoring and executing structured QA test cases within Azure Test Plans.