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!

Keenan

Latest Jobs

PBM Data Reporting Analyst