Snowflake Data Engineer

Key skills: Snowflake, Netezza, Datastage, Healthcare

Project role : Snowflake Data Engineer

Location: REMOTE

Duration: Full-Time

Job Summary:


We are seeking a Data Engineer with deep expertise in Data Warehousing, Cloud Technologies, and Snowflake, along with extensive experience in the Healthcare domain, particularly in Payer and Provider systems.


This role requires a combination of technical leadership, solution design, and hands-on expertise to develop scalable and compliant data architectures for enterprise healthcare solutions. Experience with IBM data warehousing technologies, including IBM NPS (Netezza Performance Server), IBM DataStage, and IBM Workload Scheduler (IWS) Jobs, is highly desirable.

Key Responsibilities:

Solution Architecture & Design:


Design and implement enterprise-scale data warehouse solutions using Snowflake and IBM Netezza (NPS) for healthcare data processing and analytics.


Develop secure, scalable, and HIPAA-compliant cloud-based architectures.


Define best practices, frameworks, and governance for healthcare data integration, interoperability, and analytics.


Architect solutions for payer and provider data management, including claims processing, eligibility verification, risk adjustment, and quality reporting.

Healthcare Data & Cloud Technologies Expertise:


Deep understanding of payer-provider ecosystems, including claims, billing, member enrollment, care management, and EDI transactions (837, 835, 270/271, etc.).


Design and optimize large-scale ETL/ELT pipelines using IBM DataStage and Snowflake for structured and unstructured healthcare data.


Implement FHIR, HL7, EDI, HIPAA, and SOC2-compliant data architectures.


Expertise in Snowflake's features like Snowpipe, Streams, Secure Data Sharing, and Data Cloning.


Experience in cloud migration strategies (AWS, Azure, GCP) and performance tuning of cloud-based healthcare data platforms.


Experience with IBM Workload Scheduler (IWS) Jobs for automating and orchestrating healthcare data workflows.

Collaboration & Leadership:


Work closely with healthcare business leaders, product managers, and IT teams to translate complex business needs into scalable solutions. Lead technical discussions, architectural reviews, and strategic roadmaps for payer and provider data ecosystems.


Mentor and guide junior architects, engineers, and data professionals in healthcare-specific data management best practices.

Onsite Client Engagement:


To engage with healthcare clients, payers, providers, and IT teams. Act as a trusted advisor to clients, driving value-based care initiatives, population health analytics, and claims data modernization.


Bridge communication gaps between business, compliance, and technical teams.


Required Skills & Qualifications:


10+ years of experience in Data Architecture, Cloud Technologies, and Solution Design.


Expert in Snowflake and IBM NPS ( Netezza ), including performance tuning, security, and healthcare data optimization.


Strong experience in cloud platforms - AWS, Azure, or GCP.


Extensive hands-on experience in IBM DataStage and IBM Workload Scheduler (IWS) Jobs for ETL and job automation.


Extensive experience in US healthcare , payer-provider data models, and regulatory frameworks (HIPAA, CMS, NCQA, ONC). Proficiency in SQL, Python, ETL/ELT tools (e.g., IBM DataStage, Matillion, Talend, Informatica).


Experience with healthcare analytics, predictive modeling, and reporting solutions.


Strong understanding of value-based care models, HEDIS, risk adjustment, and quality reporting.


Preferred Qualifications:


Snowflake Architect Certification.


Experience with FHIR, HL7, EDI transactions, and interoperability solutions.


Knowledge of IBM Netezza (NPS), DataStage, and IWS Job scheduling in a healthcare data environment.


Experience with real-time data streaming (Kafka, Spark Streaming, Databricks) in healthcare.


Experience in AI/ML-driven healthcare analytics.