<p>Our ideal candidate will demonstrate professionalism, organizational strength, and the ability to thrive in a fast-paced environment while adapting to changing priorities. This role is critical in ensuring our data processes run smoothly and client deliverables are met in a timely fashion so that Operations and Consulting teams can deliver timely, high-quality insights to clients.</p> <ul> <li> <p>Produce and quality check monthly and quarterly report books for clients from our internal pharmacy data warehouse</p> </li><li> <p>Review data for reasonableness, and validate data against key performance indicators collected from the Pharmacy Benefit Manager vendor (PBM)</p> </li><li> <p>Learn to perform pharmacy pricing guarantee reconciliations for clients on both a quarterly and annual basis</p> </li><li> <p>Learn to navigate Lockton's internal pharmacy data warehouse and reporting. Pull routine and ad hoc reporting from the data warehouse as requested by consulting team</p> </li><li> <p>Develop financial models and reports for clients and account executive/consultants, provide interpretation and implication of analysis, as well as recommendations</p> </li><li> <p>Oversee the servicing of a designated book or partial book of business as relating to marketing, claims, reporting and administration</p> </li><li> <p>Track day-to-day issues related to clients' pharmacy plans and assist team members in closing out open items</p> </li><li> <p>Build and maintain internal and external timelines for projects such as RFPs, renewals, reporting, and other projects</p> </li><li> <p>Learn to interpret clients' current contract terms, pharmacy programs and identify/recommend gaps, alternatives, additional plan design changes, etc. and maintain contract terms in database.</p> </li><li> <p>Assist in developing an implementation plan with client and help consulting teams on client deliverables</p> </li><li> <p>Assist in the review of all agreements and/or documents related to best in class terms/provisions</p> </li><li> <p>Help with upkeep of client CRM with all relevant client information.</p> </li><li> <p>Work with internal data operations team to maintain client data quality.</p> </li><li> <p>Other responsibilities as assigned and/or needed</p> </li></ul>