Bi & Data Integration Analyst

Job Description:
Introduction
Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a legacy of trust and triumph in the dynamic world of risk management.
We believe that every candidate brings something special to the table, including you! So, even if you feel that you’re close but not an exact match, we encourage you to apply.
Overview
Gallagher is a global leader in Insurance broking, risk management and consulting, with over 39,000 employees worldwide in over 130 countries. We have a global reach with a local presence and pride ourselves on being a socially responsible and an ethical organisation expressed through our Shared Values, The Gallagher Way. We are proud to have been awarded, for the 13th consecutive year, the 2023 World’s Most Ethical Companies by Ethisphere Institute (2023) as well as being one of Insurance Business Australia Top Insurance Employers and Forbes Best Employer for Women.
What is the role?
We are seeking a BI and Data Integration Analyst to develop and maintain reporting, budget and analysis solutions for the Gallagher national business.
Key accountabilities include:

• Support the business intelligence platform and related reporting technologies
• Maintain the data load and integration platform and processes
• Develop reports and data loads of high consistency and accuracy
• Seek and propose new solutions and approaches to meet the reporting, budget and analysis needs of the Gallagher national business
• Support business improvements and change initiatives and projects
• Manage the team support queue

What are we looking for?

• Tertiary qualifications in IT, Business, Finance
• Strong knowledge of Transactional SQL, Microsoft SQL Server 14, and Oracle SQL
• Required DWH experience and Microsoft stack
• ETL development SSIS
• Report building SSRS & mobile reporting; Power BI, DAX
• Data modelling – SSAS
• Visual Studio SSDT
• Source control applications TFS, GIT etc.
• Experience in scripting in python powershell and attunity connector desirable
• Experience in finance / insurance industry looked upon favourably

Gallagher Benefits – we offer great benefits and career development opportunities including tuition assistance; career development and training to build a personalised career pathway; wellbeing offerings; employee assistance program; additional weeks’ Lifestyle leave; Gallagher Rewards for discounts at 350+ major retailers; Employee Stock Purchase Plan to invest in the company's growth potential; paid Volunteering days; and salary scarified superannuation options.
Apply now via our careers website, https://www.ajg.com/au/about-us/careers/ or for further information, please contact our Talent Acquisition team at
Any offer of employment and subsequent continuing employment is dependent upon the satisfactory completion of background checks by Gallagher or by an external third party provider.
Gallagher is an Equal Employment Opportunity (EEO) employer committed to the principles of workplace diversity and inclusion. We welcome all people regardless of ethnicity, faith, sexual orientation, gender identity and lifestyle choices. We are committed to providing a working environment that embraces and values diversity, equity and inclusion.