Pharmacy Audit Engineer Analyst

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, 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: oPlan and develop the audit approach for assigned projects consistent with guidelines established by Remedy internal Audit Standards oWork simultaneously on multiple audits with differing deadlines while maintaining attention to detail within the appropriate timelines oAnalyze and perform quality checks of master files, profiles, and table changes to ensure all changes are appropriately accounted for oContinuously improve upon current audit automation transforms based on audit findings, industry changes, and technology updates oTrack open audit observations and perform follow-up to evaluate the adequacy of remediation efforts with both PBM and Remedy account team oDraft audit reports to effectively communicate the results of the analysis to Remedy account team oPerform (daily/weekly) ad hoc data analytics requests as prioritized per Department Management oRe-evaluate system functionality to identify opportunities for improving operational efficiencies. oComply with and adhere to all regulatory compliance areas, policies, and procedures (including HIPAA requirements), and "leading practices". Skills & Experience to be Successful: oWorking knowledge of SQL, including joins, aggregations, filtering, and subqueries/CTEs. Experience with Oracle is a plus oFamiliarity with window functions, and running totals, or the ability to learn them quickly. oExperience loading or importing data into a database with a tool like Toad, SQL Developer, or similar oExperience building reports or dashboards in Power BI or another BI tool oComfortable checking query results for accuracy and maintaining existing queries. oRelevant experience that demonstrates problem-solving, financial acumen, and analytical output oProficiency in MS Office applications (Excel, Word, Powerpoint, PowerBI etc.) oAbility to thrive in a fast-paced environment, responding quickly to oversight and following instruction closely, while anticipating needs and developing efficiencies on repeat tasks oExcellent verbal and written communication skills to assemble data as applicable oExperience developing and maintaining effective, collaborative working relationships with clients and internal stakeholders oStrong sense of project ownership and the ability to manage high project volume effectively oExcellent problem-solving, critical thinking and analytics skills with the ability to work in a cross-functional team. oMust be able to adapt to change in direction and priorities in a project and deadline-oriented environment. Licenses & Certifications: Bachelors degree in data science, or analytics degree and/or similar discipline Preferred but not required: oExperience in Project Management oExperience with version control (git, bitbucket) oFamiliarity with Visualization tools (PowerBI/SSRS preferred) oProficiency in Python (pandas, NumPy, general data manipulation techniques) oFamiliarity with low code to no code solutions oExperience working with Pharmacy and/or Medical claims data oPharmacy claims audit experience &/or knowledge of pharmacy claims data oBasic understanding of how data is organized for reporting, such as fact and dimension tables oExposure to Toad for Oracle specifically or similar application 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.