As a Barclays Senior Technical Business Analyst, you will be serving high priority regulatory requests via using SQL to mine data from Redshift. Additional responsibility include translating requests into requirements/documentation and ultimately an appropriate data extract or ETL solution. Other duties will be building out strategic solutions in AWS, alongside Tableau dashboards for the end users. You will also be part of the AWS Data engineering and analytics team, which create ETL pipelines within the AWS data.
Barclays is one of the world's largest and most respected financial institutions, with 329 years of success, quality, and innovation behind us. We've helped millions of individuals and businesses thrive, creating financial and digital solutions that the world now takes for granted. An important and growing presence in the USA, we offer careers providing endless opportunity.
We are currently in the early stages of implementing a hybrid working environment, which means that many colleagues spend part of their working hours at home and part in the office, depending on the nature of the role they are in. We're flexible on how this works and it may continue to change and evolve. Depending on your team, typically this means that colleagues spend a minimum of between 20% to 60% of their time in the office, which could be over a week, a month or a quarter. However, some colleagues may choose to spend more time in the office over a typical period than their role type requires. We also have a flexible working process where, subject to business needs, all colleagues globally are able to request work patterns to reflect their personal circumstances.
Please discuss the detail of the working pattern options for the role with the hiring manager.
What will you be doing?
??? Translating requirements into documentation/technical specs and ultimately into coded solutions, mainly via tactical solutions such as SQL extracts from redshift ??? Helping the development team build out of a formal ETL flow in AWS ??? Eliciting, validating and documenting regulatory requirements in either Business Requirement Documents or JIRA workflows ??? Supporting development of the test strategy; planning and testing cases working in conjunction with the business and development teams ??? Soliciting collaboration and engagement with SME population, particularly where support is low or challenging ??? Negotiating with senior stakeholders to get buy-in and proposed changes or recommendations ??? Considering the impact of their actions on key stakeholders, seeking to deliver a positive outcome for those involved ??? Providing analysis and resolutions to complex issues and propose innovative recommendations and solutions for implementations
What we're looking for:
??? Excellent data analytics skill set, inclusive of SQL, Python, and the like ??? Working knowledge regarding Data Visualisation tools such as QlikView, Tableau, and the like ??? Exposure to CI/CD tools such as GIT and Jenkins ??? Exceptional written and verbal communication including documentation. Highly numerate and analytical with excellent problem solving skills
Skills that will help you in the role:
??? Experience of handling urgent regulatory requests, going from requirements gathering through to delivery of the end solution ??? Experience of working with Risk data/Trading Data/Reference data (Instruments/Books/Client static data) in a Banking environment ??? Hands on experience in delivering applications/solutions on AWS, Azure, and the like ??? Knowledge & understanding of the main asset classes traded within an investment bank & associated static data, data warehousing, dimension modelling & architecture
Where will you be working?
At Barclays, we are proud to be redefining the future of finance and here at Whippany we are defining the future of the workplace and the future of the way we work and live. We are creating a unique community, one of four strategic tech-enabled hubs that will redefine opportunity for everyone who works here. Whatever you do at Whippany, you'll have every chance to build a world-class career in this world-class environment.