Mid-level Data Analyst – Power BI & SQL

About the role

The Data Analyst will join the Tech & Data function in Johannesburg, supporting a technology‑driven financial services business. Reporting to the Tech & Data Team Lead, the role focuses on delivering trusted reporting and turning complex operational and financial data into clear insights for decision‑making.

Key responsibilities

• Build and maintain high‑quality Power BI dashboards and reports for executives, operations, finance, sales, credit/risk and procurement.
• Write SQL queries to extract, clean, join, aggregate and analyse data from source systems such as PostgreSQL and Microsoft SQL Server.
• Investigate trends, patterns, anomalies and bottlenecks, explaining their commercial relevance.
• Produce concise insight notes and analysis packs with findings and recommended actions for leadership and operational teams.
• Prepare reusable, well‑structured datasets for reporting and decision support across the organisation.
• Identify data‑quality issues (gaps, inconsistencies, missing values, duplicates) and work with technical teams to resolve them at source.
• Improve the structure, reliability and performance of reporting datasets and analytical queries over time.
• Use approved Claude‑based AI tools to accelerate SQL/reporting development, summarise findings and support documentation, validating all outputs.

Required profile

• Strong SQL capability, including complex queries, joins and data‑quality diagnostics.
• Proven experience building decision‑focused dashboards with Power BI or a comparable BI tool.
• Solid data‑analysis skills with the ability to spot patterns, trends and commercial implications.
• Understanding of data modelling, entity relationships, metrics and reporting models.
• Advanced Excel proficiency for analysis and reconciliations.
• Ability to communicate technical findings clearly to non‑technical stakeholders.
• Practical experience using AI tools responsibly to speed up analysis and documentation.

Required skills

• SQL
• Power BI
• PostgreSQL
• Microsoft SQL Server
• Microsoft Excel
• Claude‑based AI tools
• Power Platform (Dataverse, Power Apps, Power Automate)