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

Codetech • Eden Prairie, MN

5h • Remote

About The Position

Optum is seeking a hands-on Senior Data Engineer to support the HI EDW within its Enterprise Datawarehouse and Analytics group. The role works with large healthcare datasets and translates client business requirements into enterprise systems, applications, and process designs for complex health data solutions. It supports HI EDW initiatives and participates in broader EDW work involving data usage and governance, information management, privacy and security, service-oriented architecture (SOA), data analytics and visualization, and information modeling.

The position is 100% telecommute, with stated work hours of 9 a.m. to 5 p.m. The listed work location is MN101.

Requirements

• 8+ years of data engineering experience focused on data warehousing.
• 5+ years of experience creating and 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 using 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, including the ability to troubleshoot and optimize data pipelines.
• Ability to adapt to evolving technologies and changing business requirements.
• Bachelor’s or advanced degree in a related field such as Information Technology, Computer Science, Mathematics, Statistics, Analytics, or Business.
• No professional license or certification is required.

Nice To Haves

• 3+ years of batch or PowerShell scripting experience.
• 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, such as REST or RPC.
• Experience with State Medicaid, Medicare, or healthcare applications.
• Azure certifications related to data engineering or data analytics.

Responsibilities

• Support HI EDW initiatives within the Enterprise Datawarehouse and Analytics group.
• Work with large healthcare datasets.
• Translate client business requirements into enterprise systems, applications, or process designs for complex health data solutions.
• Participate in wider EDW efforts related to data usage and governance, information management, privacy and security, SOA, data analytics and visualization, and information modeling.
• Analyze project requirements and develop detailed specifications for ETL requirements.
• Troubleshoot and optimize data pipelines.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior