Macquarie Technology Group

Business Intelligence Analyst

Macquarie Technology Group

full-time

Posted on:

Origin:  • 🇦🇺 Australia

Visit company website
AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

ETLJavaScriptPythonSQL

About the role

  • Management and administration of commission plans, including running calculations, exceptions, targeting, reporting/analysis and payments.
  • Build controls and processes to maintain our BI framework using developer resources
  • Design, develop, and maintain reports and analytical tools
  • Provide technical support for existing reports, dashboards, or other tools
  • Work with our BI suppliers and developers to plan and build our BI Framework to best serve our business.
  • Perform ongoing monitoring and refinement of reports
  • Timely and accurate input into the monthly executive and board reports
  • Identify and analyse errors and inconsistencies in the data and provide timely resolutions
  • Advocate for the use of business intelligence tools across the organisation
  • Partner with stakeholders, process specialists, and users to elicit and document business requirements
  • Partner with business teams to define and document business requirements for new metrics and reports
  • Create written communication materials that effectively summarize findings and support recommendations
  • Create reports and views on a frequent basis to assist management in understanding, researching, and analysing issues

Requirements

  • Bachelor's degree in a related field
  • 5+ years of experience in business analytics i.e. DAX, Power Query, star schema dimensional modelling, Row Level Security (RLS), workspace governance, DAX performance tuning.
  • 5+ years writing SQL queries, views, complex stored procedures, functions, indexing strategies, performance tuning, query optimisation, and ETL orchestration
  • Expert SQL Server and Power BI skills
  • Experience in scripting languages such as Python or JavaScript is desirable
  • Exceptional communication and presentation skills