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

ZipStaff Inc.; San Antonio (TX); Remote; USD 83,000 - 131,000; Part time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401(k) + matching

Job summary

ZipStaff is seeking a senior Data Analyst to design and optimize ETL pipelines for a healthcare data warehouse environment. The role involves working with large healthcare datasets, translating requirements into scalable data solutions, and implementing data transformations using Azure Data Factory, SSIS, Informatica, SQL Server, Snowflake, and Databricks.

The ideal candidate will have 8+ years in data engineering, strong PL/SQL/T-SQL skills, HL7/FHIR experience, and a track record of delivering

Qualifications

• 8+ years of data engineering with a focus on data warehousing.
• 5+ years in Azure Data Factory (ADF) and Databricks.
• 5+ years ETL development with Informatica PowerCenter, SSIS, or similar.
• 5+ years with relational databases such as Oracle, Snowflake, or SQL Server.
• 5+ years creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL.
• 3+ years Python scripting.
• 3+ years Azure DevOps, GitHub, SVN, or similar source control.
• 2+ years processing structured and unstructured data.
• Experience with HL7 and FHIR standards and processing files.
• 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.

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 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.

Skills

Azure Data Factory

Databricks

Informatica PowerCenter

SSIS

SQL Server

PL/SQL

Python

HL7/FHIR

Azure DevOps

Git/GitHub

Data warehousing

Data modeling

Education

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

Tools

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