Senior Data Engineer

Location: Glasgow, Scotland, United Kingdom

Team: Data Team | Reports to: Data Lead

• 
  
• Oversee the design and development of our BI stack, focusing on data transformation and development using SQL Server and the Microsoft BI stack.
  
• Develop complex self‑service data models using tabular semantic models, Power BI dashboards, and paginated reports to provide actionable insights.
  
• Manage extraction and integration of data from various business systems using APIs and SFTP.
  
• Maintain and enhance existing data frameworks, infrastructure, and solutions to ensure data accuracy, availability, and timeliness.
  
• Conduct in‑depth peer reviews and provide feedback to ensure the quality and reliability of data solutions.
  
• Lead and execute BI projects, working closely with the Product Owner to manage planning, prioritisation, and alignment with business objectives and timelines.
  
• Train, mentor, and support Data Engineers and analysts, fostering continuous learning and development.
  
• Actively participate in and lead Agile ceremonies, such as sprint planning, backlog refinement, and retrospectives, to improve team efficiency and output.
  
• Collaborate closely with cross‑functional teams to understand data requirements, gather feedback, and deliver impactful data insights.
  
• Educate and train business stakeholders on how to leverage data tools and insights effectively.
  

• 
  
• Advanced proficiency in SQL for writing, optimising, and troubleshooting complex queries; extensive experience with SQL Server and Power BI.
  
• Working knowledge of Microsoft Fabric, Azure Data Factory, Synapse, or equivalent cloud tools.
  
• Strong experience designing, building, and managing ETL processes and data pipelines to ensure data integrity and quality.
  
• In‑depth understanding of data warehousing principles, dimensional modelling, and best practices in data architecture.
  
• Proven experience developing sophisticated dashboards in Power BI, creating tabular semantic models, and writing DAX measures or equivalent.
  
• Strong scripting skills in PowerShell, Python, and C# for automation and advanced data manipulation.
  
• Excellent skills in developing test plans, conducting tests, and ensuring the quality and accuracy of data solutions.
  
• Exceptional analytical thinking and problem‑solving skills with a proven ability to solve complex data‑related challenges.
  
• Experience managing BI projects, including task prioritisation, stakeholder management, and project delivery.
  
• Excellent communication and collaboration skills to work effectively with cross‑functional teams and business users.
  

We are the Nucleus Group Services Limited and we help make retirement more rewarding. At Nucleus, people come first—whether it’s our colleagues or the advisers and customers we support. We work hard, celebrate hard, and create a platform that puts the customer centre stage.

Inclusion and diversity are embedded in our culture and everything we do. We focus on creating a fair, balanced, and transparent financial services sector and foster continuous learning and development for all team members.

Non‑contributory pension, bonus, enhanced parental leave, paid time off for emergencies, health and wellbeing initiatives, and flexible working options.

Interested candidates should reach out to our recruitment team via the contact details on our career portal. We look forward to connecting with talented professionals who want to make a real difference at Nucleus Financial.