Data Analyst

The Financial Management Group has a unique opportunity for a Data Analyst with SQL expertise to work at the centre of our Corporate Data Hub, to help Macquarie make better data driven decisions and deliver a more informed, more agile Finance function.

**What impact will you have?**

As a Data Analyst, you will partner with a wide range of technical and non-technical stakeholders across Finance, Business and Technology teams to build our data and analytics capability. This is an excellent opportunity to develop your Business Analyst skillset in working to understand your stakeholders’ requirements, and translate these into data requirements, and vice-versa. You’ll join a growing and newly formed Data Quality team within our central Financial Management Group’s data modelling, data quality, and BI ‘Centre of Excellence’. Your key responsibilities will be to:

- Collaborate with business stakeholders, data engineers, database administrators, and data managers to onboard and embed data analytic tools
- Support strategic decision-making across the broader organisation by providing relevant data from the data warehouse
- Perform data remediation investigations and participate in testing activities such as data validations and unit / UAT testing
- Ongoing support of ad-hoc data queries and end-to-end data analysis
- Conduct reconciliation of data across systems to resolve discrepancies
- Escalate data quality issues and inconsistencies for assessment and remediation, supporting continuous data quality improvement across finance platforms
- Contribute ideas and participate in process improvement reviews

**What skills will you use?**

Additional to a strong interest in working in the banking and financial services industry, you will bring at least 1-2 years of hands-on experience using SQL in a data aligned role. You will also have:

- Strong stakeholder engagement/management experience with confidence in your ability to build relationships quickly, across all levels
- Excellent written and verbal communication skills, clear and concise
- Proficient in SQL, with experience/exposure in using traditional data bases like MS SQL Server or Teradata
- The ability to extract and transform data from multiple sources
- An understanding of data modelling and data warehouse concepts, data architecture principles, with exposure to big data architecture and platform solutions tools
- A degree in statistics, maths, data analytics, or similar
- Strong analytical skills and attention to detail to identify reoccurring issues, and an interest in solving interesting and complex problems

Having the below would be a bonus:

- Advanced Excel skills, Alteryx, PowerBi, or similar experience with other data tools
- Experience within the finance industry, and/or financial product knowledge
- An understanding of Enterprise Data Management and knowledge of data governance, data quality, and data risk management processes, tools, and concepts

**Want to apply?**

**About the Financial Management Group**

The Financial Management Group provides financial, tax and treasury services to all areas of Macquarie. The group is focused on providing strategic analysis and advice to Macquarie's businesses and senior management, managing Macquarie's funding, liquidity and capital position, ensuring Macquarie continues to meet regulatory and compliance obligations and managing Macquarie's corporate affairs.

**Our commitment to Diversity and Inclusion**

The diversity of our people is one of our greatest strengths, and in combination with our inclusive environment, it enables us to deliver innovative and sustainable outcomes for our people, clients, shareholders and communities. From day one, you'll be encouraged to be yourself and supported to perform at your best. If our purpose of ‘empowering people to innovate and invest for a better future’ is as inspiring to you as it is to us, please apply. With the right technology, support and resources, our people can work in a range of flexible ways.

Our team values diverse points of view, is action-oriented and energetic. We worked flexibly before Covid-19 and even more so now, and we are proud of our mix of locations, levels and backgrounds. We have a flexible approach to working underpinned by the commitment to deliver to a high standard for our Macquarie stakeholders.

**About Macquarie**:
A career at Macquarie means you’ll have the opportunity to develop and utilise new skills, explore interesting fields and do challenging work that will impact the lives of people around the world—whether it’s accelerating the green energy transition, helping sustain global food supplies, financing social housing projects or investing in essential infrastructure. At Macquarie, we’re empowering people to innovate and invest for a better future.

Our size and international presence means your work can take you anywhere—across business groups, disciplines, sectors and borders. With 19,200+ employees