Data Analyst (Power BI and SQL)

Data Analyst (Power BI and SQL)

Macquarie Group | melbourne, VIC, AU

Posted 16 days ago

Apply Now

Description

Our team focuses on evaluating, monitoring, and remediating cyber risk - making sure we protect what's important and have the data to prove it.

Bring your data analysis experience to the role, working on exciting technologies and challenging engineering problems.

As a Data Analyst, you will be responsible for collaborating with key stakeholders to help deliver relevant business insights. This will involve the whole data analysis lifecycle, from gathering requirements, business analysis, sourcing and exploring data, data cleansing, data modelling, and reporting and visualisation. Your role will focus on assisting in the development of new cybersecurity metrics used by Technology staff. This is a significant initiative, providing you with the opportunity to make a huge impact.

To excel in this role, you will be:

  • proficient in SQL and Power BI (including dataflows, Power Query M, and DAX)
  • hands on and able to develop and modify Alteryx workflows and troubleshoot performance issues
  • detail focused and proud of your sense of accuracy
  • excellent at stakeholder management
  • proactive and have great communication skills
  • a natural collaborator with a learning mindset, happy to share knowledge and learn from others
  • able to understand and translate technical requirements into non-technical language
  • able to document outcomes of business and data analysis in a clear and concise manner
  • highly proficient in data preparation and integration
  • Any of the following skills would also be desirable but not necessary:

  • experience with data warehousing and data modelling
  • familiarity with data architecture concepts and a good grasp of what a good architecture looks like
  • able to write Lambda functions or applications using Python or Go
  • experience with Splunk, S3, Spark, and AWS
  • Previous experience in cyber security data and metrics
  • About the Corporate Operations Group

    The Corporate Operations Group brings together specialist support services in Digital Transformation & Data, Technology, Operations, Human Resources, Business Services, Corporate Strategy & Solutions, and the Macquarie Group Foundation. We deliver service excellence to ensure Macquarie is open for business, deliver on transformational change, invest in our people and have deep relationships with our customers.

    Our commitment to Diversity, Equity and Inclusion 

    The diversity of our people is one of our greatest strengths. An inclusive and equitable environment 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.

    We are committed to providing a working environment that embraces and values diversity, equity and inclusion. We encourage candidates to speak with a member of our recruitment team if you require adjustments to our recruitment process to support you, and the type of working arrangements that would help you thrive.