Second Line Analyst
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
Job description
DHU’s Second Line Analysts provide technical leadership within the Data Services department and are responsible for designing, developing, and governing enterprise reporting and business intelligence solutions across DHU. The role acts as a technical escalation point for complex reporting challenges and leading the development of scalable Power BI, SSRS, and Excel based solutions. Advanced SQL development and modern reporting architecture is a key part of the role. You will work closely with internal and external stakeholders to translate complex operational requirements into robust analytical solutions whilst ensuring reporting platforms remain secure, performant, and maintainable. Second Line Analysts are responsible for maintaining technical standards, mentoring First Line Analysts, and driving continuous improvement through modern development practices and adoption of new technologies.
Responsibilities
Act as a technical escalation point for complex reporting issues
Provide technical leadership across Data Services
Promote good data practices throughout DHU
Support citizen developers positioned within the operational areas of the organisation with complex queries
Establish and maintain reporting standards
Review technical solutions developed by colleagues
Contribute to and challenge the technical roadmap of Data Services
Design and develop Power BI, SSRS, and Excel solutions
Develop semantic models and reusable datasets
Manage deployment pipelines across Development, Test, and Production environments
Utilise strict version control and release management practices
Optimise report performance and usability
Lead the standardisation of report design for the organisation, with a focus on UX/UI and data storytelling
Design advanced SQL solutions
Optimise database object performance
Support data warehouse development
Troubleshoot complex data issues
Translate business requirements into technical solutions
Lead technical design discussionsEvaluate new technologies
Ensure solutions are scalable and maintainable
Own and maintain technical documentation
Promote development standards
Ensure reporting solutions comply with governance and security requirements
Support data quality improvement initiatives
Requirements
Significant experience in analytics based enviroment
Advanced SQL development
Strong microsoft excel skills
Performance optimisation
Experience in managing Power BI deployment pipelines
Benefits & conditions
Your benefits continue with you, supporting your health, wellbeing, and future.
Supporting your growth at every stage.
We’ll support your health, happiness and future with benefits that put you first:
Access to the NHS pension scheme (we’ll also honour your existing NHS pension pot and holiday entitlement if you’re transferring)
Wellbeing support
Flexible working options
Career growth and development opportunities
Learning that shapes your career.
With us, development is part of our culture. From essential training and apprenticeships to supportive leadership and career pathways, we’ll help you grow in ways that matter to you. Because when our people thrive, so do our patients and communities.
Together, reflecting our communities.
Culture & Inclusion Great work happens when everyone feels seen, supported, and valued. We welcome colleagues from all backgrounds and proudly support the Armed Forces community.
Inclusion and belonging are essential to our values, and together we make the difference. As a Disability Confident Employer, we welcome candidates to share any support or reasonable adjustments they may need during the recruitment process.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…