01
Engineering foundation
A Master’s and Bachelor’s Degree in Aerospace Engineering shaped a structured approach to complex problem-solving.
Senior Information Analyst · NHS
Open to data leadership conversations
Turning complex data into decisions people can act on.
I use SQL, Power BI, automation and analytical leadership to turn complex data into clear insight that supports better decisions.
NHS analytics
Data / People / Decisions
ProfileJJ / 01
John Johnson
Senior Information Analyst
Clear thinking
Useful systems
Operating principles
How I create useful change.
- 01
Insight for better decisions
Turn complex healthcare data into clear, useful insight that supports informed decisions and better patient outcomes.
Principle 1 of 4 - 02
Reporting that creates capacity
Build Power BI reporting that makes key trends easier to understand and creates more space for deeper analysis.
Principle 2 of 4 - 03
Practical automation
Improve recurring processes through automation, with a focus on efficiency, accuracy and accessible insight.
Principle 3 of 4 - 04
Technical leadership
Lead analysts and help their technical skills translate into useful outcomes for teams and stakeholders.
Principle 4 of 4
About
Curiosity, structured thinking and data made genuinely useful.
Aerospace thinking. Healthcare impact.
After completing my Master’s in Aerospace Engineering, I followed my passion for data and transitioned into healthcare analytics.
I now work as a Senior Information Analyst for the NHS, using SQL, Power BI, Excel and Python to turn complex information into insight that supports better decisions and patient outcomes.
I continue to explore Next.js, large language models and the OpenAI API, while building Opiniax as a micro SaaS for local businesses.
Recognition
Onyx Data August Challenge
Won the Onyx Data August Challenge with a modern, interactive analytics dashboard built using Next.js.
View the winning project on LinkedIn(opens in a new tab)02
Healthcare analytics
NHS experience spans statutory reporting, Power BI delivery, process improvement and leading a small analyst team.
03
AI and automation
Exploring LLMs, the OpenAI API and automation to make data insight more accessible and actionable.
04
Product curiosity
Building modern analytics experiences with Next.js and developing Opiniax for local businesses.
Career ledger
Progression built through responsibility.
A path from operational healthcare roles into reporting, analytics and team leadership — with each step adding a clearer view of how data supports people and decisions.
Jun 2023 - Present
Experience
CurrentSenior Information Analyst
Birmingham and Solihull Mental Health Trust
I lead a small team of analysts, bringing together their technical skills to turn raw data into actionable insight that helps the trust continue to provide outstanding mental health services. My primary focus is implementing Power BI across the trust, freeing analysts' time for more insightful and predictive analysis.
Dec 2021 - Jun 2023
Experience
Reporting Analyst
Mid & South Essex Hospital Partnership
View details for Reporting Analyst
Promoted in December 2021, I focused heavily on Power BI, creating dashboards with high-impact visuals to communicate key data trends. I also played a key part in automating and improving existing processes to increase efficiency and accuracy.
Aug 2021 - Dec 2021
Experience
Reporting Officer
Mid & South Essex Hospital Partnership
View details for Reporting Officer
Following my passion for data, I joined the healthcare analytics team. I created and submitted weekly mandatory and statutory reports to NHS England while learning to write complex SQL for ad hoc stakeholder requests.
Feb 2021 - July 2021
Experience
Senior Booking Officer
Mid & South Essex Hospital Partnership
View details for Senior Booking Officer
Promoted in February 2021, I line-managed booking officers and made key decisions about how best to use resources. Creating reports to identify staffing gaps and potential cost savings is what first sparked my passion for data.
Jul 2020 - Feb 2021
Experience
HR Booking Officer
Mid & South Essex Hospital Partnership
View details for HR Booking Officer
During the COVID-19 pandemic, I returned to the NHS, where I had previously worked during university holidays, and helped maintain safe staffing across three hospital sites.
Sep 2019 - Jun 2020
Education
Masters Degree in Aerospace Engineering
University of Leicester
View details for Masters Degree in Aerospace Engineering
Graduated with Second Class Honours. My final project was on designing aerodynamic components for an FIA Formula One Car.
Sep 2015 - Jun 2019
Education
Bachelors Degree in Aerospace Engineering
University of Leicester
View details for Bachelors Degree in Aerospace Engineering
Graduated with Second Class Honours. My final dissertation was on drone usage policies in universities.
Capability matrix
Technical range, organised by purpose.
The tools matter, but the value comes from how they work together: reliable data foundations, understandable reporting, practical engineering and considered delivery.
05 capability domains
From raw data to a clear experience.
- 01
Data & Databases
- T-SQL
- PostgreSQL
- MySQL
- Excel
- 02
Business Intelligence & Visualisation
- Power BI
- Data Visualisation
- Analysis
- UI Design
- 03
Programming & Web
- Python
- HTML
- CSS
- JavaScript
- Next.js 15
- Tailwind CSS
- 04
AI
- LLMs
- 05
Leadership & Collaboration
- Leadership
- Team Working
The connecting thread is clear communication: choosing the right technical approach, then making the result useful to the people who rely on it.
Data / Product / People
Selected work
Ideas made tangible.
A selection of analytics, product, AI and creative work — each shaped around a different kind of problem, audience and experience.
Analytics Product
Project / 01
Gym Dashboard
An analytics dashboard for exploring gym membership, revenue, retention risk and audience trends.
My contribution
Designed and built the dashboard interface, organising operational KPIs and member distribution views into one focused experience.
- Next.js 15
- React
- TypeScript
- Dashboard
- Analytics
SaaS Venture
Project / 02
Opiniax
A SaaS platform that turns a local business's Google reviews and business details into a professionally hosted website.
My contribution
Building the product and web experience around review analysis, automated website creation and hosting for local businesses.
- SaaS
- Next.js
- Business Solution
- Google Maps API
AI Experiment
Project / 03
FlixFinder
A web app that converts natural-language film and television requests into read-only SQL, then queries an IMDb database for matching titles.
My contribution
Built the prompt-to-SQL flow and database query experience with Next.js, MySQL and the OpenAI GPT-3.5 API.
- MySQL
- Next.js
- Tailwind CSS
- GPT 3.5
- AWS Hosted Database
Creative Practice
Project / 04
Pure - David Oriakhi | Drone Music Video
A drone-filmed music video for Pure by David Oriakhi, captured on a DJI Mini 3.
My contribution
Filmed the video with a DJI Mini 3 and completed the editing and colour grading in Premiere Pro.
- Drone Flying
- Premiere Pro
- Editing
- Colour Grading
Contact
Let’s make complex things clearer.
Have a data challenge, leadership opportunity or product idea worth exploring? Send a note with a little context and the best email to reply to.
Current status
Open to data leadership conversations
Elsewhere
Use the form for a direct reply, or connect through one of the profiles above.