Senior Data Engineer

Job Description

Role Specification: Senior Data Engineer

Team:
Data Team

Reports to:
Data Lead

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 Data Engineers 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.

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
We are the Nucleus Group Services Limited and we help make retirement more rewarding. Here at Nucleus, people come first - whether it's our colleagues, or the advisers and customers we support, we know that working in partnership and collaboration leads to the best outcomes. Together, we've shaped the platform to how it is today. We work hard, and we celebrate hard too.

Our ambition is to create a platform with a difference, putting the customer centre stage meant tearing up the rule book and starting from scratch. We've come a long way since then, but our mission remains just as focused. That's why our culture, values, and social responsibility are things we keep at the top of our agenda – because we know they matter and have a big impact.

Our culture is one of the many things that sets us apart from the pack. We want to have an environment where our people feel that they can make a real difference, know they'll be rewarded for their efforts and more importantly, enjoy themselves at work.

Are we a perfect match? Check out this video and find out

Inclusion and diversity at Nucleus
As with most things in life, who cares, wins. We really care about inclusion.

For us it's not a tick box exercise; inclusion and diversity are embedded in our culture and everything we do. It's a commercial imperative. It isn't about being PC. It's about being future-relevant and durable. We owe it to ourselves and the industry to ensure we are playing our part in creating a fair, balanced and transparent financial services sector.

More diversity means broader experience, a wider set of perspectives and a better collective ability to problem-solve. And it means being more representative of customer groups, which supports areas such as product development.

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

If you'd like to find out more about us or the role, please get in touch with our recruitment team.