Data Analyst (ETL, SQL Server, SSIS, ADF, T-SQL, HL7, FHIR)

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

Title: Data Analyst (ETL, SQL Server, SSIS, ADF, T‑SQL, HL7, FHIR)

Location: San Antonio, TX (Remote)

Type: Contract, 7 months

Overview

ZipStaff is hiring a Data Analyst (ETL, SQL Server, SSIS, ADF, T‑SQL, HL7, FHIR) for our client, a large healthcare organization. This 7‑month contract is a 100% remote role for a hands‑on senior data engineer supporting a healthcare enterprise data warehouse and analytics group. You will work with large healthcare datasets, translate business requirements into enterprise data solutions, and build and optimize ETL pipelines using tools such as Azure Data Factory, SSIS, Informatica, SQL Server, Snowflake, and Databricks, including HL7 and FHIR file processing.

Responsibilities

• Work with large healthcare datasets and translate business requirements into enterprise systems, applications, or process designs for complex health data solutions.
• Design, develop, and optimize ETL pipelines using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools.
• Build and maintain data pipelines in Azure Data Factory (ADF) and Databricks, and develop stored procedures in Oracle PL/SQL, SQL Server T‑SQL, or Snowflake SQL.
• Process structured and unstructured data, including files in HL7 and FHIR formats.
• Analyze project requirements and develop detailed specifications for ETL requirements.
• Support enterprise data warehouse initiatives, including data usage and governance, information management, privacy and security, data analytics and visualization, and information modeling.
• Troubleshoot and optimize data pipelines, and adapt to evolving technologies and changing business requirements.

Required Qualifications

• 8+ years of data engineering experience with a focus on data warehousing.
• 5+ years of experience working with Azure Data Factory (ADF) and Databricks.
• 5+ years developing ETL using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools.
• 5+ years of experience with relational databases such as Oracle, Snowflake, or SQL Server.
• 5+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T‑SQL, or Snowflake SQL.
• 3+ years of experience with Python scripting.
• 3+ years of experience with Azure DevOps, GitHub, SVN, or similar source control systems.
• 2+ years of experience processing structured and unstructured data.
• Experience with HL7 and FHIR standards, and processing files in these formats.
• 3+ years analyzing project requirements and developing detailed specifications for ETL requirements.
• Excellent problem-solving and analytical skills, with the ability to troubleshoot and optimize data pipelines.
• Bachelor's or advanced degree in Information Technology, Computer Science, Mathematics, Statistics, Analytics, Business, or a related field.

Preferred Qualifications

• 3+ years of batch or PowerShell scripting.
• 3+ years of data modeling experience in a data warehouse environment.
• Experience or familiarity with Spark and Azure Data Fabric.
• Experience designing and building APIs in Snowflake and ADF (for example, REST or RPC).
• Experience with state Medicaid, Medicare, or healthcare applications.
• Azure certifications related to data engineering or data analytics.

Benefits

• Health Insurance
• Dental Insurance
• Vision Insurance
• 401(k) + matching
• Paid time off
• Referral Program

About ZipStaff

ZipStaff connects skilled technology professionals with leading organizations across the United States, matching top talent with impactful contract and full-time opportunities.