Data Analyst

As part of the Projects & Change team, you will play a crucial role in analysing the impact of projects and changes within the Insurance Broker Accounting (IBA) department. By leveraging advanced data and analytics, you will gain a comprehensive overview of the operational landscape. This will enable data-driven decision-making, the recognition of business problems, and the identification of process inefficiencies across Operations. You'll find a culture grounded in teamwork, guided by integrity, and fuelled by a shared commitment to doing the right thing. We value curiosity, celebrate new ideas, and empower you to take ownership of your career while making a meaningful impact on the businesses we serve. If you're ready to bring your unique perspective to a place where your work truly matters, think of Gallagher., * Gather, interpret, and analyse business data from multiple sources to provide insights and recommendations to collaborators.

• Develop and maintain databases and data systems, ensuring data quality and integrity.
• Design, develop, and sustain comprehensive reports and visualisations to communicate findings effectively.
• Recognize trends and patterns in data to offer actionable insights that support strategic decision-making.
• Assist in the design and implementation of data-driven decision-making processes within the organisation.

Operational Business Analysis and Process Excellence

• Recognise and understand the business problem and primary objectives of new projects, challenging objectives and scope where necessary.
• Analyse business needs by collaborating with partners to gather and document business requirements, ensuring clarity and understanding.
• Create functional requirements, coordinate walk-throughs and sign-offs, ensuring the models accurately match business needs.
• Prepare detailed descriptions of requirements, workflows, and results to improve communication between business and technical units. Guarantee that the documentation supports the efficient adaptation of these into solution requirements.
• Identify inefficiencies in workflows or systems and propose solutions to optimise business processes, including removing waste and consistent ways of working.
• Construct clear process maps and flowcharts to depict ongoing processes and uncover possibilities for optimisation.
• Develop and apply strategies using methodologies such as Lean to promote process improvements and foster a culture of continuous enhancement.
• Plan, design and deliver the handover of business processes to the functional owner in a way that allows for continuous improvement.
• Design and support the management of User Acceptance Testing, providing input into the resolution of any fixes.
• Provide training and support to employees involved in newly optimised processes.
• Maintain detailed accounts of process refinements and the procedures involved.
• Act as a liaison between business collaborators and technical teams, ensuring smooth communication and clear understanding of project objectives.

General Tasks

• Participate in testing and validating new systems and processes to meet business requirements and contribute to ongoing optimisation efforts.
• Participate in special projects as assigned by management, contributing analytical support and insights.
• Work closely with PMs and Change team across a variety of projects where required.
• Collaborate with management and cross-functional teams to prioritise business and information needs and suggest solutions to business challenges.
• Support wider M&A projects to ensure all the data and business needs are captured and prioritised.

Compliance

• Ensure we are operating within AJG policies & procedures, and any external regulations on all items.
• Align with the AJG Professional Standards Manual according to statutory requirements for the role, paying particular attention to, but not limited to, Whistle Blowing and Treating Customers Fairly.
• Perform tasks by adhering to internal policies and procedures while respecting applicable laws, rules, regulations, and good governance. Gallagher's shared values guide us, with clients at the core of our business.

Do you have experience in SQL?, * Proven experience working as a Data Analyst.

• Experience in a regulated Financial Services setting is preferred.
• Experience of using data to aid decision support.
• Data integration experience is desirable.
• Strong problem-solving skills to discover ways to improve data processes and boost efficiency.
• Proven ability in working with data warehouses.
• Understand business process maps, as is and to be etc
• Requirements elicitation, fit/gap analysis and preparation of functional design documents.
• Experience recognising chances to improve processes and systems.
• Strong knowledge of data analytics tools (e.g., SQL, Excel, Python) and statistical methodologies.
• Ability to interpret complex data sets and provide actionable insights to non-technical collaborators.
• Expertise in Power BI report building and visualisation.
• Strong data extraction and manipulation skills (Power Query, DAX).
• Excellent verbal and written communication skills to convey findings and recommendations clearly.
• Demonstrated practical experience as a data analyst, with a strong grasp of business operations and analytics.
• Good understanding and working knowledge of Microsoft Excel, Word, Outlook.
• Ability to analyse complex data and derive actionable insights.
• Confidently manage and sustain key relationship networks within a project environment.
• Excellent interpersonal skills, outstanding presentation of business and options analysis.
• Strong focus on accuracy and ease in managing extensive datasets.
• Experience collaborating within matrix teams spanning several offices, including external suppliers.
• Both commercial and customer minded - able to perform analysis that delivers customer and outcome-focused solutions.
• Excellent communication and presentation skills.
• Strong problem-solving and critical thinking abilities.
• Deadline driven, setting priorities to achieve time-bound outcomes. Lead and motivate others through good people management skills, a creative problem-solver with an ambitious, can-do attitude.
• Experience participating in a Finance Transformation program is desirable.
• Experience in a regulated Financial Services setting is preferred.
• Pro-active, solution-focused.
• Willingness to collaborate within the team - learning from others as well as sharing own findings.
• Highly driven and self-starters needed.
• Outstanding focus on accuracy.
• Experience in conflict management.
• Multi-tasking and planning.
• Ability to prioritise workload and plan ahead.
• Experience of operating to strict deadlines.
• Eligibility to work in the UK

On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits.

Below are the minimum core benefits you'll get, depending on your job level these benefits may improve:

• Minimum of 25 days holiday, plus bank holidays, and the option to 'buy' extra days
• Defined contribution pension scheme, which Gallagher will also contribute to
• Life insurance, which will pay 4x your basic annual salary, which you can top-up to 10x
• Income protection, we'll cover up to 50% of your annual income, with options to top up
• Health cash plan or Private medical insurance

Other benefits include:

• Three fully paid volunteering days per year
• Employee Stock Purchase plan, offering company shares at a discount
• Share incentive plan, HMRC approved, tax effective, stock purchase plan
• Critical illness cover
• Discounted gym membership, with over 3,000 gyms nationally
• Season ticket loan
• Access to a discounted voucher portal to save money on your weekly shop or next big purchase
• Emergency back-up family care
• And many more…

At Gallagher, we help clients face risk with confidence because we believe that when businesses are protected, they're free to grow, lead, and innovate., Inclusion and diversity (I&D) is a core part of our business, and it's embedded into the fabric of our organisation. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work. Gallagher embraces our employees' diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest. Gallagher is Disability Confident Committed. We have pledged to make sure our recruitment process is inclusive and accessible, in addition to supporting our existing employees with any long-term health conditions or disabilities. We understand that applicants may have disabilities, if you do, you may find some parts of the recruitment process more challenging than others. Don't worry, we're here to help, however, we can only do this if you let us know. Should you require reasonable adjustments to your application, please get in touch with TAGlobalSupport@ajg.com . If you'd prefer to speak on the phone, please request a call back, leaving details, so we get in touch. Our employing entity, Arthur J. Gallagher Services (UK) Limited, is proud to be accredited as a Living Wage employer with the Living Wage Foundation. We are committed to diversity and opportunity for all and are opposed to any form of less favourable treatment on the grounds of gender or gender identity, marital status, civil partnership status, parental status, race, ethnicity, colour, nationality, disability, sexual orientation, religion/ belief, age and those with caring responsibilities. Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as "protected characteristics") by applicable federal, state, or local laws. Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.   You must create an Indeed account before continuing to the company website to apply