Remote Data Analyst: ETL, HL7, FHIR & SQL Expert

ZipStaff; United States; Remote; USD 83,000 - 131,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401(k) + matching

Paid time off

Referral Program

Job summary

ZipStaff is seeking a hands-on Data Analyst/Engineer to lead ETL design and implementation for a healthcare enterprise data warehouse. You will build and optimize ETL pipelines using Azure Data Factory, SSIS, Informatica, SQL Server, Snowflake, and Databricks, handling HL7 and FHIR files.

Responsibilities include translating business requirements into scalable data solutions, developing stored procedures, and ensuring data governance and analytics support across the organization.

Qualifications

• 8+ years of data engineering experience focusing on data warehousing.
• 5+ years with Azure Data Factory (ADF) and Databricks.
• 5+ years ETL development using Informatica PowerCenter, SSIS, ADF or similar tools.
• 5+ years relational databases (Oracle, Snowflake, SQL Server).
• 5+ years creating stored procedures (Oracle PL/SQL, T-SQL, Snowflake SQL).
• 3+ years Python scripting.
• 3+ years Azure DevOps, GitHub, SVN or similar.
• 2+ years processing structured and unstructured data.
• HL7 and FHIR standards processing.
• 3+ years detailing ETL specifications.

Responsibilities

• Design, develop, and optimize ETL pipelines with Informatica SSIS ADF or similar tools.
• Build and maintain data pipelines in Azure Data Factory and Databricks.
• Develop stored procedures in Oracle PL/SQL, T-SQL or Snowflake SQL.
• Process HL7 and FHIR data formats.
• Support data warehouse initiatives, governance, analytics and modeling.
• Troubleshoot and optimize data pipelines.”],
• CoT_job_summary_short2_grade_uppercase_only_for_consistency? : null
• CoT_job_summary_short
• CoT_job_summary_short_firstline? : null
• CoT_job_summary_short_secondline? : null
• CoT_job_summary_short_dummy_note? : null
• CoT_job_summary_short_note? : null
• CoT_job_summary_short_Aux? : null
• CoT_job_summary_short_placeholder? : null
• CoT_job_summary_short_extras? : null
• CoT_job_summary_short_text? : null
• CoT_job_summary_short_brief? : null
• CoT_job_summary_short? : null
• CoT_job_summary_short_line? : null
• CoT_job_summary_short_final? : null
• CoT_job_summary_short_final_text? : null
• CoT_job_summary_short_dummy? : null
• CoT_job_summary_short_value? : null
• CoT_job_summary_short_entries? : null
• CoT_job_summary_short_targets? : null
• CoT_job_summary_short_set? : null
• CoT_job_summary_short_caption? : null
• CoT_job_summary_short_header? : null
• CoT_job_summary_short_block? : null
• CoT_job_summary_short_meta? : null
• CoT_job_summary_short_content? : null
• CoT_job_summary_short_tag? : null
• CoT_job_summary_short_class? : null
• CoT_job_summary_short_style? : null
• CoT_job_summary_short_html? : null
• CoT_job_summary_short_dummy2? : null
• CoT_job_summary_short_observations? : null
• CoT_job_summary_short_guide? : null
• CoT_job_summary_short_text_only? : null
• CoT_job_summary_short_source? : null
• CoT_job_summary_short_subline? : null
• CoT_job_summary_short_subtext? : null
• CoT_job_summary_short_source2? : null
• CoT_job_summary_short_source3? : null
• CoT_job_summary_short_source4? : null
• CoT_job_summary_short_source5? : null

Skills

Data warehousing

Azure Data Factory

Databricks

Informatica PowerCenter

SSIS

SQL & PL/SQL

Python

Azure DevOps

HL7 & FHIR

Snowflake SQL

REST/API

Education

Bachelor's degree in IT/CS/Math/Stats/Analytics/Business

Tools

Informatica PowerCenter

SSIS

Azure Data Factory

Databricks

SQL Server

Oracle

Snowflake

Job description

ZipStaff is seeking a hands-on Data Analyst/Engineer to lead ETL design and implementation for a healthcare enterprise data warehouse. You will build and optimize ETL pipelines using Azure Data Factory, SSIS, Informatica, SQL Server, Snowflake, and Databricks, handling HL7 and FHIR files.

Responsibilities include translating business requirements into scalable data solutions, developing stored procedures, and ensuring data governance and analytics support across the organization.