Adaptable and diligent data migration analyst with 6 years' experience in data analysis and development. Specialised in ETL development, queries and transformation of unstructured data into structured datasets. Both in current and previous employment further skills acquired in data visualisation and code optimisation, and proficiency in Microsoft Office. Strong problem-solving and teamwork abilities and track record as a self-starter with can-do attitude. Seeking a more senior role in data and analytics to further my career towards strategic level; to leverage skills in transformation and visualisation to drive business insights and improve operational efficiency.

Thomas Watson

Adaptable and diligent data migration analyst with 6 years' experience in data analysis and development. Specialised in ETL development, queries and transformation of unstructured data into structured datasets. Both in current and previous employment further skills acquired in data visualisation and code optimisation, and proficiency in Microsoft Office. Strong problem-solving and teamwork abilities and track record as a self-starter with can-do attitude. Seeking a more senior role in data and analytics to further my career towards strategic level; to leverage skills in transformation and visualisation to drive business insights and improve operational efficiency.

Available to hire

Adaptable and diligent data migration analyst with 6 years’ experience in data analysis and development. Specialised
in ETL development, queries and transformation of unstructured data into structured datasets. Both in current and
previous employment further skills acquired in data visualisation and code optimisation, and proficiency in Microsoft
Office. Strong problem-solving and teamwork abilities and track record as a self-starter with can-do attitude. Seeking a
more senior role in data and analytics to further my career towards strategic level; to leverage skills in transformation
and visualisation to drive business insights and improve operational efficiency.

See more

Experience Level

Expert
Expert
Expert
Intermediate
Intermediate

Language

English
Fluent

Work Experience

Data Migration Analyst at Ecclesiastical Insurance Office PLC
March 1, 2022 - November 4, 2025
Code optimisation through indexation, writing targeted SELECT statements including JOIN and UNION ALL, integrating user stored procedures, defining and implementing database normalisation best practice guidelines. Designing database schemas (snowflake and star) for the to-be system, including the development of ETL processes and pipelines. Data visualisation via Power BI using DAX and SQL and migrating heritage data to new Power BI datasets. Writing T-SQL queries for data interrogation; including CTEs, subqueries, and building stored procedures, functions and views. Building tools in SQL Server Management Studio with source connection to Excel, employing Power Query, with a native database destination connection (read/write). For use by the technical, underwriting and finance systems teams for insurance policy maintenance and accounts management. Transforming unstructured data from legacy systems into new structured datasets, using varied techniques including data profiling, validation
Data Support Analyst at St James's Place Wealth Management
March 1, 2022 - March 1, 2022
Writing SQL queries and investigating the SJP Data estate to provide input into improving existing controls and processes within the data warehouse and surround systems. Updating client-facing data through instruction to development teams and through INSERT/UPDATE statements in SQL. Producing meaningful analysis/MI with the data in Excel spreadsheets and reports. Interpreting business requirements from a technical standpoint, identifying how to deliver the required change and managing delivery. Data support for a variety of client & partner data enquiries.
Project Management & Business Intelligence Consultant at FDM Group
August 1, 2020 - August 1, 2020
Based in London, deployment to client sites in Dublin and Cirencester. The consultancy included engagements at St James's Place Wealth Management (Cirencester, 08/2019-08/2020) and Deutsche Bank (Dublin, 08/2018-05/2019) focusing on BI development, data warehousing concepts, ETL transformations, data visualisation and stakeholder engagement. Responsibilities included supporting data migration and reporting for multiple clients and contributing to the DevOps lifecycle.

Education

BA (2:1) in Philosophy at The University of Essex
January 11, 2030 - June 1, 2017
BA (2:1) in Philosophy at The University of Essex
January 11, 2030 - June 1, 2017

Qualifications

PRINCE2 Foundation
January 11, 2030 - November 4, 2025
PRINCE2 Foundation Qualification
January 11, 2030 - November 4, 2025
Chartered Institute of Insurance membership
January 11, 2030 - November 4, 2025

Industry Experience

Financial Services, Professional Services, Software & Internet, Education

Experience Level

Expert
Expert
Expert
Intermediate
Intermediate

Hire a Data Analyst

We have the best data analyst experts on Twine. Hire a data analyst in Reading today.