Data Analyst

Location Icon

Kansas City, Missouri, United States of America

Bag Icon

Information Technology

Profile Icon

25009G

Apply now

Data Analyst

Location Icon

Kansas City, Missouri, United States of America

Bag Icon

Information Technology

Profile Icon

25009G

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.

Business unit

Lockton Management, LLC

Schedule

Full-time

Lockton Benefits Offerings

Click Here

Workplace

Hybrid

Responsibility Icon

Your Responsibilities

The Data Analyst is responsible for ongoing analysis of financial data worldwide, obtained from a variety of different sources. It involves development and preparation of information, reconciliations and reports for management & associates.

Essential Duties:

  • Subject matter expert for the global finance data model
  • Create & generate standard and ad hoc reports on a regular basis
  • The data analyst must be able to recognize data issues and work with providers of data to resolve problems
  • Provides consulting, training, reporting and primary technical support as need for data intensive projects throughout the project lifecycle including post go-live
  • Responsible for monitoring progress and maintaining responsibility for delivering project deliverables accurately and on time

Other Responsibilities:

  • Makes decisions in compliance with established corporate and department standards
  • Provides exceptional customer service and adheres to the Lockton philosophies
Qualification Icon

Qualifications

  • BS/BA degree required
  • At least 3 years of experience in data or business analysis in the insurance industry or related field
  • At least 3 years of experience in working with project teams in an information technology environment
  • High proficiency with Oracle OTBI & FRS.
  • Proficiency with Microsoft SQL, Microsoft Excel, & Microsoft PowerBI
  • Familiarity with Oracle cloud products, such as EDMCS, FCCS, and Fusion ERP
  • Ability to express complex technical concepts effectively, both verbally and written
  • Ability to work well with & and describe tasks to non-technical users
  • Demonstrated ability to analyze data in a variety of formats and to provide recommendations and support in establishing strategic plans for undertaking data conversions
  • Demonstrated effectiveness in working with multi-functional teams in a technical production environment
  • Demonstrated ability to respond to customer requirements with timely and effective technical solutions
  • Ability to synthesize data from multiple sources
  • Superior attention to detail
  • Ability to multitask without sacrificing the quality and accuracy of project deliverables
  • Some overtime, off-shift support, and travel may be required
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

Life at Lockton_2025 Handshake ETA

March 11, 2025

Lockton named 2025 E...
At Lockton, we believe the future of our industry starts with the next generation of professionals. That is why we are dedicated to creating meaningful opportunities for early career talent, with hands-on learning, career development, and a culture that values fresh perspectives. This commitment has earned us a 2025 Early Talent Award from Handshake, the leading early career community in the U.S. With over 750,000 employers on the platform, we are honored to be recognized as one of the top organizations in the insurance industry. As the world’s largest privately held insurance brokerage, we empower our Associates to make an impact from day one. Whether through internships or full-time roles, our early career professionals contribute to innovative solutions for clients while also giving back to their communities. The Handshake Early Talent Awards (ETAs) celebrate companies that are shaping the future of work, and we’re proud to be among them. If you’re looking for a place where you can launch your career and grow with purpose, connect with Lockton on Handshake and explore opportunities on our Careers site. You belong here. You belong at Lockton.
Life at Lockton Article Header_BHM 2025

March 1, 2025

Celebrating Black Hi...
As we close out Black History Month 2025, we take a moment to reflect on the vibrant celebrations and meaningful engagements that highlighted the rich history and invaluable contributions of the Black community that we all share, both at Lockton and beyond. This month has been a testament to our commitment to diversity, equity, and inclusion, and a celebration of the diverse perspectives that our Associates and Producers bring to our business every day. In the Midwest, we embraced the spirit of Black History Month with engaging trivia sessions that not only educated but also rewarded participants with prizes from Black-owned businesses. Our happy hour events provided a platform to recognize the outstanding contributions of our Black Associate Resource Group. Our West region hosted a variety of events that brought our Associates together in celebration and learning. Denver organized both a breakfast and happy hour event, complete with raffle prizes supporting local Black-owned businesses. San Francisco's visit to the Museum of the African Diaspora (MoAD) and Black History Month trivia/happy hour offered a blend of cultural enrichment and fun. In Seattle, we enjoyed a soul food lunch while learning about the remarkable inventions from Black Americans, highlighting the ingenuity and creativity that has shaped our world. The Northeast and Southeast led a benefits education event, empowering our Associates to better understand and utilize their Lockton benefits. This initiative underscored our commitment to supporting the wellbeing and professional growth of our team members. The Southeast hosted a happy hour where they highlighted Black-owned wineries and distilleries, including Kumusha, Viarae, House of Brown, Chaos Theory, Seven Daughters, Teremana Tequila, Uncle Nearest Premium Whiskey, Mocktail Club and Theopolis Vineyards. Associates had a great time learning about each company and trying new beverages. In Texas, Houston enjoyed a delightful lunch at Lucille's and a tour of the Houston Museum of African American Culture, immersing themselves in the rich cultural heritage of the Black community. Meanwhile, Dallas and Plano hosted trivia and lunch events, creating opportunities for learning and connection. Black History Month 2025 has been a powerful reminder of the strength that comes from embracing diversity and fostering an inclusive environment. As we move forward, we remain committed to celebrating and uplifting the voices and contributions of the Black community, not just during Black History Month but every month of the year.
Life at Lockton Article Header_Leanna Mazzeffe

February 11, 2025

My career, my story:...
Leanna Mazzeffe has always had an eye for creativity, whether it’s shaping a brand’s story online or building a business with her family. At Lockton, she’s found a workplace that not only values her expertise but also encourages her to push boundaries and bring fresh ideas to the table while supporting her entrepreneurial journey outside of the office. Leanna’s career in social media began right after college, where she worked to help brands grow their presence online. Joining Lockton was a pivotal moment in her journey, giving her the chance to craft strategies that elevate Lockton’s voice in the industry. Now, as Senior Social Media Manager, she leads a team dedicated to making Lockton stand out as a trusted leader in the insurance industry. Alongside her work at Lockton, Leanna has built a successful business. Inspired by her family’s history of small business ownership, she founded Mazzeffe’s Screen Printing and Embroidery and later brought on a few family members to handle production. While they focus on bringing designs to life, Leanna works to grow the business and attract new clients. This allows her to build something that reflects her creativity in different ways! To Leanna, trust and support from leadership are what set Lockton apart from its competitors. “The entrepreneurial spirit here allows me to take risks, try new things, and have the freedom to create content that’s authentic to the brand.” This trust has empowered her to make bold decisions, helping her thrive in her role. Leanna has been inspired by the unique opportunities at Lockton to connect with colleagues across the globe. Attending a social media summit in New York City and traveling with the Elite Women Producers to Sedona and Austin have been key highlights, giving her the chance to deepen her expertise. “Collaborating with these incredible women has influenced me to become a strong female leader!” “Lockton’s culture is empowering, collaborative, and driven by a sense of purpose. It’s a place where you can make your mark, surrounded by people who genuinely want to see you succeed.” Leanna’s story is a testament to this supportive and inspiring environment.
Life at Lockton Article Header_Matt Chastain

February 5, 2025

My career, my story:...
Matt Chastain has called Lockton home since he began his career as an entry-level Benefits Analyst 10 years ago. He is now a Unit Manager in the St. Louis office. Matt attributes his growth over the last 10 years to strong mentors and leadership. “Leadership within our Series has always conveyed confidence, even as I developed mine. I’ve viewed my mistakes as learning opportunities and have become progressively more effective with each speedbump.”  Reflecting on his career, Matt highlights how Lockton’s culture fosters personal and professional development. He credits mentors like Jane Schmittgens, Tom Mitchell, and Sean Donlin for guiding him through pivotal moments and offering constructive feedback. “Lockton’s relationship culture creates an environment where mentors organically develop around us. It’s a very supportive environment for building a rewarding career,” he shared.  Matt has embraced the freedom to shape his team and its identity in his current role as Unit Manager. His vision is to create a supportive micro-environment that thrives on collaboration and drives new business. “That freedom to build our own brand continues to create excitement within the team, as well as opportunity and a tight-knit culture,” Matt explained.  Matt uses the words entrepreneurial and relationship-centric to describe Lockton’s culture. From relationships with our clients, to relationships with colleagues, all are important to our culture. “At Lockton I’ve felt emboldened to think outside the box in developing new strategies and efficiencies.”  A pivotal moment in Matt’s career came 2 years ago when he moved into the Account Executive role. “I immediately felt inspired to think boldly and creatively to produce positive outcomes for my clients. I enjoyed creating strong relationships with my clients and earning their trust.”  Over the years, Matt’s journey at Lockton has been shaped by the company’s unique environment, a blend of entrepreneurial spirit and relationship-driven values.  His experience is a testament to Lockton's opportunities for growth and success.