Pharmacy Audit Engineer — Data Analytics & Compliance

Brown & Brown Insurance; Madison (WI); On-site; USD 75,000 - 90,000; Full time

Benefits offered by this job

Health Benefits

Financial Benefits

Mental Health & Wellness

Beyond Benefits

Job summary

Brown & Brown / Remedy Analytics is seeking a full-time experienced Pharmacy Audit Engineer to join our Madison, WI team. You will lead pharmacy claims audits to verify PBM contract compliance, perform data loading and quality checks, and develop automated SQL workflows to deliver reliable insights.

You will collaborate with PBMs and the client support team, draft audit reports, and drive continuous improvements in audit procedures, controls, and analytics across multiple engagements.

Qualifications

• Bachelor’s degree in computer science, engineering and/or similar discipline with analytical bias.
• Highly proficient in database table creation/management, ETL process, complex Oracle/SQL queries, and code maintenance.
• Dimensional Model understanding and experience manipulating models, developing, and executing on business logic.
• Relevant experience that demonstrates problem-solving, financial acumen, and analytical output.
• Proficiency in MS Office applications (Excel, Word, Powerpoint, PowerBI etc.).
• Ability to thrive in a fast-paced environment, respond quickly to oversight, and develop efficiencies on repeat tasks.
• Excellent verbal and written communication skills to assemble data as applicable.
• Experience developing and maintaining effective, collaborative working relationships with clients and internal stakeholders.
• Strong sense of project ownership and the ability to manage high project volume effectively.
• Excellent problem-solving, critical thinking and analytics skills for cross-functional teams.
• Must be able to adapt to change in direction and priorities in a project- and deadline-oriented environment.

Responsibilities

• Plan and develop the audit approach for assigned projects consistent with guidelines established by Remedy internal Audit Standards.
• Work simultaneously on multiple audits with differing deadlines while maintaining attention to detail within timelines.
• Analyze and perform quality checks of master files, profiles, and table changes to ensure changes are accounted for.
• Continuously improve audit automation transforms based on findings, industry changes, and tech updates.
• Track open audit observations and perform follow-up to evaluate remediation adequacy with PBMs and Remedy teams.
• Draft audit reports to effectively communicate results to Remedy account team.
• Perform daily/weekly ad hoc data analytics requests as prioritized by management.
• Re-evaluate system functionality to identify opportunities for improving operational efficiencies.
• Comply with regulatory areas, policies, and HIPAA requirements and leading practices.

Skills

Database design

ETL processes

Oracle/SQL queries

Code maintenance

Business logic

Analytical output

MS Office / PowerBI

Communication skills

Client/stakeholder relations

Project ownership

Problem solving / analytics

Adaptability

Education

Bachelor’s degree in CS/Engineering

Tools

PowerBI

Git / Bitbucket

Python (pandas/NumPy)

Visualization tools

Job description

Brown & Brown / Remedy Analytics is seeking a full-time experienced Pharmacy Audit Engineer to join our Madison, WI team. You will lead pharmacy claims audits to verify PBM contract compliance, perform data loading and quality checks, and develop automated SQL workflows to deliver reliable insights.

You will collaborate with PBMs and the client support team, draft audit reports, and drive continuous improvements in audit procedures, controls, and analytics across multiple engagements.