Pharmacy Audit Engineer

Brown & Brown, Inc.; Northern (KY); Hybrid; USD 75,000 - 90,000; Full time

Benefits offered by this job

Health benefits

401k

Tuition reimbursement

Paid time off

Mental health support

Job summary

Brown & Brown, Inc. (Remedy Analytics) is seeking a remote Pharmacy Audit Engineer to join our team in the United States. You will conduct pharmacy claims audits to ensure PBM contract compliance, perform data loading and quality checks, and develop an automated data framework.

The role requires strong SQL/Oracle skills, data modeling, and experience with Python and BI tools. You will work closely with PBMs and the Remedy client support team to deliver audits and reporting, while maintaining

Qualifications

• Bachelor’s degree in computer science, engineering or similar with analytical bias.
• Strong SQL/Oracle experience and data validation skills.
• Experience with data modeling, ETL and QA checks.
• Excellent communication and collaboration with clients and internal teams.

Responsibilities

• Plan and develop the audit approach consistent with Remedy standards.
• multitask on audits with tight deadlines while maintaining accuracy.
• Analyze master files, profiles, and table changes for accuracy.
• Improve audit automation transforms based on findings and tech updates.
• Track open audit observations and follow up on remediation with PBMs and clients.
• Draft audit reports to communicate results to the account team.
• Handle ad hoc data analytics requests as needed by management.
• Ensure HIPAA compliance and adhere to regulatory policies.

Skills

Database design

ETL processes

Oracle SQL

Code maintenance

Education

Bachelor's degree in CS/Engineering

Tools

PowerBI

SSRS

Git

Bitbucket

Python (pandas)

Job description

## Pharmacy Audit EngineerApply: Remote: Remote - Wisconsin: Full time: Posted Today: R26\\_0000003418Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. **Brown & Brown / Remedy Analytics** is looking for a full-time experienced **Pharmacy Audit Engineer**, with keen analytical skills and an eye for detail, to join our growing team. The Audit Engineer will be responsible for completing pharmacy claims audits to ensure compliance to PBM contracts. This role will involve facilitating calls with PBMs, obtaining claims audit data, perform data loading and data quality checks, data reconciliation, running and analyzing Oracle output reports, running ad-hoc analysis, reviewing PBM contracts, completing audit support documentation and working with the client support team to develop PBM & client deliverables. The audit engineer will utilize ad hoc SQL automation and build a highly customized framework to complete projects. This role will develop, prioritize, and conduct financial and operational audits to evaluate the effectiveness of PBM contracts, controls, and accuracy of financial information. ### **How You Will Contribute:**o Plan and develop the audit approach for assigned projects consistent with guidelines established by Remedy internal Audit Standardso Work simultaneously on multiple audits with differing deadlines while maintaining attention to detail within the appropriate timelineso Analyze and perform quality checks of master files, profiles, and table changes to ensure all changes are appropriately accounted foro Continuously improve upon current audit automation transforms based on audit findings, industry changes, and technology updateso Track open audit observations and perform follow-up to evaluate the adequacy of remediation efforts with both PBM and Remedy account teamo Draft audit reports to effectively communicate the results of the analysis to Remedy account teamo Perform (daily/weekly) ad hoc data analytics requests as prioritized per Department Managemento Re-evaluate system functionality to identify opportunities for improving operational efficiencies.o Comply with and adhere to all regulatory compliance areas, policies, and procedures (including HIPAA requirements), and \"leading practices\". ### **Skills & Experience to be Successful:**o Bachelor’s degree in computer science, engineering and/or similar discipline with analytical biaso Highly proficient in database table creation/management, ETL process, complex Oracle/SQL queries, and code maintenanceo Dimensional Model understanding and experience manipulating models, developing, and executing on business logico Relevant experience that demonstrates problem-solving, financial acumen, and analytical outputo Proficiency in MS Office applications (Excel, Word, Powerpoint, PowerBI etc.)o Ability to thrive in a fast-paced environment, responding quickly to oversight and following instruction closely, while anticipating needs and developing efficiencies on repeat taskso Excellent verbal and written communication skills to assemble data as applicableo Experience developing and maintaining effective, collaborative working relationships with clients and internal stakeholderso Strong sense of project ownership and the ability to manage high project volume effectivelyo Excellent problem-solving, critical thinking and analytics skills with the ability to work in a cross-functional team.o Must be able to adapt to change in direction and priorities in a project and deadline-oriented environment.**Preferred but not required**o Experience in Project Managemento Experience with version control (git, bitbucket)o Familiarity with Visualization tools (PowerBI/SSRS preferred)o Proficiency in Python (pandas, NumPy, general data manipulation techniques)o Familiarity with low code to no code solutionso Experience working with Pharmacy and/or Medical claims datao Pharmacy claims audit experience &/or knowledge of pharmacy claims data**Pay Range**$75,000 - $90,000 Annual*The pay range provided above is made in good faith and based on our lowest and highest annual salary or hourly rate paid for the role and takes into account years of experience required, geography, and/or budget for the role.***Teammate Benefits & Total Well-Being**We go beyond standard benefits, focusing on the total well-being of our teammates, including:* *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* *Beyond Benefits*: Paid Time Off, Holidays, Preferred Partner Discounts and more.*Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations.*