Data Engineer

Job description

Nucleus Financial Platforms runs its data estate on Microsoft Fabric. The Data Engineering team ingests data from the group's platform systems and enterprise tools, transforms it through a four layer architecture, and delivers it as a curated data warehouse and semantic model layer. That output supports management information, financial reporting, self service analytics, an emerging AI capability, and regulatory returns under FCA and PRA obligations. 
As a Data Engineer you will build and maintain the pipelines, warehouse objects and reporting models that make that happen. You will work within an established architecture and a documented set of design standards, taking individual pipelines and warehouse objects from development through peer review and into production. The platform holds client and financial data in a regulated environment, so accuracy, repeatability and a clear audit trail matter as much as delivery speed. 
How we work 
We work in an Agile cycle alongside a Product Owner. Everything we build is version controlled in Azure DevOps and promoted through Fabric deployment pipelines across development, test and live. Development takes place in an isolated feature workspace, every change is peer reviewed before it reaches production, and anything touching regulatory reporting carries an additional test and approval gate. A daily rota covers platform health checks each morning, and documentation is treated as part of the build rather than an afterthought. 
Responsibilities: 

• Build and maintain data pipelines: Develop Fabric Data Pipelines and Notebooks that collect data from platform and enterprise source systems over SFTP, API and gateway database connections, land it in the Fabric Lakehouse, and load it into the persistent staging layer of the Fabric Data Warehouse.
• Develop warehouse logic: Write and optimise the SQL stored procedures that transform staged data into the curated dimensional model, applying the team's standard dimension and fact load patterns.
• Build the consumption layer: Develop Fabric semantic models and DAX measures, Power BI reports and paginated reports that give the business governed, self service access to the warehouse.
• Work to the platform design standards: Apply the documented architecture, naming conventions and re-runnability rules to everything you build, so that any step can be safely re-run from the point of failure without producing duplicate or inconsistent data.
• Test and validate your own work: Run affected pipelines end to end in an isolated feature workspace, and check row counts, key values, logging and downstream impact against expected results before raising a pull request.
• Review your colleagues' work: Carry out peer review on pull requests in Azure DevOps, checking correctness, adherence to standards, and the impact of a change on shared objects and downstream reports.
• Support daily platform operations: Take your turn on the ETL rota, confirming overnight runs have completed, investigating failures, and applying the documented recovery procedures within the team's resolution targets.
• Work within change control: Use feature branches and feature workspaces for every change, and meet the additional approval gates that apply to regulatory pipelines and semantic models.
• Document what you build: Produce and maintain per pipeline documentation covering transformation logic, data mappings and known edge cases, so that any engineer in the team can operate and recover your pipelines.
• Work with the business: Collaborate with colleagues across finance, operations, risk and the platform businesses to understand what they need from the data, and help them interpret what they are given.
• Take part in Agile ceremonies: Contribute to planning, backlog refinement and retrospectives, and keep the team sighted on progress and blockers.

Key Skills: 

• SQL development: Strong SQL skills, including writing and optimising stored procedures against a relational warehouse such as SQL Server, Azure SQL or Fabric.
• ETL and pipeline development: Practical experience building, troubleshooting and maintaining ETL processes and data pipelines in a cloud data platform such as Microsoft Fabric, Azure Data Factory, Synapse or Databricks.
• Dimensional modelling: A solid grounding in data warehousing concepts, including star schemas, fact grain, surrogate keys and slowly changing dimensions.
• Semantic models and reporting: Experience building semantic models, writing DAX measures, and developing Power BI reports or dashboards.
• Python and scripting: Working knowledge of Python for file parsing and automation, ideally within notebooks. PowerShell or C# are useful additions.
• Source control and peer review: Comfortable with Git branching, pull requests and code review, ideally in Azure DevOps.
• Quality and testing: A methodical approach to validating your own work and that of your peers, including reconciling back to source and checking downstream impact.
• Analytical and problem solving skills: The ability to trace a data issue back through the layers to its cause rather than patching the symptom.
• Communication: Able to explain technical detail to non technical colleagues, and to ask the right questions when a requirement is not fully formed.

Desirable Experience: 

• Microsoft Fabric: Hands on experience with the Fabric Lakehouse, Fabric Data Warehouse, Data Pipelines, Notebooks and deployment pipelines. A certification such as DP-700 is welcome but not required.
• Regulated environment: Experience working under formal change control, where evidence and auditability are attached to what you deliver.
• Financial services domain: Exposure to platform, wrap, pensions or investment data, including holdings, transactions, flows and charges.
• Data quality and reconciliation: Experience operating or designing reconciliation and validation controls between a source system and a warehouse.

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.

Strong SQL, ETL pipeline development, dimensional modelling, semantic models and DAX, Python, Git and peer review, analytical and communication skills.

Key Responsibilities

• building data pipelines
• developing warehouse logic
• supporting platform operations

Skills & Tools

Microsoft Fabric, Azure DevOps, SQL Server, Azure SQL, Azure Data Factory, Synapse, Databricks, Power BI, DAX, Python, PowerShell, C#, Git

Job Details

• Category: Data and Analytics
• Seniority: Mid Level
• Commitment: Full Time
• Workplace: Remote — United Kingdom
• Languages: English

Benefits

• 401k matching
• Generous paid time off
• Retirement plan
• Generous parental leave

About Nucleus Financial Platforms Group

A financial services group that helps make retirement more rewarding through its platform and data operations. — Industry: Finance