Senior Healthcare Data Architect / Lead Data Modeler (Healthcare, SQL)

Principal Data Analyst

Work location: MN101

Work location type: 100% Telecommute

Work hours: 9am -5pm

Required skills/attributes:

• Strong problem solving, influencing, communication, and presentation skills, self-starter.
• Expertise in Data Modeling, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client.
• Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards.
• Strong Healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets.
• Expertise with normalized OLTP, OLAP, MDM and Dimensional modeling techniques, Star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification.
• Expert level SQL skills with direct experience writing complex analytic queries, stored procedures, DDL, DML and DCL. Thorough knowledge of query optimization techniques with the ability to write code to ANSI standards and inspect code written by other developers.
• Expertise in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival and Data Migration strategies using appropriate tools.

Preferred skills/attributes:

• Experience with Microsoft Azure cloud infrastructure and services (Azure Data Lake Storage, Azure Data Factory, Purview, Azure Maps, etc.)
• Experience with Snowflake DBMS
• Experience with PowerBI or Tableau

This position does not require a professional license or certification.

Summary of the project/initiative:

Optum is currently seeking a hands-on Senior Health Data Modeler to support our CT EDW within the Enterprise Datawarehouse and Analytics group. The Data Modeler will work with large healthcare datasets and will translate client's business requirements into enterprise systems, applications, or process designs for large complex health data solutions. The role will drive and support initiatives for the CT EDW as well as participate in the wider EDW group's areas of data usage and governance, information management, privacy and security, SOA, data analytics and visualization and information modeling.

Ideal candidate background:

Data modeler with Medicaid/Healthcare experience

Top 3 required skills:

• Strong problem solving, influencing, communication, and presentation skills, self-starter.
• Expertise in Data Modeling, Data Strategy and Roadmap for large and complex health entity and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client.
• Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards.

Experience that will set candidates apart:

Data modeler with Medicaid/Healthcare experience

Team structure:

Data Manager, Data Modeler, Data Integration Lead, Data Engineers

Interview process:

a. How many rounds? 3

b. Video vs. phone? Video

c. How technical will the interviews be? Very