£40,000 per annum | Fishersgate, Brighton | Three days per week in the office
Department IT & Data · Reporting to IT Director
We’re looking for an experienced Data Analyst to lead three Junior Data Analysts while staying hands‑on with Power BI and SQL. Prior experience directly line‑managing staff is essential.
You’ll have scope to improve how we report. That could mean working with a clinical team to understand why activity figures differ, redesigning a dashboard so managers can spot a change in performance, or automating a monthly report that takes hours to prepare.
What you’ll do
- Line‑manage three Junior Data Analysts. You’ll allocate work, set objectives, hold regular one‑to‑ones and performance reviews, and address performance or delivery concerns. You’ll also coach the team in Power BI and SQL.
- Build and maintain Power BI dashboards, datasets and data models. Write and optimise SQL queries in SQL Server Management Studio (SSMS) to extract data, investigate trends and resolve discrepancies.
- Own the reporting timetable, covering internal performance reports, departmental KPIs and NHS commissioning returns, including SUS (Secondary Uses Service) and SLAM (Service Level Agreement Monitoring). You’ll oversee preparation, validation and submission against agreed deadlines.
- Act as the main contact for day‑to‑day reporting requests. You’ll work with colleagues to understand the decisions they need to make and explain findings clearly to managers and senior stakeholders.
- Work with IT colleagues and suppliers to improve our data warehouse, integrations and reporting processes. You’ll look for opportunities to automate manual work and develop your Python skills.
- Set clear standards for data quality, documentation and confidentiality in line with GDPR and our information governance requirements.
What you’ll bring
- Direct line management experience. You’ll have held formal responsibility for direct reports, including setting priorities, conducting one‑to‑ones, reviewing performance and supporting individual development.
- Hands‑on analytical experience. You’ll have worked as a Data Analyst or in a similar role, developing Power BI dashboards, writing and optimising SQL queries, and using SSMS to investigate data.
- Clear communication and sound judgement. You’ll be able to explain findings to non‑technical colleagues, check that reported figures reflect the activity behind them, and balance your own analytical work with the team’s deadlines.
- Experience with NHS or other regulated‑sector data, DAX, Python, data warehousing, ETL or Microsoft Azure would be welcome. If you’re keen to learn Python, you’ll have opportunities to apply it to reporting and automation work.
If you enjoy developing analysts and want to keep building reports yourself, we’d welcome your application.