Senior BI Developer

Location Icon

Kansas City, Missouri, United States of America

Bag Icon

Business Development

Profile Icon

2501N5

Apply now

Senior BI Developer

Location Icon

Kansas City, Missouri, United States of America

Bag Icon

Business Development

Profile Icon

2501N5

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.

JobSummary Icon

About the Position

Lockton is a global professional services firm with 6,500 Associates who advise clients on protecting their people, property and reputations. Lockton has grown to become the world's largest privately held, independent insurance broker by helping clients achieve their business objectives. To see the latest insights from Lockton's experts, check Lockton Market Update.

A few of the reasons Associates love working at Lockton include:

  • Opportunities for growth and advancement, including paid training and professional development
  • 12-week paid parental leave
  • A huge emphasis on community involvement
  • Frequent athletic and wellness events
  • Incredibly generous rewards; US Associates receive a Rolex for their 10 year anniversary!
Business unit

Lockton Management, LLC

Schedule

Full-time

Lockton Benefits Offerings

Click Here

Workplace

Hybrid

Responsibility Icon

Your Responsibilities

Product Development & Enhancement: Lead the end-to-end development of advanced BI products using Power BI. Go beyond standard dashboards to create professional, user-friendly applications with robust features. This includes integrating new data sources, creating complex UI/UX designs, and building interactive, data-driven solutions.


Performance Optimization & Efficiency: Proactively identify and resolve performance bottlenecks in existing and new data models and reports. Utilize DAX, M, and other Power BI tools to optimize model efficiency and ensure quick load times, providing users with a fast and seamless experience.


Operational Support & Incident Management: Serve as the primary technical contact for all operational issues related to our BI products. Triage incoming requests for report or application failures, identify the root cause, and coordinate with the appropriate teams (e.g., data engineering, IT, or business stakeholders) to ensure timely resolution.


Technical Troubleshooting: Diagnose and resolve technical issues within our BI ecosystem. This includes troubleshooting data refresh failures, gateway errors, user access problems, and connectivity issues.


Power BI Governance & Administration: Manage and maintain the security and access of our Power BI environment. Implement and enforce governance best practices, manage user permissions, and ensure the integrity and security of our data products.


Advanced Integration: Design and develop solutions that integrate Power BI with other platforms, such as Databricks. This includes working with the engineering team to build custom applications that allow users to interact with Databricks Genie and Power BI together, trigger notebook runs, or refresh data from within a Power BI report.


Mentorship & Collaboration: Work closely with the existing BI team, providing technical guidance and sharing best practices in product development and operational support. Collaborate with business analysts to understand requirements and translate them into robust technical solutions.

Qualification Icon

Qualifications

•    Proven experience as a BI Developer with a focus on building production-level data products, not just one-off dashboards.
•    Deep expertise in Power BI Desktop, Power BI Service, and Power BI Administration.
•    Strong proficiency in DAX and Power Query (M) for data modeling and optimization.
•    Strong data modeling skills, with a deep understanding of dimensional modeling (star and snowflake schemas) and their practical application in a BI environment.
•    Experience with Power BI APIs and tools for automation and integration (e.g., Power Automate).
•    Demonstrated ability to troubleshoot and resolve complex technical issues in a BI environment.
•    Strong proficiency in SQL.
•    Familiarity with data governance and security best practices.
•    5+ years of BI development experience.
•    Bachelor's degree in a relevant field.


Preferred Qualifications:
•    Experience with Databricks and its integration with Power BI.
•    Demonstrated interest or experience in leveraging AI tools for self-service analytics, empowering business users to query data using natural language.
•    Experience with other BI tools or platforms is a plus.

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

Life at Lockton

Life at Lockton Article Header_Seramount Best 100

September 15, 2025

Lockton Recognized a...
Lockton is proud to be recognized by Seramount as one of the 100 Best Companies for 2025, an honor that reflects our commitment to supporting working parents and fostering a family-friendly culture. This marks our first appearance on the list, which evaluates companies based on benefits, flexibility, and career support for employees balancing work and family life. “Our people are our greatest asset,” said Stephanie Robinson, Lockton’s Chief Diversity Officer. “We’re intentional about creating an inclusive, forward-thinking environment where Associates—especially those who are parents—can grow professionally while enjoying meaningful time with their families.” Comprehensive Support for Growing Families We are committed to supporting Associates as they grow their families – no matter how. We offer generous paid parental leave for birth, adoption, or surrogacy, along with adoption reimbursement. We also partner with a leading family health platform that provides 24/7 virtual care, fertility support, and personalized guidance to help Associates navigate every stage of their family journey. Helping Parents Return to Work with Confidence We support new parents with benefits that ease the transition back to work. Nursing mothers who travel have access to breast milk shipping services, and all Associates can access caregiver resources and work with their managers to create flexible schedules that support both personal and professional goals. Supporting Parents as They Grow Their Careers We believe parenthood should never be a barrier to professional growth. That’s why we offer continued support for parents returning to the workplace. Our Families@Work Associate Resource Group provides a strong community, helpful resources, and peer support to help parents navigate work-life balance. We also offer mentorship opportunities to ensure parents feel empowered in their careers and supported in their development. Lockton is proud to be recognized among those setting the standard for inclusive and supportive workplaces. If you're seeking a company that values balance, flexibility, and personal growth, Lockton could be the right fit for you.
Life at Lockton Article Header_2025 BPTW Insurance

September 1, 2025

Lockton Named a Best...
We've done it again! For the 17th consecutive year, Lockton has been named one of the Best Places to Work in Insurance. This recognition reflects our ongoing commitment to creating a workplace where Associates feel empowered, supported, and inspired to thrive personally and professionally. As a family-owned company, our independence allows us to invest in what matters most: our people. Our award-winning culture is built on inclusion, wellness, growth, and purpose, and it's shaped every day by our incredible Associates and leadership. From generous benefits to long-term career development, Lockton fosters a stable, innovative, and people-first environment. A culture of empowerment and inclusion Whether you're just starting your career or are a seasoned professional, we provide the tools and support to help you grow—professionally and personally. Our culture is rooted in authenticity, inclusion, and empowerment. Associates are encouraged to bring their whole selves to work, and the company actively supports this through Associate Resource Groups, DEI Councils, and inclusive leadership initiatives. Making a real impact Our people-centered culture shines through in the everyday experiences of our Associates. Whether through volunteering initiatives, mentorship programs, or leadership development, we encourage our people to pursue purpose alongside performance. Our commitment to impact goes beyond business—it's about creating space for individuals to thrive and give back in ways that matter most to them. Work-life balance and best-in-class benefits We understand that life doesn't stop when work begins. With flexible work arrangements, industry-leading health insurance, wellness programs, and a strong emphasis on mental health, we ensure that Associates can maintain a healthy balance. Career growth and development From early career programs to leadership development, we invest heavily in our people. Associates have access to professional training, mentorship, and global opportunities across more than 140 offices worldwide. The entrepreneurial spirit at Lockton means our people are empowered to innovate, lead, and make a real impact. Join a company that puts people first If you're looking for a workplace that values your voice, supports your growth, and celebrates your individuality, look no further. Explore opportunities and discover what makes life at Lockton so special. About Best Places to Work Best Places to Work in Insurance, an annual feature presented by Business Insurance and Best Companies Group, lists the agents, brokers, insurance companies, and other providers with the highest employee engagement and satisfaction levels. Best Companies Group identifies the leading employers in the insurance industry by conducting a free two-part assessment of each company. The first part is a questionnaire completed by the employer about company policies, practices, and demographics. The second part is a confidential employee survey on engagement and satisfaction.
Life at Lockton Article Header_2025 US News Report BPTW

July 8, 2025

Lockton recognized a...
Lockton is proud to announce that we have been named one of the 2025-26 Best Companies to Work For by U.S. News & World Report. This recognition celebrates our unwavering commitment to building a workplace where our people thrive. In addition to this honor, Lockton has also been recognized as one of the best companies in the Finance and Insurance division. At Lockton, our people are the heart of everything we do. We empower our Associates to lead with purpose, support one another, and make a difference in our communities. With industry-leading benefits and a culture of trust, we’re proud to support our team and their families through every stage of life. As a privately held company, we reinvest in what matters most: our people and our future. That means more innovation, more stability, and more opportunities to grow. Learn more about your experience at Lockton. U.S. News & World Report bases its rankings on what truly counts: employee sentiment around pay and benefits, work-life balance, professional development, and overall well-being. To qualify, companies must be privately held, employ over 5,000 people, and generate more than $500 million in annual revenue. Click here to view the full list.
Life at Lockton Article Header_Lauren Dunham

June 23, 2025

Leading with Heart: ...
For 17 years, Lauren Dunham has been a force for connection and change at Lockton. She first discovered commercial insurance at a career fair, not knowing what to expect. “Most people think of Jake from State Farm—but what we do is so much more,” she says. “We help clients drive real change in their businesses, and that has a ripple effect.” Lauren’s impact at Lockton was immediate. She quickly rose from Associate Account Manager to her current role as Senior Vice President, Director of Client Engagement. Alongside her professional growth, Lauren’s personal journey of service began with her involvement in Women in Leadership (now Women in Lockton)—a group dedicated to driving business success while fostering a supportive, inclusive environment where everyone, especially women, can thrive. It was through this group that she formed a close friendship with Lisa Wall, who would later open the door to a new chapter of impact. When Lisa asked if she’d consider stepping into her role with Women United, Lauren didn’t hesitate. “I jumped at the opportunity,” she recalls. “Women United focuses on early childhood development—something that holds a special place in my heart.” Her passion for education and early childhood development runs deep. Her mother, a longtime elementary school teacher, exposed her early to the challenges many children face—hunger, instability, and lack of support. “I remember going to work with her and seeing the impact she tried to make. That stuck with me.” Now as a mother herself, Lauren understands how critical the first five years are in shaping a child’s future. “Unfortunately, there’s just no consistent infrastructure in our city to support children in those early years.” Now a board member of Women United, Lauren helps lead fundraising and volunteer efforts that directly support early childhood nonprofits. From wrapping gifts for young mothers in shelters to raising over $100,000 through events like Purses for Promise, the work is hands-on, heartfelt, and deeply fulfilling. “It’s about connecting women who want to make a difference and giving them the tools to do it.” Lockton’s support of Lauren has been unwavering. “We get two full days to volunteer, and Lockton matches donations. It’s part of our DNA—clients, community, Associates. That’s how we operate.” She recalls moments like a 2010 tornado, where the company’s culture of care was on full display. “It’s always been part of the experience here. From the top down, people understand the importance of giving back.” When asked why she’s stayed at Lockton for nearly two decades, Lauren’s answer is simple: “The people.” “You can love the technical side of your job, but if you don’t enjoy the people you work with, it won’t matter. At Lockton, the people are what make it special. You feel it in every interaction.” For Lauren, Women United and Lockton are two sides of the same coin—places where passion meets purpose, and where people come together to make a difference. “Lockton is great. Women United is great. I’m fortunate I get to support both.”