Data Analyst

Samaha Consulting; Johannesburg; Hybrid; ZAR 600 000 - 800 000; Full time

Job summary

A consulting firm in Johannesburg is seeking a Senior Data Consultant to enhance corporate banking data practices. The role focuses on designing scalable data processes and requires expertise in SQL, Power BI, and other data tools. Ideal candidates will be proactive, professional, and able to communicate effectively with stakeholders. The position emphasizes analytical skills and the ability to interpret complex data to drive business improvements. The working model is four days in-office and one day remote.

Benefits

Flexible working arrangements

Agile work environment

Qualifications

• Hands-on experience with SQL and query languages for data extraction.
• Proficiency in Power BI and Fabric for developing reports and dashboards.
• Experience with Cloud Data Engineering tools like Databricks.

Responsibilities

• Design and build scalable data processes.
• Act as a trusted partner providing transparent communication.
• Own the report lifecycle, ensuring relevance and value.

Skills

Power BI

SQL

Power Platform

Databricks

Data Factory

AI techniques

Microsoft Excel

Job description

Role

This is a senior individual contributor role focused on advanced technical expertise and independent delivery. The role does not include people management responsibilities.

Core Purpose

Provide technical, analytical and strategic insight to support the development of robust data practices, streamlined processes, and intelligent automation within the corporate Banking team.

Skills and tools

The ideal candidates will have hands on experience with:

• Data: Power BI (Fabric), SQL. Data bricks, Data Factory.
• Tech: Power Platform (Power Automate, Power Apps)
• AI: GPT bases AI agent (Copilot studios, Chat GPT AI agents etc).

Key responsibilities

• Design and build scalable data processes that extract, transform, and visualise information using Power BI/Fabric, Dataflows, Databricks and Data Factory.
• Act as a trusted partner to stakeholders, providing transparent communication and managing expectations throughout project lifecycles.
• Own the report lifecycle, including:
• Applying change control and documentation standards
• Monitoring and resolving report failures
• Reviewing usage to ensure reports remain relevant and valuable
• Comfortable owning solutions with minimal oversight, including scoping, technical design, development, testing and deployment
• Capture non-strategic data elements manually where required, while proactively identifying long-term strategic solutions with internal technology teams.
• Collaborate closely with the Lending Data team to source and integrate data from the One Data Platform (ODP) and shared lending data infrastructure.
• Identify data sources not yet in ODP, working with the lending team to bring them into the strategic data ecosystem.
• Work with Data Governance to define and maintain critical data elements for the Real Estate business, ensuring accurate recording, monitoring and adherence to data-quality standards.

Technical knowledge

• SQL: Proficient in SQL and other query languages used for data extraction and manipulation.
• Power BI / Fabric: Strong proficiency in developing data models, reports, dashboards and end-to-end Fabric solutions.
• Power Platform: Experience with Copilot Studio, Power Automate, and Power Apps.
• Azure Data Tools: Practical experience with Databricks, Data Factory and related cloud data engineering components. Good to have
• Microsoft Excel: Excellent working knowledge, including advanced functions and data analysis techniques.

Skills

• Analytical Insight: Exceptionally numerate with the ability to interpret data, identify trends, and clearly articulate insights that drive business action.
• Stakeholder Engagement: Able to quickly distil stakeholder questions into clear analytical requirements and deliver timely, actionable outputs in an accessible format.
• Communication & Influence: Excellent written and verbal communication skills, able to adapt style and messaging for different audiences and stakeholders.
• Project Management: Strong ability to self-manage research, design solutions, prioritise work, and deliver projects efficiently and independently.
• Adaptability: Willingness and ability to rapidly learn new tools, technologies and methodologies.
• Data Storytelling & Visualisation: Ability to design engaging, interactive dashboards and outputs that translate data into meaningful stories.

Personal attributes

• Demonstrates professionalism and integrity in all interactions.
• Proactive and self-motivated, with the initiative and commitment to see projects through to completion.
• Comfortable working in ambiguity and able to find structure within it.
• Resilient and persistent, willing to iterate and learn from setbacks.
• Dedicated to delivering high-quality work and ensuring stakeholders receive information in time to act.
• Analytical, curious and data-driven, with a natural inclination to question assumptions and seek clarity.
• Relationship-oriented, able to build strong, trusted partnerships across the Bank.
• Demonstrates impeccable attention to detail.
• Driven by continuous improvement, always looking for ways to enhance processes, tools and methods to create efficiencies or generate value.

As part of our collaborative & agile culture, our working week is 4 days in the office and one day remote.