Main
Julian Collins
I have a twenty year career as a data professional, working with both official financial statistics and healthcare data. Most recently I designed and developed a data warehouse of linked healthcare data for 250k patients at a group of major NHS Trusts in London.
My expertise lies in uncovering meaning in data - to drive forward quality improvements and to tell stories that can make a difference.
Currently looking for a position in healthcare analytics that allows me to exploit and develop my skills in R, data quality development, statistical analysis and visualisation.
Industry Experience
I think that a code-based approach to analysis is essential for transparency and reproducibility - it also empowers teams to collaborate effectively. A data pipeline of Source > R > Rmarkdown is ideal.
Data Manager
King’s Health Partners AHSN
London, UK
2019 - 2014
- Designed and developed a data warehouse within MS-SQL Server, for diabetes care within the King’s Health Partners (AHSN) Institutue for Diabetes, Endocrinology and Obesity, linking patient-level data from more than twenty data sources, drawn from GSTT and KCH Foundation Trusts, Primary Care, Community Services and public sources. This pseudonymised data covered 250k people with diabetes, with tens of millions of observations.
- Using data pipeline SQL Server > R > Rmardkdown, produced a wide range of data and reports relating to the healthcare and outcomes of people with diabetes, including:
- cohort studies investigating renal disease progression; ethnic variation in eye complications; diabetes outcomes in patients with prostate cancer
- population studies highlighting variation in care and outcomes linked to deprivation/ethnicity/age, co-morbidities and service usage
- audits into clinical services, medication reviews, NICE guidelines compliance
- compiled National Diabetes Audit return for GSTT, enabling the trust to participate for the first time and successfully bringing together multiple sources to provide a detailed data picture that highlighted the excellent outcomes being delivered to Type 1 patients.
- Collaborated with/presented to external, including international, partners of the AHSN (pharmaceutical and medical device companies, AI data consultants) highlighting the data warehouse outputs.
- Regular, routine experience of home-working, including managing projects and teams remotely.
Data Analyst
GSTT NHS Foundation Trust
London, UK
2014 - 2012
- The Diabetes Modernisation Initiative was a multi-year programme which brought together acute trusts, primary care, CCGs, community services and patient groups to improve health outcomes and services for people with diabetes in Lambeth and Southwark.
- Worked with programme leads to design a range of dashboards and storyboards that monitored monthly progress against projects goals and KPIs and drove activity. Designed bespoke monthly programme storyboard that focussed on current priorities, highlighting areas for discussion, and items of particular success or concern.
Sector Statistician
Office for National Statistics
London, UK
2010 - 2009
- Led a team of analysts compiling and publishing statistics relating to corporate activity on a quarterly and annual basis. Main outputs were sectoral data for quarterly/annual GDP and quarterly profitability publication.
- In addition to technical tasks relating to data compilation and consistency checking, this role required a range of research and analytical work to be conducted in order to understand trends at sector, sub-sector and business levels. Research activities would include working with the Business Survey teams to understand sampling frames and company response rates; confronting survey data with a range of other sources; analysing published corporate accounts; monitoring trade press.
- Explained data movements to a range of users, including national financial journalists (e.g. FT, BBC, Guardian) and discussing with expert customers such as Bank of England Monetary Policy Committee analysts.
Publications Manager
Office for National Statistics
London, UK
2008 - 2007
- Led a team compiling regional and local breakdowns of GVA and Household Income. These data were used to calculate UK structural funds allocations from the EU.
Statistical Analyst
Office for National Statistics
London, UK
2007 - 2001
- Data compilation and analysis for UK Balance of Payments
- I represented the UK on a joint EU/ECB task force investigating data coherence and consistency across data frameworks and member states.
Education
MA Hons Geography 2:1
University of St.Andrews
Fife, UK
1998 - 1994
- honours studies included statistics and GIS
- sub-honours studies in psychology, social anthropology and medieval history
Other Data Science
I favour the tidyverse packages within R, whilst always remaining open to other approaches.
TidyTuesday’ data visualisation challenge
https://nsgrantham.shinyapps.io/tidytuesdayrocks/
N/A
2020 - 2019
- Twitter community participating in weekly data visualisation challenge.
- Filter by User = ‘JCollinsData’
Selected Publications and Posters
Screening for co-existing thyroid and coeliac disease in type 1 diabetes. An audit of practice against updated NICE guidelines.
Abstract
N/A
2019
- co-author
Economic impact and associations of recurrent diabetic ketoacidosis in type 1 diabetes
Conference Paper
N/A
2015
- co-author