Jim Roberts

Data Analyst

HSBC•  June 2023 - Present

Leading European Central Bank (ECB) reporting project; employing Python for data automation and analysis. Designing and managing data pipelines for vulnerability reporting with Python and SQL. Creating dynamic Power BI dashboards for data visualisation and stakeholder reporting. Conducting database maintenance using SQL Server and Oracle SQL Developer.

Higher Statistical Officer, Data Manager

Office for National Statistics•  June 2020 - June 2023

Recognised member of the Government Statistician Group (GSG). Led Health Index project; used Python libraries for data analysis and modelling. Managed data warehousing with GCP BigQuery; automated pipelines with Python. Conducted SQL-based reporting on COVID-19 and mortality rates. Oversaw GitHub for version control and team collaboration. Performed ad-hoc statistical analyses for external organisations.

Data Analyst

IN-SYNC Group•  August 2019 - March 2020

Updated and maintained databases with SQL (SSMS, SSIS, SSRS); ensuring data integrity. Developed and tested Python and R code for statistical modelling and business analysis. MS Excel and VBA for data manipulation and automated reporting.

Analyst

GQR Global Markets•  July 2019 - August 2019

Built and maintained a network within the quant space; focused on Fixed Income. Conducted interviews and negotiations; applied analytical skills to meet targets and KPIs.