Hyperion Analyst

Noida, India

Apply for job

Date live: Oct. 11, 2022

Business Area: COO & Functions

Area of Expertise: Technology

Reference Code: 90275161

Contract: Permanent/Regular

Where will you be located?

Take a look at the map to see what’s nearby. Train stations & bus stops, gyms, restaurants and more.

Explore location

Job Title : Hyperion Analyst

Location : Noida
This role will be based out of Indian Noida location and report to Hyperion Support Manager – CB&P Chief Data Office. The individual will play a key role in the support of the Hyperion Essbase and planning applications for Finance, Risk and Treasury teams across Barclays Consumer Banking & Payments business area. Provides finance customers with accurate reliable and simple MI to assist them in decision support, analysis and run the bank activities.

What will you be doing?
•   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.
•   Provide on-going communications support, maintenance, and enhancement of complex Essbase applications.
•   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.
•   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.
•   Optimize Hyperion Essbase cubes performance including FX/Currency conversions, data uploads, data exports, and data transfers to various scenarios and versions
•   Work with both multidimensional and relational database technologies to create application architecture consistent with the balance of the application portfolio
•   Provide continuity between the Essbase systems, the infrastructure teams, and adhere to Barclays best practices and standards
•   Maintain the Essbase data models in conjunction with other application systems
•   Develop and support data cleansing, transformation routines, data uploads, and data exports to various scenarios and versions
•   Coordinate and respond to operational support issues and opportunities

What we’re looking for :

•   Bachelor’s degree in Computer Science, Management Information Systems or Engineering required
•   At least years of experience in implementation and support of System 11 Hyperion Products with strong development experience in
o   Oracle Essbase, Oracle Hyperion Planning, and Oracle DRM
o   MaXL, MDX, Business Rules, Aggregations, SmartView, Load Rules
•   Worked in Data Migration/Rollouts of Hyperion Budget, Forecast and Balances on multiple country rollout
•   Must have experience in building ASO and BSO, and Hybrid Essbase applications.
•   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, ETL tools (such as SSIS or Oracle Data Integrator), and relational data management for sourcing cube-based data marts.
•   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.)
•   Ability to handle a variety of responsibilities and drive success with limited resources in a matrix organization.
•   Strong written and verbal communication skills.

Skills that will help you in the role
•   Experience with finance analytics in retail banking and payments or related financial service industry combined with an understanding of a credit card P&L is a big plus.
•   Experience with Oracle EPM Cloud Technologies (EPBCS, PBCS, OACS (Oracle Analytics Cloud Services) and APIs).
•   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.

Where will you be working?
• Noida

Be More at Barclays
At Barclays, each day is about being more – as a professional, and as a person. ‘Be More @ Barclays’ represents our core promise to all current and future employees. It’s the characteristic that we want to be associated with as an employer, and at the heart of every employee experience. We empower our colleagues to Be More Globally Connected, working on international projects that improve the way millions of customers handle their finances. Be More Inspired by working alongside the most talented people in the industry, and delivering imaginative new solutions that are redefining the future of finance. Be More Impactful by having the opportunity to work on cutting-edge projects, and Be More Valued for who you are.
Interested and want to know more about Barclays? Visit home.barclays/who-we-are/ for more details.

Our Values
Everything we do is shaped by the five values of Respect, Integrity, Service, Excellence and Stewardship. Our values inform the foundations of our relationships with customers and clients, but they also shape how we measure and reward the performance of our colleagues. Simply put, success is not just about what you achieve, but about how you achieve it.

Our Diversity
We aim to foster a culture where individuals of all backgrounds feel confident in bringing their whole selves to work, feel included and their talents are nurtured, empowering them to contribute fully to our vision and goals.

Our Benefits
Our customers are unique. The same goes for our colleagues. That's why at Barclays we offer a range of benefits, allowing every colleague to choose the best options for their personal circumstances. These include a competitive salary and pension, health care and all the tools, technology and support to help you become the very best you can be. We are proud of our dynamic working options for colleagues. If you have a need for flexibility, then please discuss this with us.

More about working at Barclays

Our approach to hybrid working ensures there’s the right balance of working alongside colleagues at our onsite locations, as required for each role. For business areas that offer a hybrid working experience, this will be in a structured way, where colleagues work at an onsite location on fixed, ‘anchor’, days of the week. Some roles may require full onsite working. Please discuss the working pattern requirements for the role you are applying for with the hiring manager.

We continue to embed and review our hybrid working environment and remain in a phase of testing and learning. This means that working arrangements could change, with reasonable notice, to align with the needs of our business.

Barclays welcomes applications from all candidates and is committed to ensuring reasonable adjustments (accommodations) are put in place to allow for a fair and inclusive recruitment process. For more information and how to request one, please review Adjustments to the recruitment process.

We’re committed to providing an inclusive culture and environment, that recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees globally to work flexibly empowers each of us to work in a way that suits our lives, as well as enabling us to better service our customers’ and clients’ needs.

Our approach to working flexibly is designed to support you to balance your life and to accommodate diverse needs, whilst still allowing us to meet our business needs. If you’d like to request a flexible working arrangement, please discuss this with your hiring manager.

We're committed to providing a supportive and simplified experience for our candidates throughout the application and assessment process. Here, you will find information about what to expect and some guidance around your assessment and interview.

While the application process depends on the role, there are some constant steps, which are;

Step 1 - Your application
Step 2 - Your assessment
Step 3 - Your interview
Step 4 - Next steps

We aim to create an inclusive work environment where everyone can reach their full potential. If you require any adjustments to our recruitment process, please click here to learn more.

Find out more information here.

Barclays offers a diverse, inclusive and engaged culture. A place where people can bring their whole selves to work and be respected for who they are, valued for what they do and celebrated for their contribution to our business and our community.
We are an equal opportunity employer and opposed to discrimination on any grounds. It is the policy of Barclays to ensure equal employment opportunity without discrimination or harassment on the basis of race, colour, creed, religion, national origin, alienage or citizenship status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law.

Barclays is required by law to confirm that you have the Legal Right to Work in any role that you apply for. If you currently hold a work visa sponsored by Barclays, or you would require sponsorship from Barclays, you must declare this as part of your application. Sponsored visas are role and entity specific and any changes must be reviewed. It is important that you ensure you are working on the correct visa at all times. Failure to accurately disclose your visa status or Legal Right to Work may result in your application or any employment offer being withdrawn at any time.

The Barclays Way

This is the spirit of Barclays. It’s why we exist, what we believe and how we behave. But most importantly, it’s how we make decisions, take action and get things done.

Learn more