Technical BI Reporting Analyst X2 at Hollywoodbets

Job Description

Hollywoodbets has an exciting opportunity available for a Technical BI Reporting Analyst X2 to be based at the Team Support Office in Umhlanga, Durban. The Technical BI Reporting Analyst is responsible for analyzing the integrity of the data produced by the internally generated betting software and to implement controls, procedures and reconciliations to mitigate any financial losses to the business as a result of system related deficiencies in conjunction which implementing automation software within the Audits division. The role will work closely with the Group Financial Control Manager and Group Financial risk and Control Manager in the business to design, implement and analyses financial results through various reporting platforms.

Minimum Requirements:

• Relevant Diploma/Degree in Accounting/Audit and Computer Sciences
• Basic T-SQL and Report Writing Knowledge using SSRS and SSMS

Advantageous:

• Driver's License
• 1-2 years administrative experience
• 4 years Practical internal Auditing experience
• Pastel Evolution knowledge

Key responsibilities:

Reporting and Implementation

• Generate weekly/monthly betting tax reports supplied to customers and confirm that there are no discrepancies.
• Generate monthly balancing of the account (“BTA”), balancing of the cash (“BTC”) and balances reports (“BR”) supplied to the customer. Investigate variances derived from these reports and update the SQL reporting to eliminate these variances.
• Investigate and resolve monthly variances between the financial reports
• Review client betting accounts to identify discrepancies arising from the betting software deficiencies
• Build transformation layers for integrations into automated reconciliation software applications.
• Liase with third party software providers to implement automated reconciliation solutions.
• Work closely with the Business Intelligence team to create automated exception reporting for the monthly financial reports noted above, which can be supplied to management.
• Prepare trend analyses for the variances identified during the investigation of the above reports and software. Provide this analysis to the business to show the financial impact of these variances on the profit or loss of the business.
• Preparation of daily/weekly/monthly reports.
• Any other ad hoc tasks as requested.
• Generation of PowerBI dashboards for real time monitoring and reporting.
• Write scripts to manipulate data from applications such as SQL database tables and log files.
• Merges BI platforms with enterprise systems and applications.
• Ensure that all technical solutions that are rolled out consider compatibility with other environments and dependencies; have a high usability factor; are reliable to reduce time and perform at maximum efficiency during peak periods of usage; consider security at its highest level (third party attacks; data protection etc)
• Troubleshoots BI tools, systems, and software

Initiative and Innovation

• Implement improved processes that have a positive effect on the team’s performance and company bottom line.
• Technical problems and opportunities are anticipated and dealt with immediately considering any technical dependencies
• Take an active involvement in problem resolution and where necessary works after hours to ensure that problems are resolved
• Shows foresight to prevent errors or delays in projects.
• Demonstrate initiative by understanding, acquiring and implementing new knowledge and skills both within team and to the wider group
• Incorporates the new abilities into the day to day operational activities to improve performance of products and systems
• Ensure techniques, technologies, tools and processes used are in line with industry best practices

Skills and competencies:

• Strong communication skills.
• Excellent report writing and presentation skills
• High attention to detail
• Must be able to facilitate and train
• Must take accountability

Please note only applicants who meet the stipulated minimum requirements will be considered.