Oversee and review client impact analysis, regulatory reporting, MAC Management, as well as other financial analysis to support PBM pricing strategies and operational decisions
Write complex SQL queries and Python scripts independently to extract, transform, and analyze pricing data, as well as to automate existing manual processes - documenting and utilizing version control as appropriate
Design and maintain database structures following best practices for table design, permissions, and data integrity. This includes drug lists, pharmacy network lists, rebate data ingestion, and contractual term management, ensuring data integrity through systematic validation processes
Build specialized reports and analytical frameworks from first principles, moving beyond pre-configured templates to deliver custom solutions
Identify and implement automation opportunities to streamline pricing operations and reporting processes
Collaborate with business stakeholders to translate business needs into technical solutions and models to add scalability and value to our operations
Organize, document, and create structure around data processes, establishing frameworks where none exist
Other duties as assigned.

Requirements

Bachelor's degree in Mathematics, Computer Science, or related field
3+ years of relevant healthcare experience in financial data analysis and reporting as an individual contributor, with demonstrated ability to lead other analysts.
Strong skills in Excel, Databases, and SQL, with the ability to write code independently and solve problems creatively
Python programming knowledge and experience
Management experience with small teams
Strong written and verbal communication skills

Applicant Tracking System Keywords

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

Hard Skills & Tools

SQLPythonExcelDatabase designData analysisData transformationData integrityAutomationReportingVersion control

Soft Skills

LeadershipCommunicationCollaborationProblem-solvingOrganizational skillsDocumentationCreativityStakeholder engagementAnalytical thinkingScalability

Certifications

Bachelor's degree in MathematicsBachelor's degree in Computer Science