Junior Data Analyst
Finance
Finance
Full-time
Hybrid
Johannesburg
job description
As a Junior Data Analyst you will be responsible for generating reports, extracting/migrating data, managing data between environments and performing basic database administration tasks. As a Junior Data Analyst, you will receive requirements from stakeholders on an ad-hoc basis or be involved with larger projects within the BI team. You will ensure that the reports you provide to your stakeholders are accurate and identify which common report requests can be automated or added to PowerBI. You will be supported by, and take direction from, you senior team members.
EXPERIENCE
- 1 - 3 years Junior Data Engineer or similar experience.
- Understanding of SQL Server and RDMS.
- Understanding of Normalisation to 3NF.
- Experience writing queries in T-SQL.
- Understanding of Clustered and Non-Clustered indexes.
Advantageous Experience:
- Managing SQL Jobs.
- Creating and maintaining Stored Procedures and Functions.
- Using Query Execution Planner to optimise queries.
- Basic understanding of Database Administration
SKILLS & behavioural competencies
- Excellent Communicator (written & spoken)
- Self-Starter
- Analytical & Problem-solving
- Honesty & Integrity
- Accountable
- Perseverance and Tenacity
- Proactive
- Agile
- Team Player
Qualifications
- SQL Server
- T-SQL
- Proficiency in Power BI - report and dashboard development, DAX, and data modelling.
- Strong SQL skills - able to write, read and optimise queries independently.
- Advanced Excel including pivot tables, VLOOKUP/XLOOKUP, and dynamic formulas.
- Analytical mindset with keen attention to detail and a commitment to data accuracy.
- Ability to translate complex data into clear, visual narratives for nontechnical stakeholders.
- Degree in Statistics, Data Science, Information Systems, Finance, or a related field.
Advantageous Skills
- Experience in the iGaming, sports betting or technology sector.
- Familiarity with Python or R for data processing and analysis.
- Exposure to cloud data warehousing (Azure, BigQuery).
- Microsoft Power Platform experience (Power Automate, Power Apps).
- Experience working in a remote, multi-jurisdiction or international business environment.
Required Outputs
Development & Support
- Design, build and maintain Power BI dashboards and reports that provide real-time visibility into business performance across revenue, operations and partner activity.
- Produce recurring weekly, monthly and quarterly management reports, ensuring accuracy, consistency and clarity of presentation
- Extract, clean and transform data from multiple source systems (SQL databases, spreadsheets, APIs) to support analytical outputs.
- Analyse trends in player activity, revenue streams and market performance, presenting findings in a clear and actionable format for internal stakeholders.
- Identify and investigate data anomalies, discrepancies and quality issues, escalating where necessary and documenting resolutions.
- Maintain and document data models, report logic and dashboard definitions to ensure reporting is auditable and repeatable.
- Support ad hoc data requests from senior leadership and commercial teams, often under time pressure.
- Develop reports using T-SQL.
- Maintain and improve all existing reports.
- Participate in the code review process.
- Create/Maintain SQL Jobs.
- Create/Maintain Indexes.
- Investigate and resolve issues identified in existing reports.
- Troubleshoot and resolve performance issues.
Engage with stakeholders
- Ability to work as an effective team member, to work independently, and ability to work with clients when required.
- Maintain and manage positive relationships with internal and external stakeholders.
- Effectively communicate at all management levels with clients/ stakeholders.
- Make recommendations to improve client service within area of responsibility.
- Work closely with Finance, Commercial and Product teams to understand data requirements and deliver reporting solutions that meet business needs.
Self-management and teamwork
- Develop and maintain productive and collaborative working relationships with peers and stakeholders
- Positively influence and participate in change initiatives
- Continuously develop own expertise in terms of professional and industry knowledge
- Take ownership for driving career development.

