Business Intelligence Analyst

Key Skills

Python Programming, SQL, Cloud computing

Job Description

The state of healthcare is complex, but our shared purpose isn’t: Help people get the medicine they need to live healthier lives. CoverMyMeds solves medication access challenges for patients throughout every step of their journey through a unified brand that now encompasses RelayHealth, RxCrossroads by McKesson, McKesson Prescription Automation and CoverMyMeds.

Our combined experience spans nearly 90 years and together, we’re applying our expertise to solve some of the biggest problems in healthcare. We accelerate innovative solutions for problems like medication affordability and adherence in way that everyone wins — from providers to pharmacies, payers to biopharma and, especially, patients. By combining automation and expert intervention, the company provides prior authorization, prescription decision support, specialty patient support, core adjudication network, patient assistance programs, clinical and behavioral adherence and patient empowerment solutions.

We’re proud to be an integral part of McKesson Corporation and embody the shared values and leadership behaviors of the greater organization. We understand the importance of a system that works together. Your expertise, drive and passion can help us carry out our mission to improve lives and advance healthcare.

This position will collect, manipulate and analyze business data from a variety of clients and sources. Preparing reports, in the form of visualizations such as graphs, charts and dashboards, detailing the significant results they deduced.

A primary role will be to guard and protect the organization's data, making sure that the data repositories produce consistent, reusable data.

Using standard formulas and methods, perform basic and advanced statistical evaluations and analysis of data in all stages including collection, analysis and reporting.

You will be required to work closely with both internal teams and external customers to understand, define, and replicate best practices related to data quality and integrity programs.

Responsibilities will include interpreting data, creating ad hoc reports, modifying and updating standard reports when applicable, perform statistical analysis, analyzing data to forecast trends and conduct predictability outcomes.

Key Responsibilities

Uses Structured Query Language (SQL) to gather and assess data on a daily basis from the reporting database, transactional database, operational data store, and external systems to assist internal and external leadership in decision making. Documents program data requests, results, SQL code, and logs time in the JIRA tracking system.

Authenticates and interprets data based on results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining, using approved analytical models and ensuring adequate QA of output and results, and that findings, results, methodology, SQL code, and time spent on requests are logged in the JIRA tracking system.

Communicates and disseminates the results of information gathering using BI software, SSRS, and/or Excel to name a few, as per the agreed timing, whether this is daily, weekly, monthly, yearly, or aggregated level data.

Continually assesses data quality throughout the database and coordinates with IT in the correction of source data or creation of translation sources, where applicable. Where appropriate update the related reporting BRD and ensure that the new BRD is stored in the shared BRD folder.

On at least a monthly basis researches and identifies best practices for business data analysis via published literature, formalized training and professional development efforts and ensures that this is distributed to the larger team and key stakeholders.

Using specific tool capabilities such as SAP Business Objects, Microsoft PowerBI, Tableau etc., analyze, visualize, and where appropriate publish to internal and external clients the data findings. This includes updating reporting BRD’s if applicable.

Monitor the programs at least monthly to support continuous quality improvement efforts using performance metrics development and monitoring, and effectively communicate this to stakeholders via strategic business reviews, scheduled meetings, or where required appropriate escalation.

Minimum Job Qualifications (Knowledge, Skills, & Abilities):

Typically requires 4+ years of professional experience in addition to data analytics experience.

Education/Training –

4 year degree or equivalent experience. (Computer science, engineering, analytics, finance, or business)

Business Experience –

• 2+ years of experience in data analytics.
• Advanced skills with SQL, Excel, data visualization and analytics tools. 
• Excellent communication and presentation skills in presenting analytic results and findings at all levels internally and externally.
• Detailed understanding and experience with process documentation and improvement for gaining operational efficiency.
• Ability to see the business picture from the analytics data

Specialized Knowledge/Skills –

• SQL, Python, Tableau, SAS, R, Power BI, SPSS, Stata, BOBJ etc.,
• Healthcare or pharmaceutical industry, highly preferred

Working Conditions:

Office

Physical Requirements (Lifting, standing, etc.) –

Possible long periods of sitting and/or keyboard work. General office demands.

Schedule

Mon - Fri 8am-5pm, but flexible as team members are in different time zones

Location

Remote but MUST be local to one of the following HUB locations:

• Scottsdale, AZ
• Columbus, OH
• Dallas, TX
• Cary, NC

Career Level – IC – Professional – P3