Commercial Intelligence Analyst

Commercial Intelligence Analyst

As a Commercial Intelligence Analyst you will be responsible for bringing in hands on technical expertise that is part of the UK & Europe Commercial Enablement team, reporting directly into the Head of Commercial Intelligence & Analytics. You will primarily be responsible for implementing the structural and physical design of all MI (Management Information) produced by the team to support 1500 users across the UK and Europe (14 offices). 

About us: 

The Private Bank supports High Net Worth, Ultra High Net Worth and Family Office banking, investment and credit needs through a dedicated Private Banker and team of investment and wealth specialists.  With offices in the United Kingdom, Ireland, Monaco, Switzerland, India and Dubai, we offer access to a fully bespoke service. The business is high growth and significantly invested in delivering high touch personal services and solutions with access to the Corporate and Investment Bank. Complex products are available through the Private Bank; including structured credit and derivative margin trading, direct access to trading desks for equity and FX forwards

As a Commercial Intelligence Analyst, your main responsibilities will involve:

• Implementing the structural and physical design of all MI produced by the team to support 1500 users across the UK and Europe (14 offices). 

• Working closely with developers producing scalable reporting solutions and managing several work streams in the team, helping to gather requirements across Private Bank & Overseas Services and constructing business data model incorporating external and internal data sources

• Translate business requirements into technical language and understanding how systems works

• Architecting workflows using best practices and most efficient methods when joining multiple data sources, and helping to construct algorithms 

• Developing the end-to-end weekly solution orchestration/approach to generate the outputs to meet the various needs across multiple jurisdictions

• Core report code development (primarily Excel, Python, Alteryx, SQL and Qlik)

As a Commercial Intelligence Analyst, your skills and qualifications will include:

• A blend of both technical and functional skills, experience of supporting sales management reporting (preferably in Financial Services) 

• Prior experience delivering the technical aspects of time-critical intelligence for business leaders, delivering bespoke managerial intelligence that adds-value to the bottom line of the business 

• Previous experience with MS Dynamics 2011 (or equivalent CRM technology), Excel (VBA) and relational database technology (ideally SQL Server) 

• Proven reporting experience creating complex SQL/Alteryx/QlikView reporting integrated with the MS Dynamics FilteredViews layer will be advantageous

• Demonstrable experience with using SharePoint to distribute report outputs

The Benefits:

Our customers deserve the best. The same goes for our people. That’s why at Barclays you’ll receive a range of benefits including a competitive salary, flexible hours and all the tools, technology and support to help you become the very best you can be.

Our Culture: 

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

Dynamic working gives everyone at Barclays the opportunity to integrate professional and personal lives, if you have a need for flexibility then please discuss this with the hiring manager.

Diversity:

At Barclays, we recruit based on merit and are committed to promoting diversity throughout our organisation.

Ready to apply?

There are up to five stages to our application process:

1. Application: On your application we’ll ask for information like your contact details, education and work experience. You’ll also be required to upload a CV, so it’s a good idea to have it ready.

2. Online Assessment: We’ll then ask you to complete an online assessment exercise which we will send to you via email. Our assessments are carefully designed to measure the skills and capabilities necessary to be successful in our roles, but they’ll also provide you with some insight into what our roles entail.

3. Application Review: We will review your application along with your responses to the online assessment exercise. Depending on the type of role you are applying for, we may contact you to arrange a brief telephone interview to discuss your experience in more detail.

4. Interview: If your application is progressed, we’ll invite you to attend a face-to-face interview. We want you to be free to choose an interview time that suits you, so we’ll provide some options and ask you to select your preferred timeslot.

5. Outcome: We will keep you updated throughout the process. If you attend an interview, we’ll be in touch within five working days of all interviews being completed to advise you of the outcome.

We encourage applicants to apply as early as possible in the recruitment period. Barclays recruitment periods can and may vary. We reserve the right to remove this advert during the recruitment process.