Andrew Watson

Andrew Watson Email and Phone Number

Director - Global Markets - Cross Asset Data and MI @ Barclays Corporate & Investment Bank
Middlesbrough, England, GB
Andrew Watson's Location
Greater Middlesbrough and Stockton Area, United Kingdom
Andrew Watson's Contact Details

Andrew Watson personal email

n/a
About Andrew Watson

Delivering BI solutions in Tableau since Tableau 5, perhaps the most experienced Tableau consultant in the UK.However, Tableau is only the visible output of my data and reporting solutions. My expertise extends to ETL (Alteryx, SSIS, SnapLogic) and databases (SQL Server, Oracle, BigQuery, Redshift) to build end to end data platforms.In addition, clients require managing and I also scope, plan and deliver data projects.Industry experience:Financial services (Investment banking, asset management, retail banking, insurance, wealth management)TelecomsPharmaInternetTV / Broadcasting

Andrew Watson's Current Company Details
Barclays Corporate & Investment Bank

Barclays Corporate & Investment Bank

View
Director - Global Markets - Cross Asset Data and MI
Middlesbrough, England, GB
Andrew Watson Work Experience Details
  • Barclays Corporate & Investment Bank
    Director - Global Markets - Cross Asset Data And Mi
    Barclays Corporate & Investment Bank
    Middlesbrough, England, Gb
  • Barclays Corporate & Investment Bank
    Director - Global Markets - Cross Asset Data & Mi
    Barclays Corporate & Investment Bank Jan 2024 - Present
    London, England, United Kingdom
    Setting up the Cross Asset MI for the Front Office. Reporting Resource Management data (risk, collateral, revenue), with Tableau as the front end platform. Understanding the inherited situation, planning and implementing a scalable end to end MI solution for Front Office users and other stakeholders.
  • Praesto Consulting Uk Ltd
    Managing Consultant
    Praesto Consulting Uk Ltd Jun 2021 - Jan 2024
  • Tar Solutions
    Director
    Tar Solutions May 2014 - Jun 2021
    London, United Kingdom
    tarsolutions.co.uk. Data consultancy specialising in managing data projects, implementing Tableau reporting solutions, building data solutions in Alteryx with expertise in process and workflow design and implementation.
  • Bnp Paribas Asset Management
    Client Experience Insights
    Bnp Paribas Asset Management Oct 2018 - Dec 2019
    London, United Kingdom
    Identifying the KPIs for measuring client experience. Understanding what data is available, what data will soon be available and create action plans where useful data does not yet exist. Bring data together from multiple sources to show to the business better information about their clients enabling their clients to be better understood and served.
  • Deutsche Bank
    Senior Tableau Consultant - Credit Risk
    Deutsche Bank Jun 2017 - Oct 2018
    London, United Kingdom
    Taking the Tableau project for Credit at Deutsche to the next level. Working on permissions model design and implementation; report design; project structure and set up; and aligning business and IT teams across 3 continents to deliver high quality management information for the risk and trading teams of the Credit business line.
  • Bnp Paribas
    Data Hub Project Manager
    Bnp Paribas Dec 2016 - Jun 2017
    London, United Kingdom
    Helping to get the Data Hub off the ground, setting up the process to get data into the hub, understand stakeholder priorities, understand the integration of the data with Ab Initio.
  • Bnp Paribas
    Employee Conduct Program - Tableau Designer / Developer
    Bnp Paribas Dec 2016 - Jun 2017
    London, United Kingdom
    Developed the dashboards to report on bank policy breaches by UK CIB staff. This entailed understanding and implementing requirements, sourcing and joining data from a variety of sources to produce a 'simple to understand' view of staff conduct for use by the top management of the UK CIB business.
  • Bnp Paribas
    Data Quality Alteryx Manager - Global Markets
    Bnp Paribas Nov 2015 - May 2016
    London, United Kingdom
    The Global Markets Data Quality team was at a very early stage and my role was to set up the processes and structure to allow quality checks to be set up and automated. Alteryx was the software used for this task as it is very quick and cost effective to implement. I set up the technical architecture for the Data Quality team which included setting up the Alteryx server infrastructure and creating end to end process workflows in Alteryx to monitor data quality. This was successfully handed over to an offshore team, including a couple of months of training.
  • Bnp Paribas
    Tableau Bi Reporting Program Manager - Global Markets
    Bnp Paribas May 2014 - Nov 2015
    London, United Kingdom
    Built a team from scratch to roll out Tableau across the front office Global Markets business of BNP Paribas investment bank. I recruited and led 8 Tableau developers to replace the incumbent Business Objects system with automated and permissioned Tableau reports for the management, marketers and traders. - Increased the report user base from under 10 users per week to over 550 users per week - Reports used in over 25 different countries covering Europe, Asia, North and South America, Asia, Australia and AfricaWorked very closely with the different business lines to understand the information they need and deliver value in their reports and very closely with IT to ensure they were able to supply the data required to give the business the information they wanted. Dashboards were designed and built to support the maximum number of users with 'in-report' permissions and also to ensure efficiency with data updates as well as consistency in look and feel across the different business lines.Report usage from the business showed a strong upward trend every month, demonstrating they were supplied with a quality product. The project was successfully handed over to the internal business to maintain.
  • Alixpartners
    Data, Reporting And Analytics Consultant
    Alixpartners Jul 2012 - May 2014
    London, United Kingdom
    Installation of a new reporting suite, Tableau Server, and development of an initial set of MI dashboards for a large UK based insurance broker to be used by over 500 users, from branch managers up to the board. This included training their internal staff data team how to use Tableau to build reports and also train the report users how to use Tableau from a user perspective.I managed a project to design, build and deploy a web based application monitor compliance for a financial services client. This included improving the data management and subsequently creating and implementing new work processes to ensure the future integrity of the data.Designed and built a data warehouse in SQL, with ETL using SSIS, to track the complaints and resolution of the complaints of mis-sold insurance products for a large bank.Developed a set of Excel based financial models to redress customers mis-sold financial products for a large international bank. This included gathering requirements, documenting the models and training developers in how to build/maintain the models.Worked on optimising the routes for a French based ferry company to improve their profitability.
  • Homeaway.Com
    Senior Business Information Analyst
    Homeaway.Com Nov 2007 - Jul 2012
    London, United Kingdom
    Development and implementation of a suite of reports for use by all levels of the business, plus evangelist of self service BI throughout the organisation. I was responsible for all reporting on the server from creating them, ensuring they contained relevant and up to date information and encouraging usage amongst the business teams.In addition I worked in a hybrid role bridging the gap between the business teams and BI/DBA teams. My role included project managing a data warehouse redesign and build including gathering and documenting requirements the data warehouse has to deliver. Other responsibilities include forecasting and budgeting; ad-hoc data analyses and report creation in both SSRS and Excel; maintenance of a CRM system I designed and built used throughout the EU business; and the training of colleagues in a number of different countries in Tableau and Excel. I also worked as a web analyst for the first couple of years in the business.
  • Homeaway.Com
    Business Information Analyst
    Homeaway.Com Jul 2007 - Oct 2007
    London, United Kingdom
    Dashboard and report development in web analytics and other operational business metricsExcel training
  • Buyingteam
    Business Analyst
    Buyingteam Sep 2006 - Jul 2007
    London, United Kingdom
    Financial analysis and dashboard development for external clients
  • Sandwich Shop
    Managing Director
    Sandwich Shop Jan 2004 - Jun 2006
    Newcastle Upon Tyne, United Kingdom
  • Coop
    Data Analyst
    Coop Mar 2003 - Sep 2003
    Newcastle Upon Tyne, United Kingdom
  • Medibank Private
    Data Analyst
    Medibank Private Mar 2001 - Oct 2001
    Melbourne, Australia
  • Ups
    Database Developer
    Ups Jul 2000 - Oct 2000
    Greater Chicago Area
  • Bae Systems
    Placement Student
    Bae Systems Aug 1998 - Sep 1999
    Preston, United Kingdom

Andrew Watson Skills

Business Intelligence Data Warehousing Tableau Data Analysis Analytics Sql Business Analysis Data Modeling Pivot Tables Management Analysis Ssrs Microsoft Excel Web Analytics Report Writing Etl Databases Project Management Crm Omniture E Commerce Consulting Vba Reporting Design Management Consulting Excel Sharepoint Dashboards Financial Services Alteryx Microsoft Access Access Certified Project Manager Prince2 Ssis Requirements Analysis Forecasting Financial Modeling Retail Banking Reporting And Analysis Asset Management Investment Banking Credit Risk

Andrew Watson Education Details

Frequently Asked Questions about Andrew Watson

What company does Andrew Watson work for?

Andrew Watson works for Barclays Corporate & Investment Bank

What is Andrew Watson's role at the current company?

Andrew Watson's current role is Director - Global Markets - Cross Asset Data and MI.

What is Andrew Watson's email address?

Andrew Watson's email address is an****@****e.co.uk

What schools did Andrew Watson attend?

Andrew Watson attended Northumbria University.

What are some of Andrew Watson's interests?

Andrew Watson has interest in New/young Business, Travel.

What skills is Andrew Watson known for?

Andrew Watson has skills like Business Intelligence, Data Warehousing, Tableau, Data Analysis, Analytics, Sql, Business Analysis, Data Modeling, Pivot Tables, Management, Analysis, Ssrs.

Not the Andrew Watson you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.