Data-focused individual with a wide-ranging knowledge of business processes and reporting solutions, currently working with BAE Systems. Initially from a Project Engineering background, I have worked on projects within teams such as Aftersales, Business Intelligence, Compliance, Customer Services, eCommerce, Finance, IT, Logistics, Marketing, Operations, Quality Assurance, and Retail. Over eleven years in the Automotive sector, but can adapt to any industry as required, metrics are often similar. Always focused on how to improve data handling, quality, efficiency, accuracy – for better business reporting. I have advanced Microsoft Excel skills with utilisation of VBA, SQL, and Power Query. I can build dashboards in Tableau, Power BI, Looker, Domo; more recent work has involved engineering ETL dataflows in Tableau Prep.

Terry Smith

Data-focused individual with a wide-ranging knowledge of business processes and reporting solutions, currently working with BAE Systems. Initially from a Project Engineering background, I have worked on projects within teams such as Aftersales, Business Intelligence, Compliance, Customer Services, eCommerce, Finance, IT, Logistics, Marketing, Operations, Quality Assurance, and Retail. Over eleven years in the Automotive sector, but can adapt to any industry as required, metrics are often similar. Always focused on how to improve data handling, quality, efficiency, accuracy – for better business reporting. I have advanced Microsoft Excel skills with utilisation of VBA, SQL, and Power Query. I can build dashboards in Tableau, Power BI, Looker, Domo; more recent work has involved engineering ETL dataflows in Tableau Prep.

Available to hire

Data-focused individual with a wide-ranging knowledge of business processes and reporting solutions, currently working with BAE Systems. Initially from a Project Engineering background, I have worked on projects within teams such as Aftersales, Business Intelligence, Compliance, Customer Services, eCommerce, Finance, IT, Logistics, Marketing, Operations, Quality Assurance, and Retail.

Over eleven years in the Automotive sector, but can adapt to any industry as required, metrics are often similar. Always focused on how to improve data handling, quality, efficiency, accuracy – for better business reporting. I have advanced Microsoft Excel skills with utilisation of VBA, SQL, and Power Query. I can build dashboards in Tableau, Power BI, Looker, Domo; more recent work has involved engineering ETL dataflows in Tableau Prep.

See more

Experience Level

Expert
Expert
Intermediate
Intermediate
Intermediate

Language

English
Fluent

Work Experience

Cost Data Analyst (contract) at BAE Systems
March 3, 2025 - September 26, 2025
Costing-focused role within Defence PMO; automation of Excel-based financial reporting; analysis of SAP actuals vs forecast to assess current spend and predict final project spend; requires SC clearance.
Aftersales Data Analyst (permanent) at Aston Martin
July 3, 2023 - November 8, 2024
Worked in Automotive Quality and Warranty, Data & Strategy; Aftersales data migration into Salesforce/Tableau; built dashboards in Domo, Tableau, Salesforce; created ETL dataflows in Tableau Prep; SME for Aftersales datasets.
Data Analyst (contract) at IWG / Regus
March 6, 2023 - May 31, 2023
Supported Office Fit-Out project team; built a procurement costing tool in Excel; analyzed past projects to estimate future costs; enhanced automation in existing reports.
Senior Retail Data Analyst (contract) at Superdry
July 5, 2021 - July 29, 2022
Supported Commercial Finance with automated Looker dashboards; cross-functional collaboration with Marketing and Operations; built automated financial/operational/merchandise dashboards; Looker mobile/tablet usage for area/store managers; extracted insights from store and ecommerce data.
Excel Data Consultant (contract) at BankBI
November 12, 2019 - January 29, 2021
Built bespoke Excel/VBA reporting solutions for global banks/credit unions; automated output PDFs for thousands of Credit Unions; created SQL store procedures for Power Query.
Data Analyst (contract) at Veritas Technologies
June 10, 2019 - November 1, 2019
Supported EMEA BI planning and reporting; developed prospective customer funnel/pipeline reports from Oracle; budget planning with regional heads.
Operations Data Quality Analyst (permanent) at BMW Financial Services
March 12, 2015 - February 1, 2019
Validated KPIs for Munich head office; developed BI data dictionaries; implemented Conduct Risk/Compliance dashboard with 100+ metrics; prepared data for FCA/IFRS9; developed SQL queries; automated MI outputs; self-serve SAP BO reports; supported eCommerce project team; liaison with Data Management and Risk teams.

Education

BEng Honours Mechanical Engineering at Brunel University
September 2, 1996 - June 23, 2000

Qualifications

Add your qualifications or awards here.

Industry Experience

Manufacturing, Financial Services, Retail, Software & Internet, Real Estate & Construction