Job Description

Senior BI Developer (1 year contract) (JB1334)
Parktown (Semi remote)
R85 000 – R100 000 CTC per Month 

The purpose of the role is to assist with the development of a scalable and reliable reporting solution. This includes supporting the overall architecture of the data warehouse, developing sustainable and efficient data models, and engaging reports and analyses for the business and brand partners.

Requirements:
6+ years’ experience as a BI Developer with 3 + years as a Senior/ Lead
Advanced T-SQL
Power BI Desktop / Service, Power Pivot, Power query & M
SSAS tabular data model design, optimisation and query using DAX
SSIS design and development of ETL workflows
Experience with data warehouse architecture and data modelling for reporting and analytics
Demonstrated experience in identifying opportunities for improvement and driving change
Ability to transform instructions from a data brief into accurate and relevant reports
Ability to drive positive change within an organisation by engaging stakeholders – this role will require extensive stakeholder engagement

Responsibilities:
Support customers’ digital journey via tracking and continuously optimising their interaction with our quoting tools and with the online Portal
Service the Business Units with regular and ad-hoc analysis to provide insights into relevant business drivers through regular interaction with business stakeholders
Conduct analyses and formulate reports to provide the business with accurate, relevant and timely tracking of the performance of the enterprise, with highlights & recommendations
Provide historical analysis and trend forecasts on the main drivers of the business such as claims, service, sales, cancellations, and product performance
Support the completion of projects from a reporting perspective
Ensure that the new brand partners have the minimum setup to allow brand reporting and sales/cancellations tracking
Ensure the specification and correct execution of reporting requirements for the introduction of new brand partners and for continuous tracking of all partners
Support proactive data driven marketing activities to drive sales and reduce attrition by providing relevant actionable insights
Contribute to the information inventory and build new data marts by delivering new variables and measures to improve the accuracy of analytical models
Create reliable and scalable reporting foundations that allows the Business to grow by timely identifying potential revenue leakages, reduction of risk, service improvement and identification of opportunities to evolve via predictive analytics

Start time is 7am as the role reports into Australia

Skills Required