Data Analyst Support

$75,000 - $75,000/Yr

PharMerica - Louisville, KY

Full-time - Mid Level

Remote - Louisville, KY

Health and Personal Care Retailers

About the position

The Data & Reporting Analyst position at PharMerica is responsible for leveraging data and analytics to support client strategy and partnership department operations. This role facilitates discussions on how to best support and report on various performance metrics of the account management teams. It is a remote position, allowing applicants to reside anywhere within the Continental USA, and operates Monday to Friday from 8 am to 5 pm.

Responsibilities

• Provide key monthly performance metrics on various measures aligned to company priorities.
• Develop monthly processes to create performance reports in a timely manner.
• Coordinate and communicate reporting activities and document all processes.
• Design reports, dashboards, and scorecards using tools such as Microsoft Excel or Power BI.
• Establish KPIs to measure the effectiveness of business decisions.
• Perform data analysis on retention and renewal performance, group purchasing partner pipeline management, and rebate preparation.
• Review strategic account portfolio and identify ways to represent business portfolio and opportunity focus.
• Generate Excel Reports from Microsoft Dynamics CRM to optimize KPI information on Renewal/Retention and Loss Data.
• Prepare AM Team's Quarterly Bonuses Incentive.
• Ensure membership list accuracy and GPO reporting process milestones are achieved quarterly.
• Track overall progress of Strategic Account plan execution for growth.
• Create presentations and reports based on recommendations and findings.
• Maintain department headcount report and roster changes for leadership.
• Communicate directly with Director, Client Strategy and SVP, Client Strategy and Partnerships in report development and data accuracy testing.
• Respond to data requests in a timely and efficient manner.

Requirements

• Bachelor's Degree in Business Administration, Computer Science/CIS, or related fields.
• Experience in data analysis, with education considered as part of the requirement.
• Strong analytical and critical thinking skills.
• Excellent verbal and written communication skills.
• Strong interpersonal skills to work effectively with internal and external customers.
• Demonstrated ability to handle multiple tasks simultaneously and prioritize accordingly.
• Proven ability to work with a high degree of accuracy and attention to detail.
• Proficient in all Microsoft Office products including Excel, Power BI, Access, PowerPoint, and Word.
• Experience working with SAS, COGNOS, SQL, Server Manager, or other database management software is a plus.
• Self-starter with a commitment to continuous process improvements and improved service levels.

Benefits

• Disability insurance
• Dental insurance
• 401(k)
• Tuition reimbursement
• Paid time off
• Vision insurance
• Employee discount
• Opportunities for advancement
• Life insurance