Business Intelligence Analyst
Melbourne, VIC 3000
Telecom – Sales /
Permanent Full-time /
Hybrid
About Us
There’s something special about working for a company like Macquarie Telecom. We’re not the biggest in the industry, where you’re just a number. We’re not tiny enough that you’ve never heard of us. We’re in that sweet spot where we’re strong enough to punch above our weight. And we definitely do! Because of this, you have the opportunity to make a difference.
The business intelligence (BI) analyst provides analytical and technical support for business intelligence activities across Sales and Marketing. The responsibilities include the sales compensation process, designing and maintaining sales/marketing reports as well as building out new reporting suites and analytical models. Effectively, being the data intelligence arm of the Sales and Marketing teams, the analyst is also heavily involved with building the BI framework, data warehousing, and the distribution and successful delivery of BI reports.
What you'll be doing
- 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
Your ideal skills and experience
- 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
If you are interested to know more, please apply.
