Pharmacy Staff Analyst

Myers and Stauffer; Indianapolis (IN); Hybrid; USD 65,000 - 95,000; Full time

Benefits offered by this job

Health, dental, and vision insurance

401K with company matching

Paid holidays

Tuition reimbursement

Parental leave

Job summary

Myers and Stauffer LC in Indianapolis, IN, is seeking a data analyst focused on pharmacy data to support rate calculations, fiscal modeling and audits for health plans.

You will work with a multidisciplinary team across offices, ensure data quality, and maintain PHI security while delivering clear analyses and dashboards. Bachelor\'s degree required; travel up to 10%; strong Excel/SQL skills; PBM/health plan experience advantageous.

Qualifications

• Bachelor's degree in accounting, finance, health policy, health information, criminal justice or related field.

Responsibilities

• Assist with calculation of rates and fiscal modeling based on pharmacy data.
• Assist on pharmacy related performance audits of health plans.
• Assist on pharmacy benefit manager audits and claims audits.
• Assist in the development of criteria and creation of programs with the program design team used to analyze pharmacy claims data.
• Perform quality reviews of the data output.
• Analyze data output and interpret results.
• Manipulate and format data for ease of use by team members and clients.
• Interface with multi-disciplinary team in multiple office locations.
• Maintain security and confidentiality of all protected health information when analyzing material.
• Maintain thorough electronic documentation.

Skills

Analytical skills

Problem solving

Database knowledge

Excel

Word

Access

Excel macros

SQL Server

Tableau

Power BI

Data visualization

SQL queries

Stored procedures

Pharmacy data analysis

PBM experience

Attention to detail

Time management

Travel up to 10%

Education

Bachelor's degree in accounting/finance/health policy/health information/criminal justice or related field

Tools

Microsoft SQL Server

Tableau

Power BI

Excel macros

Job description

Essential Functions and Primary Duties

• Assist with calculation of rates and fiscal modeling based on pharmacy data
• Assist on pharmacy related performance audits of health plans
• Assist on pharmacy benefit manager audits and claims audits
• Assist in the development of criteria and creation of programs with the program design team used to analyze pharmacy claims data
• Perform quality reviews of the data output
• Analyze data output and interpret results
• Manipulate and format data for ease of use by team members and clients
• Interface with multi-disciplinary team in multiple office locations
• Maintain security and confidentiality of all protected health information when analyzing material
• Maintain thorough electronic documentation

Preferred Qualifications

• Strong analytical and problem solving skills
• Database and spreadsheet application knowledge
• Proficient use of applicable software programs, including Microsoft Office suite (specifically Excel, Word, and Access); familiarity with Excel macros
• Experience working with relational databases (e.g., Microsoft SQL Server) preferred
• Experience working with various data visualization tools such as Tableau, Microsoft Power BI, etc.
• Experience with querying large data sets from a variety of sources
• Experience reading and understanding stored procedures
• Experience loading tables into SQL
• Experience in the analysis of pharmacy or medical claims data
• Experience working for a Prescription Benefit Manager (PBM), health plan, or pharmacy claims processor is beneficial
• Well organized with a high degree of accuracy and attention to detail
• Must be able to manage multiple deadlines and prioritize assignments
• May require up to 10% overnight travel

Minimum Qualifications

Bachelor's degree in accounting, finance, health policy, health information, criminal justice or related field #LI-HW1 #LI-Hybrid

ABOUT US

Myers and Stauffer LC is a certified public accounting and health and human services consulting firm, specializing in audit, accounting, data management and consulting services to government-sponsored health care programs (primarily state Medicaid agencies, and the federal Center for Medicare & Medicaid Services). We have 45+ years of experience assisting our government clients with complex health care reimbursement and provider compliance issues, operate 21 offices and have over 900 associates nationwide. At Myers and Stauffer, you will have a career that is rewarding while also supporting our state and federal government health and human service clients that focus on those in need. We are committed to providing our employees with professional growth and development opportunities, a diverse, dynamic, challenging work environment, and a strong and visionary leadership team. Our firm takes pride in the welcoming and collaborative culture we have throughout our offices. We are always willing to discuss potential flexibility that an employee may need to better suit their work-life wellbeing.

What We Offer

• Health, Dental, and Vision insurance along with other competitive employee benefits for eligible associates
• Vacation time, sick time, and paid holidays
• Paid Parental Leave and available support resources
• 401K with company matching for eligible employees
• Tuition reimbursement, referral bonuses, paid volunteer community service time, mentor program, and a variety of other employee programs and perks
• A combination of technical and leadership development training at each career milestone
• Up to six counseling sessions per year for eligible employees through our Employee Assistance Program