Second Line Analyst

Second Line AnalystLocation: DerbyWorking Pattern: Ful time, 37.5 hours per week, PermanentSalary: £47,440 ( Band 7)Drive Progress, support our people and shape how we work 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.As a Second Line Analyst, you will:Act as a technical escalation point for complex reporting issuesProvide technical leadership across Data ServicesPromote good data practices throughout DHUSupport citizen developers positioned within the operational areas of the organisation with complex queriesEstablish and maintain reporting standardsReview technical solutions developed by colleaguesContribute to and challenge the technical roadmap of Data ServicesDesign and develop Power BI, SSRS, and Excel solutionsDevelop semantic models and reusable datasetsManage deployment pipelines across Development, Test, and Production environmentsUtilise strict version control and release management practicesOptimise report performance and usabilityLead the standardisation of report design for the organisation, with a focus on UX/UI and data storytellingDesign advanced SQL solutionsOptimise database object performanceSupport data warehouse developmentTroubleshoot complex data issuesTranslate business requirements into technical solutionsLead technical design discussionsEvaluate new technologiesEnsure solutions are scalable and maintainableOwn and maintain technical documentationPromote development standardsEnsure reporting solutions comply with governance and security requirementsSupport data quality improvement initiatives We are looking for someone who has:Significant experience in analytics based enviromentAdvanced SQL developmentStrong microsoft excel skillsPerformance optimisationExperience in managing Power BI deployment pipelinesFor you, because great work starts with a supported team.Your benefits continue with you, supporting your health, wellbeing, and future. For more information on the full range of benefits available, click here. 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 supportFlexible working optionsCareer growth and development opportunitiesFor more information on the full range of benefits available click here. 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. 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. For more information on how DHU can support you, please click here.