Data Modeler with Health Care Domain

Data Modeler with Health Care Domain 

100% Remote 

Description
Our client is currently seeking a hands-on Senior Health Data modeler to support our EDW within the Enterprise Data Warehouse and Analytics group. The Data Modeler will work with large healthcare datasets and translate the 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 EDW, and 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.
Qualifications
Education/Qualifications
• BS or MS in Computer Science/Business Information Systems/Engineering or related field
• 10 or more years of IT experience
Required skills
• Strong problem solving, influencing, communication, and presentation skills, self-starter.
• Expertise in Data Architecture, Data Strategy and Roadmap for large and complex health entities and systems, with implementation experience of large-scale, end-to-end Data Management & Analytics solutions for more than one large client.
• Strong knowledge of regulatory security requirements regarding HIPAA, 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.
• Hands-on experience with ETL tools (e.g., Informatica, Azure Data Factory)
• Hands-on experience with BI tools and reporting software.
• Demonstrated ability to work in a fast paced and changing environment with short deadlines, interruptions, and multiple tasks/projects occurring simultaneously.
• Must be able to work independently and have skills in planning, strategy, estimation, and scheduling.
• Experience with scripting language used for analytics such as Python or R
• Experience applying AI/GenAI capabilities to data modeling, metadata management, data profiling, data quality analysis, documentation automation, and analytics enablement, with the ability to evaluate appropriate use cases while maintaining privacy, security, and regulatory compliance.
Preferred skills
• 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 Erwin data modeler
• 2 years experience with PowerBI