Data Analyst

Large Holdings

Global Large Shareholding regulations require Barclays to monitor and disclose the Firm’s aggregate holdings in equity and equity related securities of publicly listed companies to regulators, exchanges and issuers. Market disclosures are preconditions to a liquid and efficient market, lowering the cost of capital and delivering benefits for investors. Global laws are complex and carry significant levels of risk that can lead to market destabilisation. Market failures lead to regulatory censure and reputational damage.

Large Holdings is the functional area within Markets Operations and is responsible for ensuring the Firm meets its large shareholding monitoring, advisory and reporting obligations.

The role holder will work within the Large Holdings Data Operations team to create and maintain an environment and capability that enables regulatory reporting, control and oversight across the Barclays Group in collaboration with Business Units and Head Office functions.

The role holder will manage critical and complex data management requirements in collaboration with Barclays International, Barclays UK and Central Support Functions.

• Proactively managing Group Holdings and Transaction data to and maintaining a robust data governance framework.
• Delivering a structured approach to the analysis, resolution, reporting and measurement of data defects and leading data quality enhancements.
• Conceptualising, designing and implementing strategic solutions to enable Large Holdings to demonstrate adherence to data regulations and prioritised internal data projects.

Key Accountabilities

Reporting to Large Holdings Head of Data Operations and working alongside Large Holdings Regulatory Operations team member in New York, the role holder’s responsibilities include group wide coverage of all equity based holding position and transaction data to deliver a structured approach to the analysis, resolution, reporting and measurement of data defects and to champion data quality enhancements. The ideal candidate will have a strong understanding of databases and data analysis procedures. The role holder will also possess excellent troubleshooting skills have excellent eye for detail, identify trends and patterns in information and have excellent computer skills.

• In this role you’ll be using your technical expertise to extrapolate data by using advanced computerised models.
• Assist with the delivery of Barclays Large Holdings obligations in the Americas
• Provide advice to Business on Large Holdings disclosures, including: technical advice on the impact of financial instrument selection, transaction structure, sensitive industry, poison-pill, etc.
• Liaising with traders and the business to provide real-time trade approvals and position information
• Liaising with traders and the business to establish clear understanding of product and trade structures and how they reflect on Large Holding monitoring.
• Conducting monitoring and surveillance activities
• Assist with reports and data extraction when needed
• Enforce policy standards for effective data management
• Develop and execute database queries and conduct analysis to interpret data, analyze results using statistical techniques interpret trends or patterns in complex data sets
• Filter and “clean” data by establishing and maintaining performance indicators to locate and correct data problems
• Support others in the daily use of data systems and ensure adherence to legal and company standards
• Troubleshoot data-related problems and recommend maintenance or modifications
• Monitor and analyze information and data systems and evaluate their performance to discover ways of enhancing them
• Create visualizations and reports for requested projects
• Maintain and enhance conformance framework
• Conduct conformance testing and troubleshooting
• Develop and update technical documentation

Basic Qualifications/Skills:

• 4 year Bachelor’s Degree
• 3+ years Investment Banking or Financial Services Experience
• 2+ years working specifically in an equity trading environment

Preferred Qualifications/Skills:

• Working understanding of database management systems (MSSQL, Oracle, Hadoop), online analytical processing (OLAP) and ETL (Extract, transform, load)
• Knowledge of enterprise reporting packages (such as Tableau, IBM Cognos, Business Objects etc),
• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc)
• Knowledge of writing and reading SQL queries with tools such as MSSQL Studio, Oracle Toad, Oracle SQL Developer.
• Proficient in MS Office (Excel, Access, Word etc.)
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Analytical mind with a problem-solving aptitude
• Excellent communication and presentation skills
• Abilities to take initiative and be innovative

Job Type: Full-time

Experience:

• Data Management: 1 year (Required)
• Reporting: 1 year (Required)
• Data Analytics: 1 year (Required)
• SQL: 1 year (Required)