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

Job Description

Your opportunityDeloitte 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 roleThis 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. Responsibilities•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 choiceAt 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 experienceEssential •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 Desirable

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, were 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, youll 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 whats more, you can grow your career in whatever direction you choose. Well support you all the way. Personal independenceRegulation 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 DeloitteOur Purpose & StrategyTo 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, its 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 doDeloitte offers global integrated professional services that include Audit & Assurance, Consulting, Financia