
John Johnson
Senior Analyst
Hello, I'm John. I'm a Senior Information Analyst with 5 years of experience. I enjoy writing complex SQL & designing aesthetic dashboards. I specialise in Power BI.
About Me
After completing my Master’s in Aerospace Engineering, I followed my passion for data and transitioned into analytics. I now work as a Senior Analyst for the NHS, where I transform data into meaningful insights that support better decisions and improve patient outcomes.
I’m deeply curious about technology and problem-solving! I love the challenge of finding elegant, data-driven solutions to complex problems. My core stack includes SQL, Power BI, Excel and Python, but I’m always exploring new tools and ideas. Recently, I’ve been experimenting with Next.js to build modern, interactive data analytics dashboards. I entered this idea and won the Onyx Data August Challenge, which strengthened my drive to keep innovating in the analytics space.
I’ve also been exploring the world of Large Language Models (LLMs) and automation using the OpenAI API experimenting with real-world applications that make data insights more accessible and actionable.
Alongside this, I’m building a micro SaaS startup called Opiniax, which helps local businesses turn their Google reviews into beautiful, insight-driven websites that highlight what customers love most.
I’m not actively looking for a new role, but I’m open to data leadership opportunities where I can combine technical expertise with mentoring and strategy.
When I’m not diving into data, I love travelling (16 countries and counting)! I also enjoy hiking, watching movies, and flying my drone to capture new perspectives of the world. Check out some of my photos here!
My Experience
Senior Information Analyst
Birmingham and Solihull Mental Health Trust
I'm now a Senior Information Analyst. I lead a small team of analysts to leverage all of their technical skills to turn raw data into actionable insights to help the trust continue to provide outstanding mental health services. My primary focus is to implement the use of Power BI across the trust, this will in turn free up analysts time to create more insightful and predictive analysis.
Jun 2023 - PresentReporting Analyst
Mid & South Essex Hospital Partnership
In Dec 2021 I was promoted, in this new role I focused heavily on Power BI. I utilized Power BI extensively to create dashboards with high impact visuals to showcase key data trends. I also played a key part in automating and improving existing processes to increase efficiency and accuracy.
Dec 2021 - Jun 2023Reporting Officer
Mid & South Essex Hospital Partnership
Following my passion for data I joined the healthcare analytics team. In this role I created and submitted mandatory & statutory reports to NHS England weekly. I was also learning how to write complex SQL to complete ad hoc data requests for various stakeholders.
Aug 2021 - Dec 2021Senior Booking Officer
Mid & South Essex Hospital Partnership
In Feb 2021 I was promoted, in this new role I line managed booking officers and made key decisions on how best to utilise resources. I was also tasked with creating reports to identify gaps in staffing & potential cost saving measures, this is what initially sparked my passion for data.
Feb 2021 - July 2021HR Booking Officer
Mid & South Essex Hospital Partnership
During the COVID Pandemic I went back to work at the NHS where I had previously worked during Uni holidays. I worked on ensuring there was safe staffing across the three hospital sites.
Jul 2020 - Feb 2021Masters Degree in Aerospace Engineering
University of Leicester
Graduated with Second Class Honours. My final project was on designing aerodynamic components for an FIA Formula One Car.
Sep 2019 - Jun 2020Bachelors Degree in Aerospace Engineering
University of Leicester
Graduated with Second Class Honours. My final dissertation was on drone usage policies in universities.
Sep 2015 - Jun 2019My skills
- T-SQL
- PostgreSQL
- MySQL
- Excel
- Power BI
- Data Visualisation
- Analysis
- Leadership
- Team Working
- UI Design
- Python
- HTML
- CSS
- JavaScript
- Next.js 15
- Tailwind CSS
- LLMs
My projects
Contact me
Please contact me directly at example@gmail.com or through this form.