Sr. Data Architect

WELLBE INTRODUCTION

The WellBe care model is a Physician Led Advanced Practice clinician driven geriatric care (care of older adults) team focused on the care of the frail, poly-chronic, elderly Medicare Advantage patients.  This population is typically underserved and very challenged with access to care.   To address these problems, we have elected to bring the care to the patient, instead of trying to bring the patient to the care. Care is provided throughout the entire continuum of care – from chronic care and urgent care in the home, to hospital, to skilled nursing facility, to assisted living, to palliative care, to end of life care.  WellBe's physician/advanced practicing clinician led geriatric care teams’ partner with the patient’s primary care physician to provide concierge level geriatric medical care and social support in the home as well as delivering and coordinating across the entire care continuum.

GENERAL SUMMARY

Wellbe is seeking a skilled and Senior Healthcare Data Warehouse Architect to join our team. In the role, you will be responsible for designing, implementing, and maintaining a robust healthcare data warehouse that serves as the foundation for actuarial services, data analytics, reporting, and insights. As a key member of our team, you will play a critical role in shaping our data architecture and ensuring that it supports our healthcare data needs effectively. The role is responsible for identifying WellBe’s internal and external data sources, collaborating with department heads to determine their data storage and organizational needs and using the information to create and maintain data infrastructure for company employees. The ideal candidate is an experienced data engineer and data wrangler who enjoys optimizing data systems and building them from the ground up. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. Experience in analytics and statistics is a major bonus.   Experience with claims data specification is a must.

SKILLS & COMPETENCIES

• Develop and implement a healthcare data warehouse architecture that meets the organization's data storage and reporting requirements while ensuring data quality and integrity.
• Create and maintain data models that facilitate the storage and retrieval of healthcare data, ensuring it is structured for efficient analytics.
• Oversee the integration of data from various sources, including electronic health records (EHRs), claims data, CMS datasets, and more into the data warehouse.
• Implement Extract, Transform, Load (ETL) processes to cleanse, transform, and load data into the data warehouse efficiently.
• Establish and maintain rigorous data security protocols and encryption standards to protect sensitive healthcare information in compliance with regulations like HIPAA.
• Continuously monitor and optimize the data warehouse's performance, ensuring fast query response times and scalability.
• Work closely with data analysts, data scientists, actuaries and other stakeholders to understand their data needs and design the data warehouse to meet those requirements effectively.
• Create and maintain documentation for the data warehouse architecture, data flows, and transformation processes.
• Collaborate with and manage third-party vendors to acquire and maintain data warehousing tools and solutions.
• Stay updated on healthcare data regulations and ensure that the data warehouse complies with all relevant industry standards.

QUALIFICATIONS

Educational/Experience Requirements:

• Bachelor's or advanced degree in Computer Science, Information Management, Data Science, or a related field. Master's degree preferred.
• 7+ years of experience in data management required.
• 5+ years of experience in Data Architect role required.
• 5+ years of experience in health care data analysis experience required.
• Subject matter expertise with healthcare datasets (Claims, MMR, membership), standards and regulations, such as HIPAA required.
• Strong leadership and team management skills, with the ability to motivate and develop team members.
• Snowflake and DBT experience preferred.
• Proficiency in using data management tools and technologies such as data cataloging tools, ETL tools, Data modeling and data lineage tools.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively across departments.

Required Skills and Abilities:

• Proficiency in data modeling techniques, including Entity-Relationship Diagrams (ERD) and Dimensional Data Modeling, to design data structures that support business needs.
• Expertise in database management systems (DBMS) such as SQL Server, Oracle, MySQL, PostgreSQL, NoSQL databases, and cloud-based solutions like Snowflake and Azure SQL Database.
• Knowledge of ETL processes and tools to extract data from source systems, transform it for analysis, and load it into data repositories.
• Ability to integrate data from various sources, both structured and unstructured, to create a unified and accessible data ecosystem.
• Experience in designing and maintaining data warehouses, including knowledge of data warehouse architecture and methodologies.
• Understanding of healthcare systems, including insurance plans, Medicare, Medicaid, and commercial payers.
• Proficiency in processing various types of healthcare claims, such as medical, dental, vision, and pharmacy claims.
• Knowledge of the claims adjudication process and claim submission requirements.
• Exceptional attention to detail to accurately review and validate claims data, ensuring they meet compliance and regulatory standards.
• Ability to interpret complex claims data and extract meaningful insights.
• Foster a data-driven culture by promoting the use of data insights to drive business decisions and innovation.
• Lead and mentor a team of data professionals, providing guidance, performance evaluations, and professional development opportunities.
• Foster a collaborative and inclusive work environment that encourages knowledge-sharing and innovation.
• Fluency in SQL or other similar programming languages. Some development experience in at least one scripting language (Python, R, etc.) is a plus.

Supervisory Responsibility: This position will have supervisory responsibilities.

Travel requirements: Travel may be required up to 15% locally or nationally.

The preceding functions may not be comprehensive in scope regarding work performed by an employee assigned to this position classification.  Management reserves the right to add, modify, change, or rescind the work assignments of this position.  Management also reserves the right to make reasonable accommodations so that a qualified employee(s) can perform the essential functions of this role.