Sr Data Analyst ( Azure Data Factory) Job at Expert Technology Services, Eden Prairie, MN

Q0J3aWpHVnUvVnJ5YmR6ZzkyN2Z2Z2lDSlE9PQ==
  • Expert Technology Services
  • Eden Prairie, MN

Job Description

Job Summary (List Format):


- Serve as a Senior Data Engineer supporting the CT Enterprise Data Warehouse (EDW) within the Enterprise Datawarehouse and Analytics group at Optum.
- Work hands-on with large healthcare data sets, primarily Medicaid, focusing on translating complex business requirements into robust enterprise data solutions.
- Design, develop, and optimize data pipelines, ETL processes, and data flows using Azure Data Factory (ADF), Databricks, Informatica PowerCenter, SSIS, and similar tools.
- Develop, maintain, and optimize data warehouses using relational databases such as Oracle, Snowflake, and SQL Server.
- Create and maintain stored procedures (Oracle PL/SQL, SQL Server T-SQL, Snowflake SQL) to support business and data processing requirements.
- Utilize Python scripting for data processing, automation, and workflow integration.
- Collaborate with teams using source control tools such as Azure DevOps, GitHub, or SVN.
- Process both structured and unstructured data, including healthcare data formats such as HL7 and FHIR.
- Analyze complex project requirements, develop detailed ETL specifications, and ensure alignment with business and technical needs.
- Participate in data governance, privacy, security, analytics, visualization, and information modeling initiatives.
- Troubleshoot, optimize, and improve data pipelines and workflows for performance and reliability.
- Stay current with evolving technologies and adapt solutions to meet changing business requirements.
- Report to and work collaboratively within a team that includes a Data Manager, Data Modeller, Data Engineering Lead, Data Engineers, Business Analyst, QA Testers, and DBA.
- No professional license or certification required, though Azure certifications are preferred.
- The ideal candidate will have a strong background in healthcare data, specifically Medicaid, and expertise in Microsoft Azure, Snowflake, and Azure Data Factory.
- The interview process involves three rounds, with a technical focus, conducted via video.



Top Required Skills/Experience (years indicated):
1. 8+ years Data Engineering (Data Warehousing focus)
2. 5+ years Azure Data Factory (ADF) & Databricks
3. 5+ years ETL development with Informatica PowerCenter, SSIS, or similar
4. 5+ years with relational databases (Oracle, Snowflake, SQL Server)
5. 5+ years creating stored procedures (PL/SQL, T-SQL, Snowflake SQL)
6. 3+ years Python scripting
7. 3+ years source control (Azure DevOps, GitHub, SVN)
8. 2+ years processing structured & unstructured data
9. Experience with HL7 & FHIR healthcare data standards
10. 3+ years requirements analysis and ETL specifications



Preferred/Bonus Skills:
- Batch or PowerShell scripting (3+ years)
- Data modeling in data warehouse environments (3+ years)
- Experience with Spark and Azure Data Fabric
- API design/building in Snowflake and ADF (REST, RPC)
- Experience with Medicaid/Medicare/Healthcare applications
- Azure data engineering/analytics certifications



Education:
- Bachelor's or Advanced Degree in Information Technology/Computer Science, Mathematics/Statistics, Analytics, or Business



Other Details:
- Contract-to-hire; candidates needing sponsorship can be considered.
- Background check and drug screen not required.

Job Tags

Contract work

Similar Jobs

Dynamics ATS

Mechanical Engineer Job at Dynamics ATS

 ...engineering or R&D. ~ Background in water treatment, water technologies, or electrochemistry. ~ Experience with electro-membrane separation technologies used in water treatment applications. ~ Experience with electrochemical technologies for the removal of specific... 

Umergence Holdings LLC

Umergence Crowd Capital seeking Board Members Job at Umergence Holdings LLC

Job DescriptionUmergence Crowd Capital Corp is currently seeking executive board member appointments with backgrounds in:~Private...  ...Development and Managerial Assistance~Seed and Early Stage Venture Capital~Setting Strategy and Policy for Closed-End fund~... 

Catch Vibe Voice

Public Relations Specialist Job at Catch Vibe Voice

 ...to excellence. Job Description Catch Vibe Voice is seeking a confident, creative, and highly organized Public Relations Specialist to join our team in Cincinnati. In this role, you will help shape and maintain the company's public image, develop strategic... 

Confidential

Design Manager Job at Confidential

 ...abstract ideas into realities that transform the world for good. Your impact The Design Manager establishes and monitors procedures for architectural & engineering review activities to ensure they are done according to best... 

Select Medical

Wound Care Nurse (RN) Job at Select Medical

 ...Name: Cleveland Clinic Inpatient Rehabiliation Hospital Joint venture/Partnership/Affiliation with Select Medical Position: Wound Care Nurse (Registered Nurse) Location: Cleveland, OH Schedule: PRN Compensation: $48 / Hour Our inpatient rehabilitation hospital is...