Senior Data Engineer

Job not on LinkedIn

🔥 0 minutes ago

🇬🇧 United Kingdom – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Nucleus Financial

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 2006

💸 Finance

💳 Fintech

☁️ SaaS

Finance • Fintech • SaaS

Nucleus Financial is one of the UK's leading independent groups for investment platforms, products and wealthtech software, and the only large-scale group with a comprehensive range of bespoke platform solutions to meet the evolving needs of advisory and investment management firms of all sizes, as well as their clients. They offer adviser and customer-facing platforms (Nucleus Platform), retirement-focused adviser platform combining technology and pension expertise, a wrap platform (Nucleus Wrap), SIPPs via James Hay and Curtis Banks, enterprise solutions (Third Financial), and wealthtech services (Dunstan Thomas). The group administers £110bn assets under administration, serves 251k customers and ~5. 2k advice firms. Headquarters in Salisbury, UK. They provide digital capability, back-office integrations, regulatory and legal information, and BDM booking for demos. The company focuses on retirement and wealth management solutions for advisers and customers in the UK.

📋 Description

• Own the design and delivery of complex parts of the Microsoft Fabric data platform • Decide how new data sources are onboarded and modelled, including required controls and promotion readiness • Lead ingestion pipeline and warehouse model design from source review through live, reconciled and documented production pipelines • Define and evolve engineering standards, naming conventions, load patterns and re-runnability requirements • Lead design of the conformed warehouse layer and resolve source-system differences in identifiers, hierarchies and status models • Provide in-depth peer review and act as technical approver for production changes, especially regulatory pipelines and semantic models • Work with the Product Owner to scope, break down, estimate and prioritise data and BI projects • Design validation, reconciliation and monitoring controls, own materiality-threshold judgements, and provide evidence to risk, compliance and audit reviewers • Lead complex incident diagnosis, code and data rollback, root-cause analysis and recovery • Govern semantic models, keeping business logic in version-controlled warehouse procedures and measures thin • Mentor engineers through review, pairing and structured knowledge transfer • Potentially line manage engineers, including objectives, development plans, one-to-ones and performance • Engage finance, risk, compliance and business stakeholders to turn requirements into deliverable solutions • Lead Agile planning, backlog refinement and retrospectives and drive continuous improvement • Support data outputs for management information, financial reporting, self-service analytics, AI capability and FCA/PRA regulatory returns

🎯 Requirements

• Advanced SQL development, optimisation and troubleshooting, including complex stored procedure logic over bi-temporal, large data volumes • Proven record of designing and delivering pipelines or platforms end to end in a cloud data platform such as Microsoft Fabric, Azure Data Factory, Synapse or Databricks • In-depth understanding of dimensional modelling using the Kimball methodology, conformed dimensions, slowly changing dimensions, surrogate key strategies and incremental load patterns • Strong semantic model and DAX skills, with a clear view on where logic belongs between the warehouse and the model • Confidence with Python for parsing, automation and data handling, ideally in a notebook environment • Strong working knowledge of branching strategy, pull request policy, environment promotion and secret management • Experience operating change control in a governed environment • Experience designing reconciliation, validation and monitoring controls, and setting investigation thresholds • Ability to lead diagnosis and recovery during live data incidents and communicate clearly • Genuine interest in mentoring and developing other engineers • Ability to manage priorities, expectations and delivery with senior stakeholders • Comfort taking unclear requirements or undocumented source feeds and turning them into defined, deliverable work • Hands-on experience with Microsoft Fabric Lakehouse, Fabric Data Warehouse, Data Pipelines, Notebooks, Git integration and deployment pipelines is desirable • Experience delivering data used for regulatory reporting and working with audit, risk and compliance reviewers is desirable • Experience with Wrap, SIPP, pensions or investment platform data is desirable • Experience with encrypted file transfers, key management and automated decryption in a controlled environment is desirable • Understanding of curated data supporting AI use cases and related governance is desirable • DP-700 certification is welcome but not required

🏖️ Benefits

• Non-contributory pension • Bonus • Enhanced parental leave • Paid time off for emergencies • Health and wellbeing initiatives • Flexible working options • Inclusion and diversity embedded in the company culture • Recognition and rewards for employees' efforts