Technical BI Reporting Analyst X2 at Hollywoodbets

You Bring:

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

Advantageous

•  Valid driver’s License
•  1-2 years administrative experience
•  4 years practical internal auditing experience
•  Pastel evolution knowledge

What You’ll Do for The Brand:

• 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

What You’ll Bring to The Team:

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