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 pi