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