Senior Data Engineer: Ab Initio & Snowflake on Azure

NEPSE Trading; Northern (KY); Hybrid; USD 130,000 - 170,000; Full time

Job summary

Metova Talent in the United States is seeking a Senior Data Engineer with deep Ab Initio and Snowflake experience to design, develop, and support enterprise-scale data integration and data warehouse solutions within a large Azure data environment.

You will handle hundreds of Ab Initio processes, implement CI/CD workflows, and collaborate with cross-functional teams to deliver reliable, scalable data pipelines across healthcare domains.

Qualifications

• 6+ years of hands-on Ab Initio development.
• 4+ years of Snowflake development and architecture.
• Advanced SQL skills including complex joins, subqueries, stored procedures, dynamic SQL, and tuning.
• Experience with Ab Initio EME / Metadata Hub and version control.
• Knowledge of data warehouse architecture: dimensional modeling, Star/Snowflake, Data Vault, and MD M concepts.
• Proficiency in Python and Shell scripting (KSH/Bash).
• Experience with DevOps and CI/CD, Git, automated deployments and release management.
• Experience in Azure-based data environments and healthcare data domains.

Responsibilities

• Design, develop, and support high-volume ETL/ELT data integration solutions using Ab Initio and Snowflake.
• Develop and maintain Ab Initio graphs, Plans, PSETS, Continuous Flows, and batch processing frameworks.
• Build reusable ETL components, transformations, DML files, XFRs, and PDL scripts.
• Manage and support Ab Initio EME / Metadata Hub, including metadata, lineage, impact analysis, and dataset mapping.
• Develop and optimize Snowflake solutions, including Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning.
• Perform advanced SQL development, query optimization, data reconciliation, and data quality validation.
• Design and maintain data warehouse solutions using dimensional modeling, Star/Snowflake schemas, and Data Vault concepts.
• Develop automation and operational support tools using Python and Shell scripting (KSH/Bash).
• Support batch, real-time, file-based, and API-driven data integrations.
• Participate in CI/CD, Git-based development, code promotion, branching, and release management processes.
• Troubleshoot production issues and ensure the reliability, scalability, and performance of data pipelines.
• Collaborate with technical and business teams to translate data requirements into scalable solutions.
• Work with healthcare data domains, including claims, membership, providers, health plans, benefits, and employer/group data.

Skills

Ab Initio development

Snowflake development

Advanced SQL

Python

Shell scripting (KSH/Bash)

ETL/ELT patterns

Data modeling

DevOps / CI/CD

Azure data environments

Healthcare data knowledge

Tools

Ab Initio EME / Metadata Hub

Snowpipe, Streams, Tasks

Git and version control

Job description

Metova Talent in the United States is seeking a Senior Data Engineer with deep Ab Initio and Snowflake experience to design, develop, and support enterprise-scale data integration and data warehouse solutions within a large Azure data environment.

You will handle hundreds of Ab Initio processes, implement CI/CD workflows, and collaborate with cross-functional teams to deliver reliable, scalable data pipelines across healthcare domains.