Data Engineer

About the Role

We are seeking a highly skilled and experienced Senior Data Engineer to join our growing Data & Analytics team. This role is central to building, maintaining, and evolving our enterprise data platform using Microsoft Fabric and Azure Synapse Analytics. The ideal candidate will have deep expertise in data warehouse architecture, master data management (MDM), and modern cloud data ecosystems.

You will be responsible for integrating data from multiple enterprise sources including Hub Spot (via API) and Net Suite (via ODBC), designing Lakehouse architectures, and developing Power BI dashboards that empower business decision-making.

• Minimum 5 years of hands-on experience in Data Engineering roles.
• Proven experience with Microsoft Fabric — Lakehouse, Pipelines, Data warehouse, and Notebooks.
• Strong experience with Azure Synapse Analytics — Pipelines, Spark Pools, SQL Pools.
• Demonstrated expertise in Data Warehouse design and implementation.
• Experience with Master Data Management (MDM) using scripting/notebook-based approaches.

• Experience with API-based data integrations (REST/JSON), specifically with Hub Spot or similar CRM platforms.
• Hands-on experience with ODBC driver-based integrations, specifically with Net Suite or similar ERP systems.
• Familiarity with authentication mechanisms: OAuth 2.0, API keys, and service accounts.

• Expert-level SQL skills:
  Advanced SQL, Dynamic SQL, Stored Procedures, Functions, Views, and CTEs.
• Proficiency in Microsoft SQL Server (T-SQL) and PostgreSQL.
• Understanding of database performance tuning — indexing, query plans, partitioning.

• Solid experience with Power BI Desktop and Power BI Service.
• Proficiency in DAX (Data Analysis Expressions) for complex measures and KPIs.
• Experience building enterprise semantic models and managing Power BI work spaces.

• Hands-on experience designing and developing Tabular models in Azure Analysis Services (AAS) or SSAS Tabular.
• Proficiency with DAX for complex business logic: time intelligence, semi-additive measures, row context and filter context manipulation.
• Experience with Semantic Model design best practices — star schema, measure tables, calculation groups, and field parameters.
• Ability to manage AAS deployments, processing schedules, and role-based access via XMLA or REST API.
• Familiarity with Tabular Model Scripting Language (TMSL) and Tabular Editor for model development and automation.

• Demonstrated experience working within one or more of the following specialist domains is highly valued:

– Marketing & Customer Analytics — working knowledge of CRM data structures (Hub Spot), campaign attribution models, customer journey mapping, segmentation, churn prediction, and marketing funnel KPIs.

– Affordable Housing — understanding of tenancy management systems, social housing allocation, waitlist data modelling, regulatory compliance reporting, and community impact measurement.

– High Court & Legal Case Management — familiarity with case lifecycle data, court proceedings data models, legal SLA metrics, document metadata management, and sensitive legal data handling requirements.

– Probation & Criminal Justice Services — knowledge of offender case data pipelines, rehabilitation programme tracking, risk scoring systems, caseload analytics, and strict data access governance within justice sector frameworks.

• Ability to rapidly acquire domain knowledge in new sectors and translate complex business requirements into accurate data models and analytics solutions.
• Awareness of data sensitivity, privacy regulations (GDPR, sector-specific legislation), and access governance obligations within legal, justice, and social services domains.

• Awareness and working knowledge of other cloud data platforms such as:

– Databricks — Delta Lake, Spark, Unity Catalog

– Google Big Query — SQL, partitioned tables, streaming

– Snowflake — Warehouses, stages, data sharing

• Experience with dbt (data build tool) for transformation layer management.
• Familiarity with Medallion Architecture (Bronze /…