The Business Intelligence Analyst provides support for BI activities, manages commission plans, develops reports, monitors data inconsistencies, and collaborates with stakeholders to document business requirements.
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.
Top Skills
Dax
JavaScript
Power BI
Power Query
Python
SQL
SQL Server
Similar Jobs
Consumer Web
Analyze sales performance and create Power BI dashboards to provide insights, improve sales activity, and educate the sales organization on commission models.
Top Skills:
DaxPower BIPower Query
Financial Services
The BI Support Analyst role involves developing and maintaining BI solutions, translating business requirements into reporting solutions, and collaborating with stakeholders to ensure data accuracy and accessibility.
Top Skills:
DbtMicrosoft Power BiSnowflakeSQL
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
The Seller Onboarding Specialist guides Australian merchants through the onboarding process, ensuring they leverage Square's platform effectively while managing multiple projects and improving offerings.
Top Skills:
PaymentsPosSoftware
What you need to know about the Melbourne Tech Scene
Home to 650 biotech companies, 10 major research institutes and nine universities, Melbourne is among one of the top cities for biotech. In fact, some of the greatest medical advancements were conceptualized and developed here, including Symex Lab's "lab-on-a-chip" solution that monitors hormones to predict ovulation for conception, and Denteric's vaccine for periodontal gum disease. Yet, the thousands of people working in the city's healthtech sector are just getting started, to say nothing of the tech advancements across all other sectors.
