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

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. To apply, submit your resume through this posting. Qualified candidates will be contacted by a ZipStaff recruiter.