Senior Healthcare Data Architect / Lead Data Modeler (Healthcare, SQL)
About The Position
Optum is seeking a hands-on Senior Health Data Modeler to support its CT EDW within the Enterprise Datawarehouse and Analytics group. The role works with large healthcare datasets and translates client business requirements into enterprise systems, applications, or process designs for large, complex health data solutions. It will drive and support CT EDW initiatives and participate in wider EDW group work involving data usage and governance, information management, privacy and security, SOA, data analytics and visualization, and information modeling. The ideal candidate has Medicaid and healthcare data-modeling experience.
Requirements
- Strong problem-solving, influencing, communication, and presentation skills; must be a self-starter.
- Expertise in data modeling, data strategy, and roadmaps for large and complex healthcare entities and systems.
- Experience implementing large-scale end-to-end data management and analytics solutions for more than one large client.
- Strong knowledge of regulatory security requirements for HIPAA, PHI, PII, and other healthcare data security standards.
- Strong healthcare domain knowledge, including Medicaid, Medicare, and commercial healthcare datasets.
- Expertise in normalized OLTP, OLAP, MDM, and dimensional modeling techniques, including star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification.
- Expert-level SQL skills and direct experience writing complex analytic queries, stored procedures, DDL, DML, and DCL.
- Thorough knowledge of query optimization, ability to write code to ANSI standards, and ability to 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.
- Five or more years of experience with Erwin Data Modeler.
Nice To Haves
- Experience with Microsoft Azure cloud infrastructure and services, such as Azure Data Lake Storage, Azure Data Factory, Purview, and Azure Maps.
- Experience with Snowflake DBMS.
- Experience with Power BI or Tableau.
- Medicaid and healthcare data-modeling experience.
Responsibilities
- Translate client business requirements into enterprise systems, applications, or process designs for large, complex health data solutions.
- Drive and support initiatives for the CT EDW.
- Participate in wider EDW group work involving data usage and governance, information management, privacy and security, SOA, data analytics and visualization, and information modeling.
- Develop data strategies and roadmaps and support large-scale end-to-end data management and analytics solutions.
- Apply data modeling, data quality, data profiling, data governance, data security, metadata management, MDM, data archival, and data migration strategies.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
