SAP BW Consultant

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.

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 include but are not limited to:

• Design, develop, and maintain SAP BW/4
  
  HANA data models, including Info Providers (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.

• 4–8+ years of experience in SAP BW/BW/4
  
  HANA within financial services (Banking/Insurance/Consulting) is beneficial.
• Strong hands-on experience in SAP BW data modelling (Info Objects, 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/4
  
  HANA, 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.

• 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…