[Hiring] Pharmacy Audit Engineer Analyst @Brown & Brown Insurance

Role Description

Brown & Brown / Remedy Analytics is looking for a full-time experienced Pharmacy Audit Engineer/Analyst, with keen analytical skills and an eye for detail, to join our growing team. The Audit Engineer/Analyst 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
• Performing 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
• Working with the client support team to develop PBM & client deliverables
• Utilizing ad hoc SQL automation and building a highly customized framework to complete projects
• Developing, prioritizing, and conducting financial and operational audits to evaluate the effectiveness of PBM contracts, controls, and accuracy of financial information

Qualifications

• Working knowledge of SQL, including joins, aggregations, filtering, and subqueries/CTEs. Experience with Oracle is a plus
• Familiarity with window functions, and running totals, or the ability to learn them quickly
• Experience loading or importing data into a database with a tool like Toad, SQL Developer, or similar
• Experience building reports or dashboards in Power BI or another BI tool
• Comfortable checking query results for accuracy and maintaining existing queries
• Relevant experience that demonstrates problem-solving, financial acumen, and analytical output
• Proficiency in MS Office applications (Excel, Word, PowerPoint, Power BI, etc.)
• Ability to thrive in a fast-paced environment, responding quickly to oversight and following instruction closely, while anticipating needs and developing 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 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

Requirements

• Bachelor’s degree in data science, or analytics degree and/or similar discipline
• Preferred but not required:
  • Experience in Project Management
  • Experience with version control (git, bitbucket)
  • Familiarity with Visualization tools (PowerBI/SSRS preferred)
  • Proficiency in Python (pandas, NumPy, general data manipulation techniques)
  • Familiarity with low code to no code solutions
  • Experience working with Pharmacy and/or Medical claims data
  • Pharmacy claims audit experience &/or knowledge of pharmacy claims data
  • Basic understanding of how data is organized for reporting, such as fact and dimension tables
  • Exposure to Toad for Oracle specifically or similar application

Benefits

• 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