Global Barclays Job Advert Template
Grade : AVP
About Data & Strategic Analytics (DASA)
DASA’s aim is to use data to provide analysis and insight to drive customer value .Data is analysed and categorised in order to tell us more about a service or product .
We interpret this information to come with ways to make a product or service better ,more streamlined and efficient and more personalised to Business and individual need .
To build, develop and maintain systems using Oracle Essbase and Planning system 11.x to deliver a world class, fully integrated, financial reporting, planning and analysis capability across Barclaycard Finance.
Your Role will include
MI Systems Development Activities (20%)
Design & build a fully integrated financial planning / reporting solutions using Oracle Essbase, Planning and other appropriate toolsets
Implement and customise database structure including data cleanup, load, security procedures and performance tuning, proactively monitor critical systems.
Proven track record of implementing Essbase solutions using BSO, ASO methodologies.
Extensive experience in building load rules / writing MAXL, Calc scripts, Security Filters, Groups.
Design, build, develop and maintain automated feeds into systems in particular the daily loads and hierarchies from core source systems.
Maintain consistency in Essbase cube builds and designs across the project and across the wider Barclaycard finance community.
Research and implement best practices related to use of Essbase application.
Experience in guiding ETL team in providing Business rules to build metadata and data load into Essbase.
Good understanding on any of MDM tools such as DRM, RDM to manage Essbase hierarchies, Property categories, verification and validations.
Experience in connecting relational sources from Essbase load rules to refresh metadata and data.
Maintenance and development of existing Essbase systems (60%)
Provision of decision making capability to support day-to-day Essbase processes.
Identify & implement process improvements to support more efficient financial analysis.
Implement small change requests in accordance with bank specified policies.
Project Management (10%)
Take lead role in the development of Essbase environment and in the implementation of any additional BI solutions.
Provide and maintain all database documentation including business requirements, work flows, standard procedures, and user guides.
Ad-hoc development, support & control (10%)
Perform special projects as directed by management
Other ad-hoc as required
Own SOX controls and processes
Full technical understanding of Oracle Essbase and all its related components
Expert in multidimensional cube-design, tuning and model optimisation
Highly proficient in visualisation, scoping and design of cube-based analytical solutions for a diverse range of business requirements
Experience of many varied implementations across many different businesses
Full competency with the Oralce Essbase tool set, specifically Administration Services, MAXL, MDX and Shared Services
At least One Driver based Planning project completion experience
Must have experience in building ASO and BSO and Hybrid Essbase applications.
Expert in Essbase calculation scripting and calculation optimisation
Excellent understanding of Essbase server management processes, configuration setting and cache management
Proven experience of design & build of Oracle Essbase planning, forecasting and reporting solutions in large organizations
Good to have VBA, SmartView expertise which includes use of the Essbase Extended Spreadsheet Toolkit and Essbase API (Application Programming Interface)
Good understanding of data-warehousing and management of relational data for sourcing cube-based datamarts.
Strong knowledge of SQL (familiarity with Hadoop / Hive ) added advantage.
Good hands on one of these different Business Intelligence tools (OBIEE, Tableau, Power BI etc..)
Experience with analytics in Bank Cards or related financial service industry combined, with an understanding of a credit card P&L a big plus.
Ability to handle variety of responsibilities and drive success with limited resources in a matrix organization.
Candidate needs to possess superior analytical and communication skills with ability to interact with personnel at all levels of the organization;
customer service skills; organizational skills are a must.
Strong written and verbal communication skills.
Highly motivated, energetic, thorough, detail oriented and ability to multi-task.
A strong command of English and Commercial language is a must both in the spoken and written form. Any additional languages spoken will be a bonus.
Barclays is a transatlantic consumer, corporate and investment bank offering products and services across personal, corporate and investment banking, credit cards and wealth management, with a strong presence in our two home markets of the UK and the US.
Our goal is to become the bank of choice by providing superior services to customers and clients and supporting our stakeholders via a commercially successful business that generates long-
Risk and Control Objective
All Barclays colleagues have to ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards.