PBM Data Reporting Analyst

Overview

Keenan has an exciting career opportunity for a PBM Data Reporting Analyst. The PBM Data Reporting analyst will support the Pharmacy Division with data reports and analytics needed to provide KPS clients consultation on their Pharmacy Benefit program.

Keenan, an Accretive company, is an insurance brokerage and consulting firm meeting the insurance needs of hospitals, public entities and California school districts. Keenan specializes in providing consulting services in the areas of: employee benefits, workers' compensation, loss control, financial, and property & liability.

What You'll Do

• Manage and generate recurring reports for KPS book of business
• Manage and maintain database related tables
• Create custom ad hoc reports utilizing internal and external data
• Create client facing report templates in excel and PowerPoint for department use
• Collaborate with internal and external stakeholders to ensure data and reporting is accurate and timely
• Analyze and present book of business data to provide management with actionable insights
• Audit internal and external data, client reports and financials
• Work with and integrate data set from multiple source
• Maintain business and desk level data and reporting procedures
• Collaborate with database team to conduct user acceptance testing
• Maintain a working knowledge of Medispan and NCPDP data sets
• Other duties as assigned

What You'll Need

• Three (3) years experience in data management and reporting
• Five (5) years experience in the Pharmacy Benefit Management or healthcare industry preferred
• Intermediate Excel Skills: ability to do pivot tables, excel formulas, charts and graphs
• Strong analytical and problem solving skills
• Excellent communication skills
• Detail oriented and results driven
• Ability to project manage multiple priorities and deliver timely results
• Build relationships and create a sense of trust and reliability with internal and external customers
• Experience in Microsoft Outlook, Excel, PowerPoint, and Word.

What's in it For You?

To help you make the best decision for your personal growth, it’s important to us to share a glimpse of what we offer our top asset, our people:

• Competitive base salary
• Generous 30 Days Comprehensive Paid Time Off Package inclusive of Paid Time Off, 10 Company Holidays, 2 Floating Holidays, 5 Sick Days, and 2 Volunteer Days
• Health benefit options with you in mind; 5 affordable medical plan options with rates based on your salary, company paid HSA contribution with eligible HSA plan selection, 2 dental plan options offering orthodontia coverage and 3 cleanings per year, and 2 vision plan options
• Company match 401(k) plan – 50% up to 6%!
• Support of your fitness wellness goals! We offer up to 75% off at over 11,000 gyms and fitness centers
• Opportunity to prioritize your mental health with 24/7 access to licensed therapists
• Pet benefits & discounts
• Access to our Employee-led Resource Groups (ERGs) that lend a voice to the variety of demographics represented throughout AssuredPartners

Compensation:

The target salary range for this position is $80,000.00 to $90,000.00 (US Dollar) annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant’s geographic location. Remote work environment flexibility.

Grow, with us

Accretive is a collection of elite specialty and wholesale agencies supported by experienced industry leaders. Our expertise is broad, and our innovative culture runs deep. We value relationships above all else and consistently deliver best in class customized solutions and service you can trust.

Accretive is passionate about fueling our clients’ innovation and growth. That makes us the perfect place for creative, dynamic people who want to grow their career while helping businesses, families and people thrive. We are proud to be one of the largest brokers in the country, but we’re even prouder of the honest, caring relationships that our employees build with our clients every day.

Working with us will give you the opportunity to do work that matters while you learn with us, advance with us, and most importantly, grow with us. Accretive is committed to embracing diversity, equity and inclusion to create a workplace that welcomes and thrives on the unique experiences, perspectives and contributions of all team members. Accretive is bringing the best people and most diverse talent forward to drive growth, innovate and think bigger!