Contract Type: Permanent Location: Edinburgh or Glasgow or Alderley Park (Wilmslow) Working Style: Hybrid - 50% from home / 50% office based The Lead Sonata SME provides specialist knowledge and guidance across the Bravura Sonata platform, ensuring the platform is effectively designed, configured, enhanced, and operated in alignment with business and technology objectives. The role acts as a key advisor and subject matter expert across product configuration, platform capability, solution design, business process alignment, change delivery, and continuous improvement. The Lead Sonata SME works closely with technology teams, business stakeholders, delivery teams, and external vendors to ensure Sonata remains stable, scalable, and fit for purpose. <h3 style="margin:0.0cm;font-size:16.0pt;font-family:'Arial Black', sans-serif">Key Responsibilities:</h3> Solution Design, Configuration & Change Delivery <ul style="margin-top:0.0cm;margin-bottom:0.0cm" type="disc"> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Provide Sonata expertise across platform enhancements, projects, and strategic initiatives.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Translate business requirements into scalable Sonata solutions, covering configuration, workflows, rules, product setup, processes, and integration impacts.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Review proposed changes, identify risks and dependencies, and ensure alignment with platform standards and business objectives.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Provide design assurance and guidance to delivery teams throughout the change lifecycle.</li> </ul> Platform Governance & Business Alignment <ul style="margin-top:0.0cm;margin-bottom:0.0cm" type="disc"> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Provide governance over Sonata configuration, usage, and platform practices.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Ensure solutions align with business needs, regulatory requirements, and Sonata platform strategy.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Partner with business and technology stakeholders to define improvements, challenge requirements where appropriate, and identify optimisation opportunities.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Support prioritisation of platform enhancements and continuous improvement initiatives.</li> </ul> Testing, Releases & Vendor Engagement <ul style="margin-top:0.0cm;margin-bottom:0.0cm" type="disc"> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Provide Sonata expertise across testing, release, and implementation activities.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Support solution validation, release readiness, and post-release assurance.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Act as a key point of contact supporting product discussions, upgrades, roadmap alignment, and platform capability assessments.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Contribute to platform governance forums and strategic technology decisions.</li> </ul> Knowledge & Capability Development <ul style="margin-top:0.0cm;margin-bottom:0.0cm" type="disc"> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Maintain Sonata standards, documentation, and knowledge assets.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Promote consistent platform practices and knowledge sharing across delivery, support, and delivery teams.</li> <li style="margin-bottom:8.0pt;line-height:107%;margin-top:0.0cm;margin-right:0.0cm;font-size:12.0pt;font-family:Arial, sans-serif">Coach teams on Sonata capabilities and support the reduction of platform knowledge dependency.</li> </ul> <h3 style="margin:0.0cm;font-size:16.0pt;font-family:'Arial Black', sans-serif">What you will bring to the role:</h3> <h3 style="margin:0.0cm;font-size:16.0pt;font-family:'Arial Black', sans-serif">Technical Skills </h3> <ul style="margin-bottom:8.0pt;margin-top:0.0px"> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Good understanding of how an Oracle DB operates</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Awareness of OracleAQ and the creation of JMS messages</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Knowledge of the Sonata data model would be desirable</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">A good understanding of the technology and software that underpins the Sonata application</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Ability to write SQL queries (on an Oracle and/or SQL Server DB)</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Detailed knowledge of the Sonata Application including <ul style="list-style-type:circle;margin-top:0.0cm;margin-bottom:8.0pt"> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Configuration capabilities</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Sonata job setup</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Use of transformation scripts</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Flexibility of users/groups/permissions to allow targeted access to Sonata</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Single Sign On setup using Azure Entra</li> </ul> </li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">A good understanding of the Sonata installer process</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Awareness of how a Source of Truth is structured</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Using testing tools such as SOAPUI or ReadyAPI be able to construct SBS requests</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Ability to diagnose performance issues</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Experience with successful implementation of return to trunk upgrades</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Good knowledge of Operational Data Store (ODS) and Wherescape Red application</li> </ul> <h3 style="margin:0.0cm;font-size:16.0pt;font-family:'Arial Black', sans-serif">Nice to have</h3> <ul style="margin-bottom:8.0pt;margin-top:0.0px"> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Knowledge of monitoring tools (e.g App Dynamics, Logic Monitor)</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Sonata Workflow knowledge</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Experience in managing multiple Sources of Truth</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Service Now experience</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Awareness of agile methodology</li> </ul> <h3 style="margin:0.0cm;font-size:16.0pt;font-family:'Arial Black', sans-serif">Other Skills</h3> <ul style="margin-bottom:8.0pt;margin-top:0.0px"> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">A wide knowledge of UK Pensions</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Ability to problem solve and troubleshoot</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Ability to multi task effectively</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Able to remain calm under pressure</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Good attention to detail</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Can-do attitude</li> <li style="margin:0.0cm 0.0cm 8.0pt 0.0px;line-height:107%;font-size:12.0pt;font-family:Arial, sans-serif">Always striving for continuous improvement</li> </ul> If you feel you’d be a great fit for Royal London but don’t meet every requirement, we’d still love to hear from you. Research shows some candidates are less likely to apply unless they meet 100% of the criteria - if you meet most requirements and are keen to learn, we encourage you to apply! <h3 style="margin:0.0cm;font-size:16.0pt;font-family:'Arial Black', sans-serif">About Royal London</h3> We’re the UK’s largest mutual life, pensions and investment company, offering protection, long-term savings and asset management products and services. Our People Promise to our colleagues is that we will all work somewhere inclusive, responsible, enjoyable and fulfilling. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve. We've always been proud to reward employees by offering great workplace benefits such as 28 days annual leave in addition to bank holidays, an up to 14% employer matching pension scheme and private medical insurance. <h3 style="margin:0.0cm;font-size:16.0pt;font-family:'Arial Black', sans-serif">Inclusion, diversity and belonging</h3> We’re an inclusive employer. We celebrate and value different backgrounds and cultures across Royal London. Our diverse people and perspectives give us a range of skills which are recognised and respected – whatever their background.

Lead Sonata SME (Alderley Edge, GB) @ Royal London Careers

About this role

Ready to apply?