Pharmacy Data Analyst at Lockton

Job description

body> Pharmacy Data Analyst Minneapolis, Minnesota , United States of America Data Analytics 2601BM Apply now Share Pharmacy Data Analyst Minneapolis, Minnesota , United States of America Data Analytics 2601BM Apply now Share Working at Lockton At Lockton, we’re passionate about helping our people achieve their ultimate potential. Our people are curious, action-oriented and always striving to make ourselves and those around us better. We’re active listeners working to ensure understanding and problem solvers developing innovative solutions. If you can see yourself delivering excellent service to clients, giving back to our communities and being a part of our caring culture, you belong here. Business unit Center Services Salary $62,000-$67,000 Schedule Full-time Lockton Benefits Offerings Click Here Workplace In Office Your Responsibilities Description - External 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. • Produce and quality check monthly and quarterly report books for clients from our internal pharmacy data warehouse • Review data for reasonableness, and validate data against key performance indicators collected from the Pharmacy Benefit Manager vendor (PBM) • Learn to perform pharmacy pricing guarantee reconciliations for clients on both a quarterly and annual basis • 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 • Develop financial models and reports for clients and account executive/consultants, provide interpretation and implication of analysis, as well as recommendations • Oversee the servicing of a designated book or partial book of business as relating to marketing, claims, reporting and administration • Track day-to-day issues related to clients’ pharmacy plans and assist team members in closing out open items • Build and maintain internal and external timelines for projects such as RFPs, renewals, reporting, and other projects • 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. • Assist in developing an implementation plan with client and help consulting teams on client deliverables • Assist in the review of all agreements and/or documents related to best in class terms/provisions • Help with upkeep of client CRM with all relevant client information. • Work with internal data operations team to maintain client data quality. • Other responsibilities as assigned and/or needed Qualifications Qualifications • A Bachelor’s Degree in a business-related field or equivalent experience in the insurance industry • A minimum of 1-2 years’ experience in the insurance industry, specifically in employee welfare benefits or pharmacy data analytics • Knowledge of the Pharmacy Benefit Management (PBM) industry preferred • Demonstrate advance knowledge of PowerPoint, Word, and Excel • Strong verbal and interpersonal communication skills • Strong customer service skills, with the ability to develop strong client relationships with multiple clients • Ability to interact with vendors effectively • Excellent organizational and communication skills • Motivated self-starter who is also able to work well on a team • Legal right to work in the United States Lockton Companies, LLC is an equal opportunity employer. As a privately held company, we offer a competitive compensation and benefits package reflecting our commitment to attracting and retaining great individuals. This includes health, vision and dental coverage, which begins on your first day of work, 401(k) with match and immediate vesting and a competitive vacation plan. #LI-DG2 #LI-MM4 Equal Opportunity Statement Lockton Companies is proud to provide everyone an equal opportunity to grow and advance. We are committed to an inclusive culture and environment where our people, clients and communities are treated with respect and dignity. At Lockton, supporting diversity, equity and inclusion is ingrained in our values, and we believe that we are at our best when we fully embrace everyone. We strive to cultivate a caring culture that learns from, celebrates and thrives because of our breadth of differences. As such, we recognize that recruiting, developing and retaining people with diverse backgrounds and experiences is vital and enabling our people to thrive personally and professionally is critical to our long-term success. About Lockton Lockton is the largest privately held independent insurance brokerage in the world. Since 1966, our independence has allowed us to serve our clients, take care of our people and give back to our communities. As such, our 13,100+ Associates doing business in over 155 countries are empowered to do what’s right every day. At Lockton, we believe in the power of all people. You belong at Lockton. How We Will Support You At Lockton, we empower you to be true to yourself in all that you do. Your success is our success, and we provide opportunities to help you grow and create a rewarding career path, however you envision it. We are ready to meet you where you are today, and as your needs change over time. In addition to industry-leading health insurance, we offer additional options to support your overall health and wellbeing. Learn more about your Lockton experience No Agencies Please Any Employment Agency, person or entity that submits an unsolicited resume to this site does so with the understanding that the applicant's resume will become the property of Lockton Companies, Inc. Lockton Companies will have the right to hire that applicant at its discretion and without any fee owed to the submitting Employment Agency, person or entity. Employment Agencies, who have fee Agreements with Lockton Companies must submit applicants to the designated Lockton Companies Employment Coordinator to be eligible for placement fees. Similar Vacancies View all Security Engineer, Detection & Response Kansas City , United States of America Information Technology 2601MM Account Executive Kansas City , United States of America Client Services 2601PJ Complex Claims Coordinator Kansas City , United States of America Client Services 2601AB Senior Account Executive - Real Estate Los Angeles , United States of America Client Services 2601O9 Life at Lockton April 20, 2023 Stephanie Robinson P... Lockton is pleased to announce the promotion of Stephanie Robinson to Chief Diversity Officer. Stephanie joined Lockton in February 2022 as Director of Diversity, Equity and Inclusion after building and leading DEI at Blue Cross and Blue Shield of Kansas City. Stephanie has also worked in Human Resources at UMB Financial, H&R Block, Cerner Corporation and Quest Diagnostics. In the community, Stephanie currently works with Jackson County CASA. "Stephanie hit the ground running, meeting with people across Lockton to fully understand our culture and identify areas of opportunity,” said Peter Clune, CEO of Lockton. “I’m proud of the great work that has been accomplished and look forward to Stephanie’s continued impact.” In her new role, Stephanie will be taking the helm from Brian Roberts who has been leading the development and execution of Lockton’s DEI strategy as Chief Diversity Officer while also leading the Midwest Series as COO. I want to thank Brian for his leadership over the last few years and his work setting us up for continued progress. “I am excited to serve as Lockton’s new Chief Diversity Officer," said Robinson. "I will continue in my efforts to advance DEI and make Lockton a place where all people feel welcome, valued and excited to build a career here.“ April 20, 2023 Empowered people tod... Environmental responsibility, social impact and corporate governance (ESG) considerations play an important role in how we approach our business and our culture at Lockton, and what makes Lockton stand apart is also what makes us better: independence. The components of ESG are not new to us — in fact, many elements of an ESG strategy are reflected in the philosophies we abide by every day. A group representing Lockton’s senior and regional leadership, product line leaders, and experts across the globe came together to formally explore all areas of our business and the steps we have taken to ensure we operate responsibly and ethically while staying true to our independent culture and empowered business model. Our commitment to our clients, our people and our communities gives us the unique opportunity to define who we are and what we are engaged in. And it empowers our people to take ownership across these three categories to drive a sustainable business. We are pleased to share our ESG report. This report profiles our core principles around ESG and highlights examples of how our people and teams are working around the world to advance our collective impact. Learn more about our approach to ESG. April 20, 2023 Lockton announces m... Lockton, the world’s largest independent brokerage firm, has begun a three-year partnership with Tate, a group of four galleries: Tate Modern, Tate Britain, Tate Liverpool and Tate St Ives. This new partnership will focus on three upcoming exhibitions at Tate Britain. From October 2023 it will also support an expanded community programme at Tate Britain. The partnership will allow Lockton and Tate to deliver on their shared agenda of promoting artistic risk-taking, community engagement and access to art for all. Our partnership also means that our UK Associates will get access to the Tate exhibitions and will be an integral part of the relationship. Tate first opened its doors to the public in 1897 with one site. Today it has four major sites and holds the national collection of British art from 1500 to the present day and international art from 1900 to the present day, including nearly 70,000 pieces of art. EJ Hentenaar, CEO of Lockton Europe, said: “Lockton is incredibly proud to launch our new multi-year partnership with Tate, encompassing our shared values of independence, diversity and inclusion. I am particularly excited about our support of the community programme next year, allowing us to deliver on our shared ambitions and foster greater cultural awareness.” May 8, 2023 Lockton recognized a... Lockton is proud to announce it has been selected as a US Best Managed Company for the third year in a row. Sponsored by Deloitte Private and The Wall Street Journal, the program recognizes outstanding U.S. private companies and the achievements of their management teams. The 2023 designees are U.S. private companies that have demonstrated excellence in strategic planning and execution, a commitment to their people and fostering a dynamic culture, as well as strong financials. Designees propelled their businesses forward and remained true to their purpose and values by investing in their people, creating advantage through digital transformation and demonstrating their commitment to diversity, equity, and inclusion. Lockton recently surpassed $3 billion in revenue after 57 years in business, with $1 billion of that growth occurring in the past 24 months. While experiencing incredible growth across the business, the company remains true to its caring culture and shared values. This growth is a testament to Lockton's amazing people and their commitment to providing outstanding service and value to clients. Applicants are evaluated and selected by a panel of external judges focused on assessing hallmarks of excellence in four key areas: strategy, ability to execute, corporate culture and governance/financial performance. They join a global ecosystem of honorees from more than 46 countries recognized by the Best Managed Companies program. About the Best Managed Companies Program The Best Managed Companies program is a mark of excellence for private companies. U.S. designees have revenues of at least $250 million. Hundreds of private companies around the world have competed for this designation in their respective countries through a rigorous and independent process that evaluates four key criteria in their management skills and practices — strategy, execution, culture and governance/financials. U.S. program sponsors are Deloitte Private and The Wall Street Journal. For more information, visit www.usbestmanagedcompanies.com.

Requirements

Must-haves

Pharmacy Data Analyst
Minneapolis, Minnesota , United States of America
Data Analytics
Apply now Share
Pharmacy Data Analyst
Minneapolis, Minnesota , United States of America
Data Analytics
Apply now Share
Working at Lockton
Business unit
Center Services
Description - External
Produce and quality check monthly and quarterly report books for clients from our internal pharmacy data warehouse
Review data for reasonableness, and validate data against key performance indicators collected from the Pharmacy Benefit Manager vendor (PBM)
Learn to perform pharmacy pricing guarantee reconciliations for clients on both a quarterly and annual basis
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
Develop financial models and reports for clients and account executive/consultants, provide interpretation and implication of analysis, as well as recommendations
Oversee the servicing of a designated book or partial book of business as relating to marketing, claims, reporting and administration
Track day-to-day issues related to clients’ pharmacy plans and assist team members in closing out open items
Build and maintain internal and external timelines for projects such as RFPs, renewals, reporting, and other projects
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.
Assist in developing an implementation plan with client and help consulting teams on client deliverables
Assist in the review of all agreements and/or documents related to best in class terms/provisions

Nice-to-haves

Knowledge of the Pharmacy Benefit Management (PBM) industry preferred

Application prep

Use the role’s language and application details while tailoring your materials.

Platform: careers-html
Effort: medium

Benefits

Benefits detected in the listing.

Health Insurance

Dental

Vision

401(K)