Pharmacy Staff Analyst

Myers & Stauffer; Indianapolis (IN); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Health, Dental, and Vision insurance

Vacation and paid holidays

401K with company matching

Tuition reimbursement

Job summary

Myers and Stauffer LC is seeking a Pharmacy Analyst in Indianapolis to analyze pharmacy claims and price data, build fiscal models, and prepare datasets for clients. You will work with pharmacists, programmers and analysts to create programs that extract data and ensure accuracy.

The role emphasizes strong analytical skills, SQL Server experience and data visualization with Tableau/Power BI. Travel up to 10% may be required, with a collaborative, detail‑driven culture.

Qualifications

• Strong analytical and problem solving skills.
• Database and spreadsheet application knowledge.
• Proficient with Microsoft Office (Excel, Word, Access) and Excel macros.
• Experience with relational databases (SQL Server).
• Experience with data visualization tools (Tableau, Power BI).
• Experience querying large data sets from multiple sources.
• Experience reading/storing procedures; loading tables into SQL.
• Pharmacy or medical claims data analysis experience preferred.

Responsibilities

• Assist with 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.
• Develop criteria and programs with the design team to analyze pharmacy claims data.
• Perform quality reviews of the data output.
• Interface with a multi-disciplinary team across office locations.

Skills

Analytical skills

SQL

Excel

Data visualization

Power BI

Tableau

Data manipulation

Database knowledge

Education

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

Tools

SQL Server

Excel macros

Access

Job description

Job Description

The Pharmacy Analyst in our Pharmacy group will perform analysis, data manipulation and review of pharmacy claims and price data; work with pharmacists, programmers, database administrators and other analysts to create programs utilized to extract datasets; build fiscal impact models; perform quality reviews on program output; interpret data results; and prepare and format data for use by team members and clients.

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 care administration, health information, criminal justice or related field

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

We understand that changing or learning a new industry can discourage strong candidates from applying.