Data Engineer (Fabric, SQL, Python), Professional Services industry, fully remote

Ethos BeathChapman; United Kingdom; Remote; GBP 70,000 - 110,000; Full time

Job summary

Ethos BeathChapman is partnering with a PE-backed professional services group to hire a Data Engineer who will build and run the technical foundation of the data strategy. You’ll pull data from core systems into a Lakehouse on Microsoft Fabric, process it through a medallion architecture and deliver modelled, trusted data for reporting, AI and ML.

You’ll work with Data Analysts on modelling and with IT and Information Security on secure integration.

Qualifications

• Experienced Data Engineer familiar with Microsoft Fabric and Azure data stack.
• Built, optimised pipelines that users rely on.
• Proficient in Python, PySpark and SQL for lakehouse workloads.
• Strong focus on data quality, security and reliability.
• Able to communicate with technical and non-technical stakeholders.

Responsibilities

• Build and maintain scalable data pipelines from core systems and third-party sources.
• Design data solutions with Python, PySpark, SQL, notebooks and dataflows.
• Create and optimise models powering Power BI reporting and analytics.
• Ensure data quality, validation and reconciliation.
• Monitor, troubleshoot and keep the platform fast and reliable.
• Configure and support master data management and entity resolution.
• Own MDM approach, golden records, matching and survivorship rules.
• Manage source control, code reviews and CI/CD via Azure DevOps.
• Implement secure RBAC, auditing and governance controls.
• Maintain documentation, data lineage and platform standards.
• Shape future analytics and ML capabilities.

Skills

Data engineering

Microsoft Fabric

Azure data stack

Pipelines

Data governance

Communication

Tools

Azure DevOps

Aptitude

Senzing

Power BI

Job description

Our client is a growing, international, PE-backed professional services organisation.

This new role has been created to build and run the technical foundation of the company's data strategy. You’ll bring data from our source systems into their Lakehouse on Microsoft Fabric, process it through a medallion architecture, and deliver modelled, trusted data that’s ready for reporting, AI and machine learning.

You’d be working with Data Analysts on modelling, and with IT, Information Security and system owners on secure integration. It’s a small team and a genuine build role, which means real influence over the architecture, the tooling and the standards adopted.

As the data platform grows so will the role and there’s scope to move into advanced analytics, and AI-assisted tooling such as Fabric MCP, Fabric IQ, Copilot and data agents.

Key responsibilities:

• Building and maintaining scalable data pipelines, pulling data in from core business systems and third-party sources.
• Designing and developing data solutions with Python, PySpark, SQL, notebooks and dataflows across a modern medallion architecture
• Creating and optimising data models that power high-quality Power BI reporting and analytics.
• Putting data quality, validation and reconciliation processes in place so the numbers can be trusted.
• Monitoring, troubleshooting and keeping the platform fast, reliable and available.
• Configuring and supporting master data management and entity resolution, so data stays consistent across systems.
• Owning master data management approach defining golden records for clients, contacts and matters, setting matching, de-duplication and survivorship rules, and using entity resolution tooling such as Aptitude or Senzing to link records across systems.
• Owning source control, code reviews and CI/CD pipelines through Azure DevOps.
• Implementing secure, compliant data access role-based security, auditing and governance controls.
• Keeping technical documentation, data lineage and platform standards in good order.
• Helping shape where the platform goes next, including future analytics, AI and machine learning capability.

Required skills & experience:

• You’re an experienced Data Engineer who knows Microsoft Fabric and the Azure data stack well
• You’ve built, optimised and supported pipelines that people actually depend on.
• Python, PySpark and SQL are comfortable territory, and you’ve designed lakehouse architectures that hold up under real business intelligence workloads.
• You’re a proactive problem-solver who works methodically and delivers to a high standard, with data quality, security and platform reliability built into everything you do.
• You can talk to technical and non-technical colleagues just as easily, and you enjoy an environment where collaboration, ownership and continuous improvement genuinely matter.

Advantageous:

Experience with master data management, data governance, Azure security or real-time data solutions would be a real bonus, as would professional or financial services industry experience.

Although this is a remote role, candidates must be UK-based and be able to work in the UK on a long-term basis without visa sponsorship. Candidates must be prepared to visit the office monthly.