HIE – Intersystems Consultant (Data Migration to Snowflake/Databricks)

Big Resourcing; Snowflake (AZ); On-site; USD 90,000 - 130,000; Part time

Job summary

A leading technology consulting firm is looking for an HIE Intersystems Consultant to drive data migration to Snowflake and Databricks. The role requires 5+ years of Data Engineering experience, strong skills in cloud engineering, and a solid foundation in HIPAA compliance. You will work closely with teams in the U.S. and India, building and optimizing ETL pipelines for high volume healthcare datasets. This is a part-time, remote position with the opportunity to contribute to innovative cloud modernization solutions.

Qualifications

• 5+ years as a Data Engineer with strong cloud engineering experience.
• Hands‑on expertise with InterSystems (Caché/IRIS) for data extraction and transformations.
• Strong experience building solutions with Snowflake and cloud-native data warehousing.

Responsibilities

• Lead end‑to‑end migration of datasets from InterSystems to Snowflake and Databricks.
• Build and optimize large‑scale ETL pipelines supporting 5M+ records.
• Implement PHI de‑identification and masking processes aligned with HIPAA.

Skills

Data Engineering

Cloud Engineering

InterSystems (Caché/IRIS)

Snowflake

Databricks

ETL Pipeline Optimization

HIPAA Compliance

AWS RDS

SQL

Python

Tools

Spark

PySpark

Delta Lake

Job description

HIE – Intersystems Consultant (Data Migration to Snowflake/Databricks)

Location: Remote NYC

Contract: Ongoing Contract-Part-time

About BigRio: BigRio is a Boston-headquartered, remote‑first technology consulting firm specializing in AI/ML, Cloud Transformation, Data Engineering, Healthcare Modernization, and Digital Innovation. We partner with leading healthcare, life sciences, and enterprise organizations to modernize legacy systems, build intelligent data platforms, and accelerate AI‑driven operations.

As part of our expanding Cloud & Data Engineering practice, we are looking for a talented Data Engineer to support a high‑impact healthcare data migration initiative.

About the Role

We are seeking a highly skilled HIE Intersystems Consultant with hands‑on experience migrating data from InterSystems to modern cloud data platforms, specifically Snowflake and Databricks. The role focuses on building secure, scalable pipelines to migrate large‑volume datasets (5M+ records), including accurate de‑identification of PHI, ensuring compliance with healthcare privacy standards.

You will be a core contributor to BigRio’s cloud modernization solutions, working closely with internal stakeholders and client teams.

Key Responsibilities

• Lead end‑to‑end migration of datasets from InterSystems (Caché/IRIS) to Snowflake and Databricks within BigRio’s cloud modernization framework.
• Build, optimize, and maintain large‑scale ETL pipelines supporting 5M+ records with high performance and reliability.
• Implement PHI de‑identification and masking processes aligned with HIPAA and BigRio security best practices.
• Develop scalable data processing jobs using Databricks (Spark, PySpark, Delta Lake).
• Integrate data workflows with AWS RDS, Snowflake, and Databricks.
• Work with BigRio’s architecture and AI engineering teams to support analytics, reporting, and ML/GenAI initiatives.
• Ensure data quality, monitoring, and validation throughout migration cycles.
• Maintain documentation of architecture, data lineage, transformation logic, and operational procedures.
• Collaborate with sill distributed BigRio and client teams across the U.S. and India.

Required Skills & Experience

• 5+ years as a Data Engineer, with strong cloud engineering experience.
• Hands‑on expertise with InterSystems (Caché/IRIS) – extraction, schema mapping, transformations.
• Strong experience building solutions with Snowflake and cloud‑native data warehousing.
• Expertise with Databricks, Spark, and PySpark for large‑scale processing.
• Proven ability to build and optimize ETL pipelines handling 5M+ record volumes.
• Strong క్య understanding of PHI de‑identification, HIPAA compliance, and healthcare data workflows.
• Experience with AWS RDS, SQL, Python, and cloud orchestration tools.
• Strong foundation in data modeling, performance tuning, and scalable architecture.
• Excellent communication skills and comfortable working with global remote teams.

Preferred Qualifications

• Experience with HL7, FHIR, CCD, or healthcare data interoperability.
• Exposure to dbt, Airflow, Step Functions, or similar orchestration tools.
• Experience in healthcare data modernization or cloud migrations.

Apply Now.