Data Analyst

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.

- Data Analyst II - with 2–3 years of experience (not entry‑level or intern) - Strong Power BI and operational reporting skills - Experience with clinical program evaluation and outcomes - Background on the payer or provider side, ideally value‑based care - Salary range: $80K–$85K

Why Work at AbsoluteCare?

At AbsoluteCare, we serve the most vulnerable individuals in America. These are our neighbors, people who are at higher risk for disease or who have multiple, complex, chronic illnesses. Often, they deal with an unequal healthcare system and wind up seeking basic care from emergency rooms. We take these patients out of those spaces and turn them into members: people who are entitled to some of the best, most focused care this country has to offer. 

We call this “care beyond medicine.” We have turned the doctor’s office into a comprehensive care center. Here, we surround our members with a core care team of doctors, nurses, social workers, and medical assistants who have the time and skills to get to know our members’ needs. We make the most important services available to our members under one roof. This includes a pharmacy, X-rays, a blood lab, nutrition services, urgent care, and much more.

We don’t stop at our four walls. We engage members in the communities where we all live to find the people who need us most. Through these community care teams, we remove the barriers to healthcare that so many people face daily. And it works. 

Our unique care is guided by our core values of accountability, caring, trust, and teamwork. We call it ACT².

AbsoluteCare, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, age, disability, genetics, protected Veteran status, or any other characteristic protected by law or policy.