Role responsibilities

Data and reporting development, analysis and validation:

• Assisting in developing specifications for the BI teams to achieve and present the reporting requirements of the operational teams and management.
• Testing the developed specifications in the data warehouse against the required specifications and reporting, tracking and retesting fixes
• Deep detailed testing of data across the company platforms to ensure the data warehouse data is accurate and complete.
• Create visually compelling dashboards and reports that effectively communicate insights to stakeholders.
• Writing custom reports in the accounting package (Vantagepoint) using SQL and SSRS based on specifications.
• Stay current with industry trends and best practices in Power BI and analytics, driving continuous improvement and innovation.

Monthly analysis and reporting:

• Preparation of monthly reporting packages.
• Preparation of Group Wide reporting where automated solutions are being developed.
• Ad Hoc reporting and analysis as required that will add value to the business in decision-making.

Budgeting and forecasting:

• Preparation of data for the budgeting process or any forecasting processes.
• Assisting the operational teams with understanding and interpreting the data presented to complete coherent budgets/forecasts.

Minimum requirements

• BCom (Hons) Accounting Sciences/CA(SA)/CIMA qualification
• 3+ Years in a data and/or finance environment
• Power BI/Query (Including, but not limited to Ingestion, Modelling, Transformations and Cleansing, and DAX Expressions)
• SQL (writing queries) and SSRS (for writing reports) is advantageous
• Microsoft Excel – Advanced Skills

Skills, and characteristics (add if applicable)

• Detail and accuracy focused but with the ability to take a step back and assess data for reasonableness
• Deadline driven
• Strong ability in presenting technical reports in a user-friendly manner based on the collection, analysis and interpretation of data
• Strong technical and financial acumen
• Strong analytical and problem-solving skills, with the ability to translate complex data into actionable insights
• Excellent communication and collaboration skills, with experience working with cross-functional teams
• Strong problem-solving and analytical skills
• Excellent communication and collaboration abilities
• Strong attention to detail and data accuracy