Senior Data Engineer

Nucleus Financial; City of Edinburgh; On-site; GBP 45,000 - 70,000; Full time

Job summary

An innovative financial services company seeks a Senior Data Engineer to enhance their BI solutions and tools, focusing on data-driven decisions. The role involves leading projects, developing complex data models, and implementing ETL processes. Candidates should possess extensive experience in SQL and Power BI, with strong analytical and project management skills, to support the company's vision of building a leading retirement-focused platform.

Benefits

Pension

Bonus

Flexible working options

Health and wellbeing initiatives

Qualifications

• Advanced proficiency in SQL for writing, optimising, and troubleshooting complex queries.
• Strong experience in designing, building, managing ETL processes and data pipelines.
• In-depth understanding of data warehousing principles, dimensional modelling, and best practices.

Responsibilities

• Oversee the design and development of the BI stack, focusing on data transformation.
• Manage the extraction and integration of data from various business systems using APIs.
• Lead and execute BI projects, working closely with the Product Owner.

Skills

SQL

BI Tools

Data Warehousing

Power BI

ETL Processes

Scripting

Analytical Thinking

Project Management

Job description

Social network you want to login/join with:

We're looking for a Senior Data Engineer to join our data team to help design, develop, and implement solutions and tools for the business. Our purpose at Nucleus is to help the business make data driven decisions and support the wider team in delivering an exceptional customer proposition. We take an Agile approach to working which means we’re all involved in the analysis, development and testing of our data solutions. We experiment as we go to find the right solution, and we'd love for you to help us in our pursuit of achieving the best client outcomes utilising data.

Here are some of the things you'll get involved with in this role:

Responsibilities

• BI Development: Oversee the design and development of our BI stack, focusing on data transformation and development using SQL Server and the Microsoft BI stack.
• Advanced Data Modelling: Develop complex user self-service data models using tabular semantic models, Power BI dashboards, and paginated reports to provide actionable insights.
• Data Integration: Manage the extraction and integration of data from various business systems using APIs and SFTP.
• Maintain and Enhance Data Frameworks: Oversee the maintenance and enhancement of our existing data frameworks, infrastructure, and solutions to ensure data accuracy, availability, and timeliness.
• Code Review and Quality Assurance: Conduct in-depth peer reviews, and provide feedback and guidance to ensure the quality and reliability of data solutions.
• Project Management: Lead and execute BI projects, working closely with our Product Owner to manage planning and prioritisation. Ensuring alignment with business objectives and timelines.
• Mentorship and Training: Train, mentor, and support BI developers and analysts, fostering a culture of continuous learning and development.
• Participate and Lead Agile Ceremonies: Actively participate in and lead Agile ceremonies, such as sprint planning, backlog refinement, and retrospectives, to improve team efficiency and output.
• Cross-functional Collaboration: Collaborate closely with cross-functional teams to understand data requirements, gather feedback, and deliver impactful data insights.
• Data Literacy and Training: Educate and train business stakeholders on how to leverage data tools and insights effectively.

We’d like to hear from you if you have experience in the following technical areas:

Key Skills:

• Expertise in SQL and BI Tools: 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.
• ETL and Data Pipeline: Strong experience in designing, building, and managing ETL processes and data pipelines, ensuring data integrity and quality.
• Deep Knowledge of Data Warehousing: In-depth understanding of data warehousing principles, dimensional modelling, and best practices in data architecture.
• Advanced Dashboard and Semantic Model Development: Proven experience in developing sophisticated dashboards in Power BI, creating tabular semantic models, and writing DAX measures or equivalent tools.
• Proficiency in Scripting and Automation: Strong knowledge of scripting languages like PowerShell, Python, and C# for automation and advanced data manipulation tasks.
• Quality Assurance and Testing: Excellent skills in developing test plans, conducting tests, and ensuring the quality and accuracy of data solutions.
• Analytical Thinking and Problem Solving: Exceptional analytical and problem-solving skills with a proven ability to solve complex data-related challenges.
• Project Management Skills: Experience in managing BI projects, including task prioritisation, stakeholder management, and project delivery.
• Effective Communication and Collaboration: Excellent communication and collaboration skills to work effectively with cross-functional teams, stakeholders, and business users.

A little about us

Our purpose at Nucleus is to help make retirement more rewarding, with a vision to build the best retirement-focused platform in the UK. It is this purpose that drives everything we do. Whether you are working in a role that is customer-facing or not, you’ll need to be service-obsessed to work here.

It’s a fast paced and exciting environment, and one where we believe you will get the chance to fulfil your potential and do work that really matters, to you and our customers. We believe in you having your own chunk of responsibility and being trusted to make things happen.

Nucleus’ culture is something our people believe sets us apart from other places they’ve worked. This gives you an insight into what it is like to work with us.

Inclusion and diversity at Nucleus

As with most things in life, who cares, wins. We really care about inclusion.

For us this is not a box-ticking thing, it’s a commercial imperative. It isn’t about being PC. It’s about being future-relevant and durable. Find out more on our.

We offer a generous blend of benefits for the things that really matter to our people, including pension, bonus, enhanced parental leave, paid time off for emergencies, health and wellbeing initiatives and flexible working options.