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
These cookies are necessary for the website to function and cannot be turned off in our systems. You can set your browser to block these cookies, but then some parts of the website might not work.
Security
User experience
Target group oriented cookies
These cookies are set through our website by our advertising partners. They may be used by these companies to profile your interests and show you relevant advertising elsewhere.
Google Analytics
Google Ads
We use cookies
🍪
Our website uses cookies and similar technologies to personalize content, optimize the user experience and to indvidualize and evaluate advertising. By clicking Okay or activating an option in the cookie settings, you agree to this.
The best remote jobs via email
Join 5'000+ people getting weekly alerts with remote jobs!
