SAP BW Consultant

Monocle Solutions Group; Sandton; On-site; ZAR 650,000 - 1,100,000; Full time

Benefits offered by this job

Unlimited training

Unparalleled growth

Vibrant culture

Competitive compensation

Job summary

Monocle Solutions Group is seeking an SAP BW Consultant to design, implement, and lead data warehousing and analytics projects for customers in the financial services sector. You will shape data models, ensure data quality, and deliver reporting capabilities across SAP landscapes.

You will collaborate with business and technical teams to translate requirements into scalable solutions, optimise performance, and support data governance initiatives while contributing to high-impact transformations

Qualifications

• 4–8+ years of experience in SAP BW/BW/4HANA within financial services (Banking/Insurance/Consulting) is beneficial.
• Hands-on experience in SAP BW data modelling (InfoObjects, ADSOs, Composite Providers, Open ODS Views).
• Proven experience with ETL processes and SAP data integration tools (e.g. SAP BW ETL, SAP Data Services, SLT).
• Experience working with SAP HANA and performance optimisation techniques.
• Exposure to reporting and analytics tools (e.g. SAP Analytics Cloud, BEx, Power BI, Tableau).
• Understanding of financial services data models and regulatory reporting requirements is beneficial.
• Bachelor's degree, with a strong preference for a postgraduate qualification. SAP certifications advantageous.
• Experience with data governance, data quality, and data architecture principles.
• ABAP coding or SQL is highly beneficial.

Responsibilities

• Design, develop, and maintain SAP BW/4HANA data models, including InfoProviders (ADSO, Composite Providers) and data flows.
• Build and optimize ETL processes using SAP BW tools and SAP Data Services or similar integration technologies.
• Develop and maintain SAP reporting solutions (e.g. BEx, SAP Analytics Cloud, Power BI integration).
• Collaborate with business stakeholders to gather and translate reporting and analytics requirements into technical specifications.
• Support data modelling activities, including schema design, data harmonisation, and performance optimisation.
• Ensure data accuracy, consistency, and completeness through validation, reconciliation, and testing processes.
• Contribute to data migration, integration, and transformation initiatives across SAP and non-SAP systems.
• Assist in implementing data governance, metadata management, and data lineage frameworks.
• Troubleshoot and resolve technical issues related to data loads, performance, and reporting outputs.
• Support system upgrades, enhancements, and migration initiatives (e.g. SAP BW to BDC transitions).
• Collaborate across project teams, including finance, risk, IT, and architecture, to ensure aligned and integrated solutions.
• Produce clear technical documentation, including data models, ETL logic, and reporting specifications.
• Participate in testing cycles (unit, SIT, UAT) and support business users during validation phases.
• Provide input into best practices and continuous improvement initiatives within the SAP data landscape.
• Stakeholder and client management.

Skills

SAP BW modelling

InfoObjects ADSO

ETL processes

SAP HANA

Reporting tools

Power BI

Tableau

SQL/ABAP

Open ODS

Education

Bachelor's degree in finance/IT

Postgraduate qualification

Tools

SAP BW ETL

SLT

SAP Data Services

SAP Analytics Cloud

BEx

Job description

Accelerate Your Career

At Monocle, we believe work is more than a job. It is a chance to make a difference in the world of finance. An opportunity to fulfil your potential. To make friendships with ambitious, positive, like-minded people. To gain invaluable industry experience and learn critical skills that will make you a highly sought-after management consultant.

Accelerate Your Career

Monocle is a people-centric, independent consulting firm, specialising in banking and insurance. We understand that our greatest asset is our people and because of this, we do things a bit differently.

Monocle is seeking a skilled and driven SAP BW Consultant to support and lead the design, development, and delivery of enterprise data warehousing and analytics solutions within the financial-services sector.

In this role, you will contribute to large-scale transformation initiatives by enabling robust data integration, reporting, and analytics capabilities across SAP landscapes.

You will play a key role in designing and implementing SAP BW related data solutions, ensuring that business-critical financial and operational data is accurate, accessible, and aligned with regulatory and reporting requirements. Leveraging your technical expertise and understanding of financial-services processes, you will support clients in building scalable, high-performance data platforms that enable data-driven decision making.

As an SAP BW Consultant, you will collaborate closely with business stakeholders, data engineers, and technical teams to translate complex requirements into effective data models and reporting solutions. Your work will directly contribute to enhancing data quality, governance, and analytics maturity across our client organisations.

Tasks and responsibilities

• Design, develop, and maintain SAP BW/4HANA data models, including InfoProviders (ADSO, Composite Providers) and data flows.
• Build and optimize ETL processes using SAP BW tools and SAP Data Services or similar integration technologies.
• Develop and maintain SAP reporting solutions (e.g. BEx, SAP Analytics Cloud, Power BI integration).
• Collaborate with business stakeholders to gather and translate reporting and analytics requirements into technical specifications.
• Support data modelling activities, including schema design, data harmonisation, and performance optimisation.
• Ensure data accuracy, consistency, and completeness through validation, reconciliation, and testing processes.
• Contribute to data migration, integration, and transformation initiatives across SAP and non-SAP systems.
• Assist in implementing data governance, metadata management, and data lineage frameworks.
• Troubleshoot and resolve technical issues related to data loads, performance, and reporting outputs.
• Support system upgrades, enhancements, and migration initiatives (e.g. SAP BW to BDC transitions).
• Collaborate across project teams, including finance, risk, IT, and architecture, to ensure aligned and integrated solutions.
• Produce clear technical documentation, including data models, ETL logic, and reporting specifications.
• Participate in testing cycles (unit, SIT, UAT) and support business users during validation phases.
• Provide input into best practices and continuous improvement initiatives within the SAP data landscape.
• Stakeholder and client management.

The successful candidate must have

• 4–8+ years of experience in SAP BW/BW/4HANA within financial services (Banking/Insurance/Consulting) is beneficial.
• Strong hands‑on experience in SAP BW data modelling (InfoObjects, ADSOs, Composite Providers, Open ODS Views).
• Proven experience with ETL processes and SAP data integration tools (e.g. SAP BW ETL, SAP Data Services, SLT).
• Experience working with SAP HANA and performance optimisation techniques.
• Exposure to reporting and analytics tools (e.g. SAP Analytics Cloud, BEx, Power BI, Tableau).
• Understanding of financial services data models and regulatory reporting requirements is beneficial.
• Proven ability to work with stakeholders to translate business requirements into technical solutions.
• Relevant bachelor's degree, with a strong preference for a postgraduate qualification.
• SAP certifications (e.g. SAP BW/4HANA, SAP HANA, SAP Business Data cloud) are advantageous.
• Experience with data governance, data quality, and data architecture principles.
• Strong problem‑solving skills and ability to work in fast‑paced project environments.
• A results‑driven approach and a readiness to embrace change, overcome challenges, and deliver on complex projects.
• Abap coding or SQL is highly beneficial.

Monocle offers

• Unlimited training and development – Investment in our people's development is at the heart of Monocles company ethos. That is why we prioritise the upskilling of every employee.
• Unparalleled growth and exposure – Monocle is uniquely positioned in the market to undertake projects across a wide spectrum of critical and exciting areas of the financial services industry. Our consultants deliver mission‑critical projects at the most prestigious banks and insurers in Johannesburg, Cape Town, London and Amsterdam.
• Unique and vibrant company culture – At Monocle, we believe friends work better together than colleagues. We love nothing more than partaking in a wide variety of activities through our company-sponsored clubs.
• Ultra‑competitive compensation – At Monocle, we want the best talent to join our team, so we understand that those individuals need to be recognised and rewarded for their true value.