BI & Integration (cross train to) SAP HANA Data Warehouse Solution Designer Developer — ITS -Enabling Functions — London / Any

Apply for the job now!

Job title: BI & Integration (cross train to) SAP HANA Data Warehouse Solution Designer Developer — ITS -Enabling Functions — London / Any

Company: Deloitte

Job description: Your opportunity
Deloitte is transforming the way it delivers application integration, analytics and reporting to enable the business to realise its strategic objects to regionalise the firm and digitise the practice.
A corner stone of this programme is a bespoke HANA data warehouse which is being further developed to extend the API catalogue, analytics models and reporting (SAP Business Objects and Tableau Server) for European countries to support the rollouts of single instance SAP S/4 Finance and Salesforce CRM solutions. Our current focus is on Belgium, Denmark, Ireland, Italy and the Netherlands. We are looking for an experienced HANA Developer who wants to develop their career as part of a relatively small BI Analytics team serving challenging internal customers.
We encourage consideration of flexible ways of working, both formal and informal arrangements that allow for the best outcomes for our people and our clients. If this opportunity is of interest to you with some flexibility, please do discuss with us.

Your role
This role is an opportunity for someone with transferrable skills to cross-train to work on SAP HANA
SAP HANA Data Warehouse Solution Designer Developer. The team provides production support (take technical ownership of the solutions they deliver) and their ongoing evolution with Product Owners. There is a strong pipeline of additional work from the ITS Projects Portfolio and global/regional programmes. In this hands-on role, you will work closely with the BIIS Director, the BIIS Delivery Manager, Product Owners and distributed teams.

•Working as part of a multi-country and multi-discipline team to deliver a global SAP transformation project, using SAP leading technology (S/4 HANA, HANA native data warehouse)
•Taking part in daily SCRUM round-tables to give updates / resolve issues with wider team
•Working in collaboration with other technical team members and 3rd parties to build out a HANA-based Data warehouse and master data repository
•Solution Design and hands-on development of native-HANA objects, SQL-scripts and information models.
•Development of client-facing HANA views for both analytics and downstream operational applications
•Development of complex ETL models, including Functions, Views and Stored Procedures
•Support transition migration of HANA XS Classic development objects to XS Advanced
•Support migration of firms’ historical data into the new data warehouse
•Working effectively in diverse teams within an inclusive team culture where people are recognised for their contribution

Your work, your choice
At Deloitte we believe the best impact is the value we add, not the hours we sit at our desk. We carefully consider agile ways of working, both formal and informal, that allow for the best impact for our people and our clients. Please speak to your recruiter about the working pattern that works best for you.

Location: London

Work pattern: This is a permanent contract opportunity. The role can be worked on a full-time basis.

Your professional experience

•Experience in a hands-on data warehouse analytical model developer role:
•Creation of dimensional models (schema design, tables and views)
•Coding of complex functions and Stored procedures using native SQL
•Performance analysis and tuning
•Time dependency / Historical master data model
•Analytical privileges / User security model
•Data acquisition utilising ETL tools e.g. SSIS
•Strong understanding of the basic principles of data warehousing and multi-dimensional data modelling, including end-to-end data flow mapping
•Inquisitive, self-starter, investing in own personal development
•Capable of creating high-quality technical specification documentation


  • Understand best-practice principles for integration of data requirements for visualisation and report design purposes
  • Understanding of BI Tools (e.g. Tableau, SAP Business Objects, Power BI) and their appropriate use-cases
  • Good knowledge of best-practice for source code management, build / deployment methodologies and tools, such as Azure DEVOPS
  • Experience of working with colleagues and 3rd party-development teams based offshore
  • Functional knowledge of SAP R/3 or S/4 as a data source (Finance, PS, SD, HR) and/or Salesforce
  • Experience / knowledge of best-practice data on complex data migration projects
  • Knowledge or experience of ODATA type web-service interfaces

Your service line: Enabling Functions
At Deloitte, we’re all about making an impact that matters, together. And nowhere is this more apparent than among our 2,000-strong Enabling Functions teams.
With our combined specialist skills and business partnering expertise, we provide all the essential strategy, support and advice our client-facing
colleagues need, right across the firm. This enables them to focus all of their efforts on delivering the best service possible to their clients.
So not only will you be providing world-class support to our internal clients, you’ll be making an impact for all the hugely influential organisations
Deloitte works with too. Covering all our distinct areas; Human Resources, Clients & Industries, Finance & Legal, Central Business Services,
National Quality & Risk Management, Technology & Digital Services, and Real Estate, the opportunities here are vast. And what’s more, you can grow your
career in whatever direction you choose. We’ll support you all the way.

Personal independence
Regulation and controls are standard practice in our industry and Deloitte is no exception. These controls provide important legal protection for both you and the firm. We are subject to a number of audit regulations, one of which requires that certain colleagues abide by specific personal independence constraints. This can mean that you and your “Immediate Family Members” are not permitted to hold certain financial interests (shares, funds, bonds etc.) with audit clients of the firm. The recruitment team will provide further detail as you progress through the recruitment process.

About Deloitte

Our Purpose & Strategy
To make an impact that matters for our clients, our people and society – defines who we are and what we stand for. Our purpose provides the foundation for our strategy and our aspiration to be the undisputed leader in professional services: this is not about size, it’s about being the first choice. The first choice for the largest and most influential clients, and the first choice for the best talent.

What do we do?
Deloitte offers global integrated professional services that include Audit & Assurance, Consulting, Financial Advisory, Risk Advisory and Tax Consulting. Our approach combines intellectual leadership, industrial expertise, insight, consulting & problem solving capabilities whatever the role, technology revolutions and innovation from multiple disciplines to help our clients excel anywhere in the world.

Beyond the UK: Deloitte North and South Europe
The UK is part of Deloitte North and South Europe (NSE), the second largest member firm in the Deloitte network. Deloitte NSE combines operations in Belgium, Central Mediterranean (Italy, Greece, Malta), Ireland, the Middle East (Bahrain, Cyprus, Egypt, Iraq, Jordan, Kuwait, Lebanon, Libya, Oman, Palestinian Ruled Territories, Qatar, Saudi Arabia, United Arab Emirates, Yemen), the Netherlands, the Nordics (Denmark, Finland, Iceland, Norway and Sweden), Switzerland and the UK. Deloitte NSE brings together 2,700 partners and over 50,000 people, combining our unmatched breadth and depth of capabilities in audit and assurance, consulting, financial advisory, risk advisory, and tax and legal across the region. Being part of Deloitte NSE supports our aspiration to be the undisputed leader in professional services and will create more opportunity and growth for our people.

What do we value?
What brings us all together at Deloitte? It’s how we approach the thousands of decisions we make every day. How we behave, our beliefs and our attitudes. In other words: our values. Whatever we do, wherever we are in the world, we lead the way, serve with integrity, take care of each other, foster inclusion, and collaborate for maximum impact. These five shared values lead every decision we make and action we take, guiding us to deliver impact how and where it matters most.

Being a Leader at Deloitte
Cultural fit and purpose-led leadership is crucial for Deloitte. Our leaders always set the example and inspire their colleagues. They make quality time for people and take an interest in them. They know what matters to people – both inside and outside work — and value them as individuals; always finding opportunities to develop them while showing respect and appreciation.
We expect colleagues at all levels to embrace and live our purpose and our leadership culture by challenging themselves to identify issues that are most important for our clients, our people, and for society and make an impact that matters. We know leadership comes in all shapes and sizes, but our Leadership Charter helps all of our people understand what we’re looking for:

  • We live our purpose: we act as a role model, embracing and living our purpose and values, and recognising others for the impact they make
  • We develop talent: we develop high-performing people and teams through challenging and meaningful opportunities
  • We drive performance: we deliver exceptional client service; maximise results and drive high performance from people while fostering collaboration across businesses and borders
  • We believe positive influence can make an impact that matters: we influence clients, teams, and individuals positively, leading by example and establishing confident relationships with increasingly senior people
  • We move, together, towards a strategic direction: we understand key objectives for clients and Deloitte, aligning people to objectives and setting priorities and direction.


Deloitte LLP is a limited liability partnership registered in England and Wales with registered number OC303675 and its registered office at 1 New Street Square, London EC4A 3HQ, United Kingdom.
Deloitte LLP is the United Kingdom affiliate of Deloitte NSE LLP, a member firm of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee (“DTTL”). DTTL and each of its member firms are legally separate and independent entities. DTTL and Deloitte NSE LLP do not provide services to clients. Please see to learn more about our global network of member firms.

© 2020 Deloitte LLP. All rights reserved.

Requisition code: 179885

Expected salary:

Location: London

Job date: Sat, 27 Mar 2021 23:03:51 GMT

Apply for the job now!