Nucleus Group
Data Engineer
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Nucleus Financial Platforms
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Location