Pharmacy Data Analyst

Kansas City, Missouri, United States of America

Data Analytics

24023Z

Apply now

Kansas City, Missouri, United States of America

Data Analytics

24023Z

Apply now

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.

Secondary locations

Dallas

Business unit

Lockton-Dunning Series

Schedule

Full-time

Job type

Standard

Workplace

Hybrid

Your Responsibilities

Lockton Dunning Benefits is currently seeking a Pharmacy Data Analyst, who will help with client data file management, data analysis, data governance, reporting and operations related to Pharmacy Analytics. Your team provides support for Pharmacy Benefit analytics to all lines of Health and Welfare assisting with RFP activities, reporting and reconciliations.
Our ideal candidate will demonstrate – and model for the team – a high level of professionalism, an ability to embrace our friendly and ambitious culture, the capability to thrive in a fast-paced environment, and the flexibility to easily adapt to changing priorities. You will be an important contributor in the realization of our mission to revolutionize insurance to protect what matters.

• Manages day-to-day operations for reviewing data validation, vendor file transfers and data mapping.
• Drives relationship with internal account teams for process enhancements and for resolving open data issues.
• Maintains a thorough understanding of the data warehouse process, PBM contract requirements, reconciliations, ftp processes, vendor agreements, reporting applications and reporting requirements.
• Meets established Quality Standards and help drive higher standards.
• Maintains team documents, files, standards, operating procedures, and guidelines.
• Identifies competing timelines and actively engages team members and cross functional teams to prioritize deliverables.
• Attends weekly sessions with team/series leads on all open projects and sets priorities.
• Helps execute strategic vision for data warehouse enhancements/improvements to serve Analytics needs.
• Interfaces with strategic partners to address issues and trends.
• Reviews and corresponds to vendor requests and inquiries for data transfer activities.
• Helps establish practices around data governance and accuracy management.
• Creates and updates JasperSoft reports per the business needs.
• Creates and runs analytic models using SQL to analyze trends at a client and book of business level.
• Maintains a high level of professionalism and sense of urgency to ensure client and account team expectations are consistently met.
• Performs other duties as assigned or requested.

Qualifications

• Proficiency in the use of Microsoft Word, Excel, SQL and PowerPoint. MS Access experience desired.
• Thorough understanding of claims files processing and data concepts.
• Knowledge of Pharmacy Analytics coverage’s and services.
• Knowledge of data visualization.
• Must have strong internal and external customer service skills, along with the ability to develop sound internal client relationships.
• Demonstrates the ability to instill confidence and comfort with clients and representatives.
• Must have strong verbal, written, and interpersonal skills to interact with associates at all levels of responsibility, along with the ability to communicate with tact and diplomacy.
• Demonstrates professional, tactful negotiation and persuasion skills to achieve objectives.
• Organizational and time management skills to prioritize workload and meet deadlines required. Must be results oriented with the ability to change priorities as needed.
• Efficient in multi-tasking (managing workload and timeliness).
• Self-motivated and a team player.
• Adept at problem solving and making critical decisions.
• Ability to interpret and implement company and state policies and processes.
• Ability to grasp new and complex concepts.
• Bachelor’s Degree (preferred) not a requirement
• Minimum 1– 2 years of experience in a data analysis role.
• Legal right to work in the United States.

#LI-TK1

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 10,000+ Associates doing business in over 100 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

Life at Lockton

January 22, 2025

Lockton recognized b...

Lockton is honored to announce we are among the winners of Glassdoor’s 17th annual Employees’ Choice Awards, ranking No. 37 on the U.S. Large list of Best Places to Work in 2025. Glassdoor, a global leader in job and company insights, bases these awards on anonymous employee feedback. Unlike other workplace awards, there is no self-nomination or application process. Instead, it's entirely based on the feedback our Associates have voluntarily and anonymously shared on Glassdoor. To determine the award winners, Glassdoor evaluates company reviews shared by current and former employees over the past year. “We are deeply honored to be named a Best Place to Work by Glassdoor, especially as this recognition comes directly from our Associates' feedback,” said Martyn Worsley, Chief People Officer. “Our people are the cornerstone of Lockton’s success and growth. Our unwavering commitment to fostering a supportive and inclusive work environment, promoting career development, offering competitive compensation, and consistently recognizing achievements has created a workplace where Producers, Partners, and Associates thrive together. This recognition affirms that our efforts are making a difference in the lives of our people. Together, we are achieving extraordinary results, and I am immensely proud of this accomplishment.” Lockton has over 1,500 reviews, with over 83% of reviewers recommending the company. Lockton also holds a 4.4 employee rating, well above the 3.6-star industry average. In addition to this award, Lockton was recently named a Best Place to Work in Insurance for the 16th consecutive year and a Best Company to Work For by U.S. News & World Report. Here’s what some Associates are saying about Lockton on Glassdoor: "Best place to have a career in a dynamic industry." -Kansas City, current employee of more than 9 years "There are many companies out there that tout how much they care about their employees. In 25+ years in the insurance industry, I've never had such a caring, dedicated employer, who ensures that their staff are treated fairly, compensated well, and feel like an extended family of sorts. Fantastic benefits with great incentives to keep premiums low for employees, and a wonderful retirement matching component." -Dallas, current employee of more than 2 years "Lockton is hands-down the best company I’ve ever worked for. They value their Associates and enable you to serve your clients to the best of your availability. It’s a great environment for a self-starter, anyone who brings a natural curiosity to their work, and someone who love constant challenge." -Golden Valley, MN, current employee of more than 4 years "Lockton is an amazing opportunity for those that what to get involved with a wide variety of communities and meet new people while also performing their daily task in the workplace. Lockton also promotes all employees to give at least one day a year to volunteer anywhere of the employees choosing. Lockton cares to help others but most importantly they strive to connect people." -Kansas City, current employee of more than 2 years "Whether you’re already in the industry or are interested in it, Lockton is a great organization with opportunities to grow." -Los Angeles, current employee of more than 20 years

Life at Lockton Article Header_Graham Turville-Ince

December 17, 2024

Making a difference:...

Graham Turville-Ince's commitment to the Cerebral Palsy Alliance (CPA) is more than a passion - it's a mission to create meaningful change. His dedication began at CPA's Randwick Race Day, where he met a 6-year-old girl whose life was transformed by early intervention programs. "Her progress was remarkable, and seeing her parents' strength, especially with a second child also affected by cerebral palsy, left a lasting impression," Graham shared. This experience fueled his ongoing involvement. From volunteering at CPA's headquarters in Sydney to raising over $6,000 through the STEPtember challenge, where he took over one million steps to support the cause, Graham continues to raise funds and awareness for CPA. He also works to inspire others, whether colleagues or clients, to join in advocating for CPA's mission. Graham's efforts were recently recognised with Lockton's prestigious Community Impact Award. Funded by the Lockton family, this honour celebrates Associates making a difference in their communities through volunteering and philanthropy. The award includes a USD 25,000 donation for the recipient's charity of choice, which Graham directed to CPA. "Presenting that cheque, knowing the impact it will make, was an unforgettable moment," he said. "I felt genuinely humbled. It's incredible to be recognised alongside many passionate and impactful colleagues." The donation will go to providing vital therapy, respite services and a number of other programs for people living with cerebral palsy and their families. Lockton's caring culture played a critical role in Graham's ability to support CPA, allowing him to lead by example at work and in the community. "Lockton doesn't just support my passion- it enables it," he reflected. "From hands-on charity days to backing vetted causes, the encouragement from my team is invaluable." Looking ahead, Graham is determined to expand his advocacy efforts for CPA. He's working on transitioning fundraising events from his previous involvement with Oxfam to CPA and aims to inspire his professional network to support this vital cause. "Collaboration is key, whether it's colleagues, clients, or other organisations," he said. Graham remains focused on expanding CPA's impact, inspiring action within his networks, and driving lasting change. "When we work together, the possibilities for transformation are endless," he shared.

Life at Lockton Article Header_Kate Coppinger

December 16, 2024

My career, my story:...

From intern to consultant, Kate Coppinger's career at Lockton reflects the power of curiosity, hard work, and mentorship. She began her journey as a Marketing and Operations Intern with the Producer Lifecycle team in Kansas City during the summer of 2022. She found a pivotal mentor in Julie Gibson, now Lockton's Chief Marketing Officer, who guided her through her early career decisions. Her journey led her to Chicago, where she explored client-facing roles and now thrives as an Operations Consultant with the Midwest Growth and Operations team. "Lockton's commitment to developing Associates and empowering their success is unmatched," Kate shared. "At Lockton, you can truly carve out your career path." Learn more about her journey and the lessons she's learned along the way in her own words. --- Can you share your journey from a Marketing Intern to a full-time Associate at Lockton? Once I realized that I wanted to continue my career full-time at Lockton, I began having conversations with various Associates and leaders in the Kansas City and Chicago offices. I wanted to learn more about each of the different early career opportunities in People Solutions and Risk Solutions and evaluate what would best fit me. I also wanted to investigate if the same Lockton culture in Kansas City was present in Chicago. I decided to travel to the Chicago office to see if it was the right fit for me and meet with a few Associates. There, I met the president of the office and a former People Solutions intern turned Account Executive. By the end of the day, I could see myself thriving in Chicago with Lockton. All my conversations with Lockton Associates were paramount to my decision to continue at Lockton. They were a testament to Lockton's commitment to the development of Associates and the opportunity for personal and professional growth. What lessons have you learned as you've transitioned through different roles at Lockton? Lockton is a dynamic organization open to cross-functional promotions and transitions. I am a direct example of this, and I have seen many others go on their own journey here. I have learned the importance of openly sharing my interests and passions with my managers. I would not be in my role now if I didn't speak up. At Lockton, you can create your own career path that supports your passions – you are not stuck in one specialty or department forever.” Hard work pays off. Lockton appreciates drive and work ethic. Associates are recognized and rewarded accordingly. Lockton values those who are involved not only in the market and within our organization but also in our communities. Lastly, and arguably most importantly, I have learned to be a student of business. Staying curious, asking questions, and understanding the 'why?' have all helped me progress in my career. Being a student of business is to be a lifelong learner. What sets Lockton apart from other organizations? Lockton is a flat organization. There are no barriers to accessing leadership or managers. In fact, leadership is more than willing to connect individually with Associates to understand how they can improve their lives and responsibilities. At Lockton, Associates truly are our most valuable asset. What has been your "Lockton Moment" — a time when you knew Lockton was the right place for you? I knew Lockton was right for me during my time as an intern. I felt welcomed by Associates and even global leaders who were invested in my success. Every person I met cheered me on and dedicated themselves to helping me learn. I felt energized to make an impact, lead my peers, and grow professionally and technically as much as possible. My "Lockton Moment" came over time as I experienced firsthand the caring culture and genuine investment in my success. An example of this is when the global leadership team made time to attend our intern presentation in person. I was provided impactful feedback, along with encouragement and advice for my future career. This made a lasting impact on me because I felt appreciated and that my contributions mattered. I left my summer internship knowing if I pursued a full-time career with Lockton, I would be valued, supported, and empowered. How would you describe Lockton's culture to someone unfamiliar with it? Lockton's caring culture makes showing up to work every day so easy. On day one, I met and fostered lifelong friendships, not just coworkers. Our leaders genuinely care about the well-being and advancement of Associates. By being a privately held organization, our leaders have the flexibility and control to make business decisions that best support our three stakeholders: our Clients, our Associates, and our Communities. Lockton is an organization that rewards high-quality performance and supports Associates with proper learning and development to be successful.

November 1, 2024

Making an impact: Ra...

The Community Impact Award, funded by the Lockton family, honors Associates who go above and beyond to improve their communities through volunteering and philanthropy. This recognition enables each award recipient to direct a $25,000 donation to a charity of their choice, provided by the Lockton family. This year, both Rae Lynn Zachary and Shannan Smith were celebrated for their work with the Leukemia & Lymphoma Society (LLS), an organization dedicated to fighting blood cancers and improving the lives of patients and their families. Since 2011, Rae Lynn has been a dedicated participant in LLS’s fundraising walks, organizing teams in Lockton’s San Francisco office before transitioning to individual efforts. To date, she’s raised more than $37,000 personally, with an additional $33,000 from team contributions. Her involvement stems from personal loss: “I first became involved after my uncle passed away from leukemia in 2009,” she shares. “But it really became personal when a colleague’s infant son was diagnosed with the disease. Seeing him survive after months of treatment gave me a reason to keep going. Since then, I’ve lost two more family members and a friend to leukemia. That’s what drives me to keep walking and fundraising year after year.” For Shannan, supporting LLS began as a way to rally around a family friend diagnosed with acute lymphocytic leukemia (ALL) in 2014. To raise awareness, she organized the first "Lemonade for Leukemia" stand within her neighborhood, raising $415 in one weekend and turning the event into an annual summer tradition. “We then walk in the Light the Night event each September,” Shannan adds. “This cause became even more personal this year when a cousin was diagnosed and recently underwent a transplant. I’m hopeful that she, too, will be able to look back one day and see all the progress the LLS has made.” Both Rae Lynn and Shannan share a commitment to instilling the value of community service in their families, hoping to inspire the next generation to carry on their legacy. For Rae Lynn, involvement in LLS is a lasting commitment she hopes to carry into retirement. Shannan, inspired by her role as a mother and leader, aims to pass down her passion for service to her three daughters, saying, “I want them to understand the importance of giving back to those in need when you have the means to do so.” By demonstrating compassion and resilience through their work, both women have become role models within Lockton, their families and communities. The Community Impact Award holds deep significance for both women. “This award isn’t just about the donation—it’s a reflection of Lockton’s commitment to giving back,” Rae Lynn says. “Lockton encourages us to get involved in the causes we care about and provides the support to make that happen.” Shannan echoed this sentiment, describing how Lockton’s C.A.R.E. Committee and volunteer days foster a culture of compassion: “Lockton truly cares about what drives its Associates, giving us the flexibility to serve our clients while also supporting our community work.” Through their dedication and Lockton’s support, Rae Lynn Zachary and Shannan Smith are making a lasting impact, offering hope to those affected by blood cancer.