Unlocking global talent: Revamping Lockton Companies Inc.’s careers site with Azure Data Factory and Azure Functions
ABOUT THE COMPANY
Lockton Companies Inc. (Lockton) is the largest privately held, independent insurance brokerage firm in the world. The Kansas City, Missouri-headquartered firm provides insurance, risk management, employee benefits, and retirement services from over 140 locations in 30 countries.
OPPORTUNITY: Modernizing Talent Management Data in Azure
How to get job vacancies from multiple sources around the world consolidated into a single, modernized careers site?
As the largest privately held insurance broker in the world, 27Global’s client had been experiencing steady year-over-year growth. To support their business and continue their growth trajectory, the client sought to hire top-level talent around the world and across their multiple lines of business.
Their recruiting processes and platforms were strong, but they identified many regions where they had siloed or duplicative processes which resulted in subpar experiences for applicants, as well as Lockton’s internal recruiters. Sometimes a single job vacancy would be listed on multiple sites, and candidates were applying in two places for the same job. Internally, their recruiters did not have good visibility or reporting on the candidate pipeline.
The client determined that they wanted to consolidate their recruiting efforts into a single, unified careers site that would serve all job seekers globally. They designed an enhanced front-end for the site, making the job search process faster and easier. However, there were two different source systems for the job listings that had different back-ends and data types. It was also unclear how they would be able to make the various job listings conform to the newly redesigned front end.
SOLUTION: Integrating Databases with Azure
27Global expertly engineered a comprehensive solution for job listing integration for the client. The process began with an in-depth analysis of various source systems, leading to the creation of a unified database schema. This schema was meticulously crafted to standardize and align data from diverse global regions.
Utilizing Azure Data Factory pipelines, 27Global skillfully managed data ingestion and transformation, ensuring seamless integration into the new system. The final step involved deploying an Azure Function to transmit the harmonized data to the front end, with Azure Application Insights rigorously monitoring the process for any discrepancies or errors.
RESULTS: Optimizing Talent Management Data in Azure
By analyzing and mapping diverse data sources, 27Global developed a unified database schema, integrating it with Azure Data Factory pipelines. This sophisticated solution transformed the recruitment experience, creating a singular, global platform for job seekers and recruiters alike. Our client’s commitment to attracting world-class talent is now reflected in their streamlined, globally accessible careers site, which is focused on the job seeker and represents a single, global database of jobs.
Thanks to the newly modernized applicant experience, our client was able to double down on their commitment to attract the best and brightest to their dynamic culture and growing company.
If you are facing a challenge that involves modernizing an existing site or consolidating and standardizing data from multiple source systems, 27Global can be an effective partner to help you achieve your business goals. Learn more about how we can help accelerate your business.
Adam Millican is a Denver-based Consulting Manager at 27Global. With more than a decade of IT and applications experience, his focus is designing and implementing tailored software solutions. When he’s not building software, Adam enjoys spending time with his wife and two cats, and training and competing in Olympic weightlifting.