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 careers@ajg.com.au
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.