Department: Technology
Reporting to: Head of Development
Location: Home Based with regular visit to London Office
Direct reports: N/A
Salary: Competitive
About us
Mortgage Brain is an award-winning technology creator for the mortgage industry, offering innovative solutions that empower brokers, networks, and lenders to work more effectively. With a suite of tech solutions including Sourcing Brain, Criteria Brain, Affordability Brain, Submissions Brain and CRM Brain, Mortgage Brain is committed to shaping the future of the mortgage market.
In September 2025, Mortgage Brain officially launched Mortgage Brain Hub, the first all-in-one platform designed to simplify the mortgage journey for brokers. Built to solve the challenges of fragmented systems and repetitive admin, Mortgage Brain Hub provides a seamless, single-login experience that enables effortless user management, automated data sharing, and greater compliance control.
With over 15,000 users, Mortgage Brain is trusted by the industry to deliver cutting edge solutions. Established in 1986, it is jointly owned by Barclays, Lloyds Banking Group, Nationwide, NatWest, and Santander.
In 2026, Mortgage Brain won the following awards: Financial Services Forum 2026 Awards for Innovation and Transformation Judges’ Special Award – Best Innovation in B2B and Most Innovative CRM Service (Highly Commended); Financial Reporter – Technology Provider of the Year; and The Mortgage Awards – Mortgage Technology Provider of the Year (Highly Commended). To learn more about Mortgage Brain visit www.mortgagebrain.com
Main Purpose of Role:
We are seeking a skilled and detail-oriented Data Engineer (Analytics) (Microsoft Fabric) with deep, hands-on expertise in Microsoft Fabric to design and own the data pipelines and reporting that power our business. This is a role for someone who lives and breathes Fabric – building robust pipelines, modelling data, and turning it into insight that drives decisions. You will work across teams to ensure data flows are optimised, accurate, compliant, and accessible, and your work will contribute directly to decision-making, product development, and data governance standards across the business.
Key Responsibilities:
- Own the day-to-day running, monitoring, and optimisation of our Microsoft Fabric solution — including Lakehouses/Warehouses, pipelines, dataflows, semantic models, and Power BI reporting built on top of it.
- Design, build, and maintain end-to-end data pipelines in Microsoft Fabric, using Data Factory pipelines and Dataflows Gen2 to ingest, transform, and orchestrate data from MongoDB, APIs, and third-party sources.
- Develop and optimise the Fabric Lakehouse and Warehouse architecture (OneLake, medallion/bronze-silver-gold layers), including Spark notebooks, SQL, and data modelling for analytics-ready datasets.
- Own the scheduling, monitoring, and alerting of Fabric pipelines, ensuring reliable refreshes, robust error handling, and efficient use of Fabric capacity.
- Build and maintain semantic models and DirectLake datasets in Fabric to power fast, governed self-service reporting.
- Deliver interactive dashboards and reports in Power BI and Fabric, translating commercial questions into clear, actionable visual insight for stakeholders across the business.
- Build and maintain dashboards and visual reports using Microsoft Fabric and Power BI.
- Define and manage data access structures, particularly APIs and GraphQL schemas.
- Apply CI/CD and version control to Fabric assets (deployment pipelines, Git integration) and champion best practice around workspace governance, security, and row-level security.
- Map and document data architectures, including business flows, feature usage, and cross-product interactions.
- Conduct regular data audits, including schema validation, usage analytics, and compliance checks (e.g. schema locks, deprecation).
- Ensure data integrity and consistency across systems; define and monitor quality benchmarks.
- Produce clear graphical representations of data, working with commercial teams to build products and views with commercial value.
- Support GDPR compliance by tracking Personally Identifiable Information (PII) and its usage across systems.
- Partner with engineering and product teams to ensure scalable and secure data solutions.
- Collaborate with cross-functional teams to define data needs and translate business requirements into actionable data specifications.
- Apply a critical eye to data quality and transformation logic — proactively validating, profiling, and reconciling data, catching anomalies early, and putting checks in place so issues are surfaced before they reach end users.
- Champion best practice in data modelling, documentation, and governance so our Fabric environment stays well-structured, performant, and cost-efficient as it scales.
- Turn business questions into trustworthy analysis and reporting, partnering with stakeholders to understand what they need and translating it into clear, accurate outputs.
- Actively explore and evaluate emerging data technologies and platforms (e.g. wider modern data stack), bringing recommendations on where they could strengthen our capability.
Knowledge, Skills, Abilities and Experience required
- Proven experience as an Analytics Engineer, Data Engineer, BI Developer, or similar role.
- Proficiency with Microsoft Fabric and Power BI for dashboarding and visualisation.
- Demonstrable, hands-on expertise building and orchestrating data pipelines in Microsoft Fabric – Data Factory, Dataflows Gen2, Lakehouse/Warehouse, OneLake, and Spark notebooks.
- Strong data engineering fundamentals: SQL, data modelling (star schema/medallion), and building performant, analytics-ready datasets.
- Experience creating semantic models and delivering reports in Power BI, including DAX, DirectLake, and row-level security.
- Familiarity with DevOps for data: Git integration, Fabric deployment pipelines, and CI/CD for analytics assets.
- Strong knowledge of MongoDB and schema design best practices.
- Experience with GraphQL, RESTful APIs, and modern data access structures.
- Solid understanding of data architecture principles, including business and feature flow mapping.
- Familiarity with data cataloguing and metadata management tools.
- Demonstrable experience conducting data audits and supporting compliance.
- Strong grasp of data quality frameworks and data integrity assurance.
- Ability to communicate complex data visually and narratively to technical and non-technical stakeholders.
- Working knowledge of GDPR and PII handling best practices.
- Collaborative and solutions-oriented mindset.
Benefits
Flexibility:
- Flexible hybrid working – split your time between the office and home working.
- Buy holiday scheme – flexible holidays that fit your lifestyle.
- Summer Fridays – start your weekend early during summer months with our new trial initiative.
Remuneration:
- Competitive salary– we value our workforce.
- Discretionary bonus – top up your annual salary with a discretionary annual bonus.
- Company pension scheme– we contribute 5% to your pension (2% above the statutory requirement).
- Income protection scheme – help when you need it if you’re ill or injured.
- Life assurance scheme – if the worst happens, you’re covered.
Health and Wellbeing:
- Employee Wellbeing Programme– a range of initiatives to support colleagues.
- Employee Assistance Programme – help for you and your family with a range of personal and work-related concerns.
- Cycle to work scheme– cycle to work and have the chance to buy a bike up the value of £15,000 on a salary sacrifice basis.
Everyday benefits:
- Further your career – with on-the-job learning and knowledge sharing.
- Work hard, play hard – we enjoy regular social activities.
Our Values:
- Better together. Togetherness, collaboration, and teamwork make a real difference. It’s how we do business whether it’s with colleagues, customers, partners, or the whole mortgage community. We unite a diverse range of perspectives, people, and ideas for better customer outcomes.
- Driving change. We don’t stand still. Nor do we create change for the sake of change. We lead the way with creative thinking and innovation because we love a challenge and the agility that requires. To achieve our goals, we work smarter and faster, pushing our own boundaries and focusing on incremental positive improvement.
- Do the right thing. Our existence is to the benefit of society. Maintaining integrity is vital. As a company and as individuals, we are honest and accountable in all we do. We foster trust through transparency, build strength with open communication, and cultivate inclusion by championing one another.
Equal Opportunities Statement:
- As an equal opportunities’ employer, Mortgage Brain is committed to the equal treatment of all current and prospective employees and does not condone discrimination on the basis of age, disability, sex, sexual orientation, pregnancy and maternity, race or ethnicity, religion or belief, gender identity, or marriage and civil partnership.
- We aspire to have a diverse and inclusive workplace and strongly encourage suitably qualified applicants from a wide range of backgrounds to apply and join Mortgage Brain.
