o Continuously improve upon current audit automation transforms based on audit findings, industry changes, and technology updates
o Track open audit observations and perform follow-up to evaluate the adequacy of remediation efforts with both PBM and Remedy account team
o Draft audit reports to effectively communicate the results of the analysis to Remedy account team
o Perform (daily/weekly) ad hoc data analytics requests as prioritized per Department Management
o 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 Working knowledge of SQL, including joins, aggregations, filtering, and subqueries/CTEs. Experience with Oracle is a plus
o Familiarity with window functions, and running totals, or the ability to learn them quickly.
o Experience loading or importing data into a database with a tool like Toad, SQL Developer, or similar
o Experience building reports or dashboards in Power BI or another BI tool
o Comfortable checking query results for accuracy and maintaining existing queries.
o Relevant experience that demonstrates problem-solving, financial acumen, and analytical output
o 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 tasks
o Excellent verbal and written communication skills to assemble data as applicable
o Experience developing and maintaining effective, collaborative working relationships with clients and internal stakeholders
o Strong sense of project ownership and the ability to manage high project volume effectively
o 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.
Licenses & Certifications
Bachelor’s degree in data science, or analytics degree and/or similar discipline
Preferred but not required
o Experience in Project Management
o 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 solutions
o Experience working with Pharmacy and/or Medical claims data
o Pharmacy claims audit experience &/or knowledge of pharmacy claims data
o Basic understanding of how data is organized for reporting, such as fact and dimension tables
o Exposure 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.
Recruiting Vendor Disclosure Statement
Brown & Brown does not accept unsolicited resumes from external recruiters, recruitment vendors or employment agencies ("Recruiting Vendors"). Recruiting Vendors must have a valid written agreement and received prior written authorization from an authorized Brown & Brown representative before submitting candidates for any publicly posted role. Any unsolicited resumes submitted to Brown & Brown or its employees become the property of Brown & Brown, and no fees will be paid for such submissions. Additional information regarding this policy can be found on our careers page.
The Power To Be Yourself
As an Equal Opportunity Employer, we are committed to fostering an inclusive environment comprised of people from all backgrounds, with a variety of experiences and perspectives, guided by our Diversity, Inclusion & Belonging (DIB) motto, “The Power to Be Yourself”.