MI Analyst | Lockton Careers

MI Analyst

London, United Kingdom

004076

Apply now

MI Analyst

London, United Kingdom

004076

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.

Schedule

Full Time Permanent

Job type

Experienced Professional

Workplace

Hybrid

Your Responsibilities

As Lockton’s continued investment in Data and MI the appetite for data is only increasing and is highly valued by senior management. As a result, we are looking to recruit the appropriate data individual to join the team.

First and foremost, the right candidate must fit in with Lockton’s culture. At Lockton we value the following principles:

- Client first

- Results and impact driven

- Self-motivated

- Continuous improvement

Role Responsibilities

· Partner with business stakeholders to gather, challenge, and translate reporting and analytics requirements.

· Extract, transform, analyse, and interpret data from multiple sources to support business decision-making.

· Design, develop, and maintain Power BI reports and semantic models.

· Write efficient, scalable SQL queries to support reporting.

· Deliver insights and recommendations that help stakeholders understand trends, performance, risks, and opportunities.

· Collaborate with technical and non-technical teams to promote a data-driven culture across the organisation.

Qualifications

We are seeking a proactive and analytical individual who enjoys solving complex data challenges and turning information into valuable business insight.

You will be comfortable working in a fast-paced environment where priorities can evolve quickly and will demonstrate the ability to manage multiple stakeholders and competing demands. A strong desire to learn, develop, and continuously improve is essential

Must have skills:

Power BI

· End-to-end development of Power BI solutions, including:

· Data ingestion and transformation (Power Query)

· Data modelling

· DAX development and optimisation

SQL & Data Analysis

· Strong SQL development skills, including query optimisation and troubleshooting.

· Solid understanding of relational database design and data modelling principles.

· Experience analysing large and complex datasets to identify trends and business opportunities.

Excel

· Advanced Excel skills, including:

o Power Query

o Power Pivot

o Complex formulas and modelling techniques

Preferred Skills:

· Experience working with Databricks in a modern data platform environment.

· Knowledge of dbt (Data Build Tool) for data transformation and modelling.

· Familiarity with cloud-based data platforms, particularly Microsoft Azure.

· Experience working with data engineering or ETL pipelines.

· Exposure to version control and collaborative development practices (e.g., Git/GitHub).

· Experience working within financial services, insurance, or other highly regulated industries.

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

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.“

Roof top solar installation with shenzhen downtown skyline view as background,China.

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.