Senior Data Analyst
Natcansat
The Clatterbridge Cancer Centre Nhs Foundation Trust, Wirral
NATCANSAT is a national team with a range of clients including NHS England, the Department of Health, the National Cancer Action Team, cancer networks, NICE, CCGs and Trusts. I am responsible for processing and cleaning extracts of large national healthcare data including Hospital Episode Statistics (HES) and Radiotherapy Dataset (RTDS). I have linked and manipulated the HES data to provide innovative pathway analysis and have linked multiple datasets such as HES, RTDS, Cancer Registry data and ONS mortality data for outcome and research purposes such as the burden and cost of ongoing treatment of those surviving cancer. I have used my knowledge of HRGs to analyse their use in HES data and to translate activity data into quantifiable benefits in financial terms.I have extensive understanding and experience of Microsoft products including Access, Excel, SQL Server and SSIS and use them on a daily basis to clean, interrogate, manipulate and analyse data. I use SSAS to produce online OLAP cubes and Excel to produce offline OLAP cubes and consider that I have expert knowledge of Excel and Access. My work involves routine use of statistics such as mean, median, interquartile range, pie charts, bar charts, histograms, rates per million population, percentages, Box and Whiskers Plots and STP Charts.I work well with my colleagues and as a member of the small team, I am able to adapt my approach and work flexibly to achieve our objectives. As some of the team are office-based and others are home-based, effective communication has been essential. I often work on a section of a project alone, unsupervised and then liaise with another team member to produce the final output.