Skip to content
View SianReilly's full-sized avatar

Block or report SianReilly

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
SianReilly/README.md

Hi there 👋

Data & Intelligence Analyst at Westminster City Council, modelling and visualising crime, children's services and population data to inform statutory decisions and financial planning.

I came to analytics from environmental science, via ESG consultancy at Onnu and solutions engineering at Deepki, and I'm completing an MSc in Data & Analytics alongside the role. I hold ONS Secure Researcher accreditation. I'm at my best turning technical work into something the people who have to act on it can actually use - service leads, councillors, residents.

🔭 Currently working in Python, R, SQL and DAX.

LinkedIn · HyperionDev Portfolio



Selected work

Modelling

Drivers of health inequality - LASSO regression on ward-level life expectancy, using regularisation to select from a large set of correlated Marmot indicators where a standard model would overfit. Run separately across male, female and overall to avoid averaging away differing drivers as part of the Common Progress Measures project (CPM). CPM Dashboard

UK local authority nearest-neighbour benchmarking - clustering every local authority across England, Wales, Scotland and Northern Ireland on children's services demand indicators. The interesting problem was less the clustering than reconciling four national statistical frameworks with different definitions, geographies and publication cycles. Clustering Tool Dashboard

Spatial analysis

Cumulative Impact of Licensed Premises - hotspot analysis combining crime, noise, antisocial behaviour, footfall and licensed premises density, feeding a statutory assessment. Nominated for a Local Government Association award.

ArcGIS web applications for community hubs and heat networks, built so non-technical service teams can self-serve spatial data.

Tools & dashboards

Children's demographics explorer - Streamlit app for exploring child population decline and demand projections.

Power BI dashboards using DAX and dynamic narrative text, one example dashboard: suitability assessment for solar PV across the council's housing stock.


Toolkit

Languages Python, R, SQL, DAX
Libraries pandas, NumPy, scikit-learn, seaborn, plotly, bokeh, tidyverse, dplr, ggplot2
Analysis Regularised regression, clustering, spatial analysis, ETL pipelines
Visualisation & BI Streamlit, Power BI, Power Query, [plotting libraries]
Geospatial ArcGIS Pro, ArcGIS Experience Builder, ModelBuilder, QGIS
Ways of working Git, Agile (Professional Scrum Product Owner)
Familiar with YAML, HTML, Java
Accreditations ONS Secure Researcher, Lead ISO 14001 Internal Auditor, Associate of the Institute of Sustainability and Environmental Professionals (ISEP)

A note on the work

Most of what I do sits with sensitive data - individual-level records, statutory analysis, and outputs that affect real decisions about real people. A genuine part of holding ONS Secure Researcher accreditation is knowing when not to publish something: suppressing findings where counts are too small to be disclosed safely, even when they're interesting.


Experience

Data & Intelligence Analyst - Westminster City Council 07/2024 – present, London See selected work above.

Customer Solutions Engineer - Deepki 01/2023 – 06/2024, London ESG SaaS for real estate.

  • Built and configured platforms for real estate clients to visualise and act on their ESG objectives.
  • Supported implementation of ISAE 3000 assurance, handling configuration and ETL requests for the UK team.
  • Developed custom tooling to turn client data into visualisations that informed strategic decisions.

Sustainability Operations Officer - LSHTM & Bloomsbury Environmental Group 03/2022 – 12/2022, London / remote

  • Lead internal auditor for environmental management systems across LSHTM, Birkbeck and SOAS.
  • Collated, analysed and reported Scope 1, 2 and 3 emissions data through platforms including Envizi.
  • Initiated monthly reporting with the Estates team to link building utilisation to energy use and emissions.

Lead ESG Consultant & Environmental Engineer - Onnu 09/2021 – 03/2022, London / South Africa / remote

  • Managed carbon offset projects, calculating potential emissions reductions and using GIS to stratify and define project boundaries.
  • Provided UX guidance and templates for web design.

Education

MSc Data & Analytics - Northumbria University 09/2025 – present · averaging 74% (1st class)

Software Engineering Bootcamp - HyperionDev 12/2023-05/2024 · 99%

BSc Environmental Science, 1st Class Honours - University of St Andrews 09/2016 – 07/2021


Currently

Studying regularisation and model interpretability properly, and looking at where machine learning meets sustainability reporting - the two threads I've been pulling on since I graduated.

Popular repositories Loading

  1. HyperionDev HyperionDev Public

    HyperionDev Tasks

    Python

  2. byb_project byb_project Public

  3. finalCapstone finalCapstone Public

    Python

  4. SianReilly SianReilly Public

  5. Dashboard_UCL_Oxford Dashboard_UCL_Oxford Public

    dashboard_UCL_Oxford

    Python

  6. Child_Pop_GLA Child_Pop_GLA Public

    Children_Population

    Python