Bachelor's degree in Healthcare, Computer Science, Engineering, Mathematics/Statistics, Business, or Applied Science.
3-4 years of experience in a Healthcare or Business environment.
Proficiency in advanced Excel and SQL for report building and tool development.
Experience with Relational Databases, Data Models, and Electronic Medical Record (EMR) report systems like Epic or Cerner.
Understanding of Statistical and Machine Learning concepts.
Familiarity with Business Intelligence tools like Tableau or Power BI.
Strong customer service skills and effective communication proficiency.
Responsibilities
Implement programs to extract, analyze, and report data in a user-friendly format.
Generate reports and offer consultative support to a diverse client base including healthcare leaders.
Develop tools and dashboards to fulfill service line data needs and respond to ad-hoc requests.
Collaborate with Population Health leaders to enhance data solutions and report designs.
Document and analyze detailed requirements, integrating existing solutions or creating new delivery plans.
Engage in revenue cycle analytics to align reports with key organizational initiatives.
Create automated reports and dashboards to support various healthcare data functions.
Benefits
Hybrid work environment, with on-site presence required only one day a week in Troy, MI.
Full Job Description
RESPONSIBILITIES
Implement a comprehensive program to extract data using a computer programming language or collect data, then analyze it and effectively report information from this data to a variety of customers in a user-friendly and actionable way.
Generate reports, develop tools and provide consultative support as needed. Our customers include physicians, physician groups, physician leaders, hospital leaders, the Board of Trustees, system leadership, transformation consulting, clinical/non-clinical services, Markets, Community, Service Lines, Revenue Cycle, Finance, external oversight/regulatory bodies, or any other user needing information.
Create reports, metrics, tools, data models, data-marts, cubes, dashboards, document process flows, fulfil data needs for the Service Lines on priority basis and work on one-time requests from other areas of the system.
Value Based Care IT and Analytics Interface with Population Healthleaders to understand how data solutions can make a positive impact and provide consulting, design reports, build solutions as needed, able to work as a liaison between Analytics and Business leaders.
Gather detailed requirements, document them in our central intake process then identify existing solutions in the Analytics space or if a new solution is needed then create a detailed product delivery plan, navigate tools, pull preliminary data from internal systems plus external systems such as MiHIN, Payor Interfaces, Azara and any others as required.
Per-Member-Per-Month, Case Management, Ambulatory and Utilization Management related work as directed by the leadership.
Revenue Cycle Analytics Working with charge, payments, adjustments, billing and claims data. -Create reports aligned with the yearly Playbook initiatives.
Develop customer requested automated tools, reports, dashboards, data models, data-marts, data analyses for Coding, Billing, Bad Debt, Payments, Revenue, Customer Service data and others as needed.
REQUIREMENTS
Bachelors Degree with a Healthcare, Computer Science, Engineering, Mathematics/Statistics, Business, or an Applied Science major
3-4 years of experience in a Healthcare or Business setting
Expert in the use of advance Excel, SQL, report building, tool development, requirements gathering and technical documentation
Experience in the use and design of Relational Databases, Data Models, Data Visualizations, curated datasets, data cubes or experience in Electronic Medical Record (EMR) report development, functionality of any EMR (Epic, Cerner, McKesson or other widely used EMRs).
Maintain code repositories on SCM system, familiar with merging, pushing, pulling, branching, staging and code commenting or MS TFS
Good understanding of fundamental Computer Programming concepts or Electronic Medical Record systems
Basic understanding of Statistical and Machine Learning concepts
Basic understanding of dimensional models and Data Warehouse or Electronic Medical Record system
Experience in any Business Intelligence tools such as Tableau, Cognos, Looker, Toad, Minitab, Power BI, Qlik, SSRS or any other
Develop multidimensional semantic layer and analytics query objects for end-users
Proven customer service experience with strong active listening skills
Able to present complex information to diverse audiences
Excellent written and verbal communication skills
PREFERRED REQUIREMENTS
Strong knowledge of EPIC Data Structures
WORK ENVIRONMENT
Hybrid position - on site one day a week in Troy, MI
