Job Summary

This role will support the Medical Economics team to design and develop reports and analyze health care utilization, operational and financial data to measure and drive patient and business outcomes.  The Medical Economics team works in close collaboration with Clinical, Pharmacy, and Executive leadership to design, develop reports and conduct analyses using health care utilization, operational, clinical, and financial data from various health care information sources to measure and drive member and care model outcomes.

The Data Analyst will review, interpret, and analyze clinical and operational data from the Electronic Health Record (eClinicalWorks), pharmacy point of sale system, population health management systems, and health plan payer data and deliver reports that respond to critical business needs.   This role includes Level I/II.

Duties and Responsibilities

• Analyze and regularly report upon clinical and operational care model data from EHR (eClinicalWorks), pharmacy point of sale system (RX30), population health management systems, medical and pharmacy claims provided by health plan payers, and other internal and third-party data streams as necessary.
• Work collaboratively with leadership and stakeholders across the Integrated Clinical Team, Pharmacy, Finance, Medical Center Operations, Business Development, and Executive leadership to define, create, document and implement ad-hoc reports/analytics that support the AbsoluteCare clinical care model evolution and health plan partnerships.
• Be able to design with key performance metrics, actionability, clinicians, and patients in mind; utilize data to not only identify potential impact, but also test and monitor performance of clinical metrics and patient outcomes.
• Automate manual reporting and develop novel reporting using the Microsoft BI stack and other reporting tools.
• Communicate analyses, results, and reports in a simple and clear fashion to all levels and functional areas of the organization.
• Conduct analyses using tools such as SQL, Excel, and Power BI
• Conduct extensive data mining and analyses to identify trends, opportunities, and best practices.
• Organize, clarify, and translate business processes into reporting requirements from a diverse set of end users (e.g. executives, clinicians),
• Interpret medical data fields to understand the population’s compliance with standard quality measures (e.g., HEDIS, NCQA).
• Promote a culture of high-quality reporting and analytics by acting as a peer reviewer for team members.
• Relate disparate data sets to extract actionable insights.
• Support business needs through the development of ad-hoc and standardized reports as requested by the executive leadership team, as well as internal and external customers.
• Troubleshoot and align the reporting needs of end users to available data sets.
• Maintain the security and privacy of all information that is owned by AbsoluteCare or maintained on behalf of the company’s patients, employees, and business partners.

Minimum Qualifications

• Bachelor’s degree in business, information technology, computer science/data science/data analytics, statistics, mathematics, actuarial sciences, health sciences, or related field or equivalent work experience required.
• 0-2 years of health care data analysis, and reporting experience required, Clinical information systems background with EHR experience (eClinicalWorks), Pharmacy point of sale systems, population health management systems and/or health plan/payer experience strongly preferred.
• Experience with the Microsoft BI stack, including SSMS, SSRS, SSIS, and Power BI, Power Query, or other Business Intelligence Tools strongly preferred.
• Advanced proficiency with Microsoft Excel required.
• Experience with querying relational databases and data warehouses using SQL or a similar coding language required.
• Experience with R, Python, machine learning, and artificial intelligence library a plus.
• Ability to work independently with limited direction and/or guidance.
• Capable of balancing numerous and competing priorities.
• Excellent communication skills.
• Insatiable curiosity.
• Highly organized with strong documentation skills.
• Passion for data and the act of transforming data to achieve results.
• Unafraid to ask questions or for help when necessary.

Working conditions

This job operates in a professional office environment.  This role routinely uses general office equipment.

Physical requirements

• Ability to communicate clearly and exchange accurate information constantly.
• Ability to remain stationary for long periods of time.
• Constantly operates computer, keyboard, copy and fax machine, phone, and other general office equipment.

Direct reports

None.