Pharmacy Audit Engineer

Brown & Brown Insurance

. Complete pharmacy claims audits to ensure compliance with PBM contracts .

Posted 9/29/2026full-timeRemote • Wisconsin • United StatesMid-LevelSenior💰 $75,000 - $90,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in pharmacy claims audits, data analysis, and compliance with PBM contracts. Proficient in SQL automation, financial auditing, and effective communication with stakeholders.

Highest-signal resume keywords

Pharmacy Claims AuditsOracle SQL QueriesData Quality ChecksFinancial AuditingRegulatory Compliance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Database Table CreationETL ProcessDimensional ModelingData ReconciliationAd Hoc AnalysisAudit DocumentationData AnalyticsProject ManagementPython Data ManipulationVersion Control

Soft Skills

Problem-SolvingCritical ThinkingCommunicationCollaborationProject Ownership

Tools & Technologies

OracleMS OfficePowerBISSRSRemedy Audit Standards

Industry Keywords

PBM ContractsHIPAA CompliancePharmacy Claims DataOperational EfficiencyAudit Automation

Tech Stack

Tools & technologies

ETLNumpyOraclePandasPythonSQL

About the role

Key responsibilities & impact

Complete pharmacy claims audits to ensure compliance with PBM contracts
Facilitate calls with PBMs and obtain claims audit data
Perform data loading, data quality checks, and data reconciliation
Run and analyze Oracle output reports
Perform ad-hoc analysis
Review PBM contracts
Complete audit support documentation
Work with the client support team to develop PBM and client deliverables
Utilize ad hoc SQL automation and build a highly customized framework to complete projects
Develop, prioritize, and conduct financial and operational audits evaluating PBM contracts, controls, and financial information accuracy
Plan and develop audit approaches for assigned projects according to Remedy internal Audit Standards
Work simultaneously on multiple audits with differing deadlines
Analyze and quality-check master files, profiles, and table changes
Improve audit automation transforms based on findings, industry changes, and technology updates
Track open audit observations and follow up on remediation efforts with PBM and Remedy account teams
Draft audit reports communicating analysis results to the Remedy account team
Perform daily/weekly ad hoc data analytics requests as prioritized by Department Management
Re-evaluate system functionality to identify operational efficiency improvements
Comply with regulatory compliance areas, policies, procedures, HIPAA requirements, and leading practices

Requirements

What you’ll need

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.)
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 with the ability to work in a cross-functional team
Must be able to adapt to change in direction and priorities in a project and deadline-oriented environment
Preferred but not required: Experience in Project Management
Preferred but not required: Experience with version control (git, bitbucket)
Preferred but not required: Familiarity with Visualization tools (PowerBI/SSRS preferred)
Preferred but not required: Proficiency in Python (pandas, NumPy, general data manipulation techniques)
Preferred but not required: Familiarity with low code to no code solutions
Preferred but not required: Experience working with Pharmacy and/or Medical claims data
Preferred but not required: Pharmacy claims audit experience &/or knowledge of pharmacy claims data

Benefits

Comp & perks

Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance
Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement
Mental Health & Wellness: Free Mental Health & Enhanced Advocacy Services
Paid Time Off
Holidays
Preferred Partner Discounts