ETL & BI Architect

Pune, India

Apply for job

Date live: Oct. 11, 2022

Business Area: COO & Functions

Area of Expertise: Technology

Reference Code: 90278009

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: ETL & BI Architect

Location: Pune

Introduction:

Purpose of the proposed role is to be the ETL & BI Architect for the data team. To provide the technical solutions and guidance to the engineers. Laydown strong ETL and BI road map for the team and the projects we are involved. Provide BI and DW guidance and drive an high quality engineering practise with in the team.

You will work with various federated teams and guide them in Ab Initio design, development and implementation.

You will be responsible for the Datawarehousing and Business Intelligence solutions. You will be hands on delivering strategic MI , Dashboard, and other Visualisation requirements. Delivering the visualisation function for the team
You will be responsible in leading the Visualisation technical decisions and choice of tools based on the requirement (Qlik, Tableau, Python, Actuate, D3 etc.) including the platform setup, sizing etc
You will also troubleshoot various problems/errors encountered by federated team while developing Ab Initio based ETL applications.
You will have high-level knowledge about other technologies like Hadoop, Teradata, Oracle, Mainframe etc. It will help to develop efficient Ab Initio code interfacing with those technologies
Data Derivation, Data Mapping and Data Modelling, Visualisation Development. [60%]
Creating the required plan and technical delivery road map and design.[10%]
Creating the Visualisation platform and finalising the tools [10%]
Inputs to the functional document creation [10%]
Interact with SME to gather information
Study various strategy documents available within the organization
Reviews & Sign-Off technical output of developers
Inputs to the other teams like Run/Production Support Teams etc

What will you be doing?

To be the lead engineer for the ETL & BI Function especially specialising in A>I and widerange of Visualisation tools (Qlik, Tableau, D3, Python etc)
To evaluate the requirements with impact assessments for all the projects across the data team
To be able to define Frame Works, Generic , Reusable components for the ETL Team using A>I, Spark
To create a resilient BI Environment for the FTC i.e. all datawarehousing and reporting components are run without any failure and having a proper DR capability
To create standard practices and procedures for all the developer community
To deliver high quality mi and visualisation from engineering function,
To drive technical skill set enhancement for the engineering function from BI perspective
To deliver cost effective and repeatable patterns for Data Team
Ownership of the BI Engineering deliveries

What we’re looking for:

Should have strong hands-on experience on Ab Initio GDE. Troubleshoot any Ab Initio related problem/error, implemented realtime, batch based solutions with large volume of data processing. Should have delivered Warehouse projects.
Should have strong hands-on experience on Visualisation Tools (Qlik, Tableau, D3, Python etc) related problem/error, implemented realtime, batch based solutions with large volume of data. Should have delivered Warehouse projects with experience in data modelling.
Should have working knowledge SQL and NOSQL databases like Teradata, Oracle, Hadoop, and Streaming data.
Provide expertise and continuity across both the business solution and technical solution involving Ab Initio and BI Builds effective relationships with all stakeholders including federated project teams, BU SPOC, GIS etc
Relevant years of experience – 12 years or more.

Skills that will help you in the Role:

Can work independently with minimum supervision and help the development team on technical expertise.
Pioneering - High level of initiative/innovation
Flexible and adaptable working style to work with multiple stakeholders

Where will you be working?

Pune

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