Product Lead - Population Health, Care Management
Posted 1 week ago by ABOTTS Consulting inc
Negotiable
Undetermined
Remote
Remote
Summary: The Product Lead for Population Health and Care Management is responsible for overseeing technology transformation projects within healthcare, focusing on clinical workflows and care management operations. The role requires advanced SQL proficiency and expertise in dimensional modeling, along with experience in data analytics and enterprise data warehousing. Candidates should have a strong background in healthcare and project execution methodologies, particularly agile. This position is remote and emphasizes leadership in managing technology initiatives in the healthcare sector.
Key Responsibilities:
- Oversee technology transformation projects in healthcare.
- Utilize advanced SQL skills for data analysis and reporting.
- Implement dimensional modeling techniques in data management.
- Lead and manage enterprise data warehouse development.
- Apply agile methodologies for project execution.
- Collaborate on clinical workflows and care management operations.
Key Skills:
- Expertise in dimensional modeling.
- Advanced SQL proficiency, including CTEs, subqueries, and joins.
- Experience with data analytics tools such as SQL and Google Cloud Platform.
- Knowledge of healthcare operations, particularly in acute and ambulatory settings.
- Experience with enterprise data warehousing.
- Leadership experience in technology projects.
- Bachelor's degree in Computer Science or Information Technology.
- Familiarity with EHR platforms like Epic or Cerner.
- Understanding of HL7, FHIR, and population health management.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: Other
Title Product Lead - Population Health, Care Management
Location Remote
Important Note:
Prerequisite Check: Dimensional Modeling
- Candidates must have experience with and understanding of dimensional modeling.
Required SQL Proficiency Advanced
Candidates must demonstrate proficiency in the following:
- Common Table Expressions (CTEs): Using the WITH clause to break down a complex query into smaller, readable, and reusable blocks.
- Subqueries: Proficiency in using nested SELECT statements (in the FROM, WHERE, and SELECT clauses) and knowing when to use them versus a JOIN.
- Advanced Joins: Deep understanding of all join types (INNER, LEFT, RIGHT, FULL), and the ability to join multiple tables (5+) correctly.
- Set Operations: Using UNION, UNION ALL, INTERSECT, and EXCEPT to combine results from multiple queries.
- Conditional Logic: Extensive use of the CASE statement for complex data categorization, pivoting, and transforming data based on business rules.
Qualifications and Education:
- Required: Expert in subject matter area in one of the following areas - Clinical Workflows, Care Management Operations in Healthcare Acute and Ambulatory space, Finance
- Experience in Data Analytics using tools such as SQL, Google Cloud Platform. Snowflake etc.
- Experience with building Enterprise Data warehouse
- Lead or Manage technology transformation projects
- Experience with agile methodologies of project execution
- Bachelor's level degree or equivalent foreign degree in Computer Sc or Information Technology
- Preferred: Experience with Epic, Cerner, or other EHR platforms,
- Knowledge of HL7, FHIR, Population Health and Care Management, 1-3 Years healthcare industry experience, and 2+ years people management experience