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 HubSpot (via API) and NetSuite (via ODBC), designing Lakehouse architectures, and developing Power BI dashboards that empower business decision-making. Required Skills & Qualifications Core Experience Minimum 5 years of hands-on experience in Data Engineering roles. Proven experience with Microsoft Fabric — Lakehouse, Pipelines, Datawarehouse, 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. Integration & Connectivity Experience with API-based data integrations (REST/JSON), specifically with HubSpot or similar CRM platforms. Hands-on experience with ODBC driver-based integrations, specifically with NetSuite or similar ERP systems. Familiarity with authentication mechanisms: OAuth 2.0, API keys, and service accounts. SQL & Database 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. Power BI 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 workspaces. Azure Analysis Services & Semantic Models 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. Domain Knowledge Demonstrated experience working within one or more of the following specialist domains is highly valued:

• Marketing & Customer Analytics — working knowledge of CRM data structures (HubSpot), 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. Cloud & Other Platforms Awareness and working knowledge of other cloud data platforms such as:

• Databricks — Delta Lake, Spark, Unity Catalog
• Google BigQuery — SQL, partitioned tables, streaming
• Snowflake — Warehouses, stages, data sharing

Nice to Have Experience with dbt (data build tool) for transformation layer management. Familiarity with Medallion Architecture (Bronze / Silver / Gold layers). Knowledge of data governance frameworks and metadata management tools. Experience with CI/CD pipelines for data engineering (Azure DevOps, Git). Exposure to real-time streaming technologies (Azure Event Hubs, Kafka). Power BI certification (PL-300), Microsoft Fabric certification (DP-600), or Azure Analysis Services / SSAS certification is a plus. Education Bachelor's degree or higher in Computer Science, Information Technology, Data Science, or a related field. Equivalent professional experience will be considered in lieu of formal education. What We Offer Opportunity to work on a high-impact, modern data platform using cutting-edge Microsoft technologies. Collaborative environment with skilled data, analytics, and engineering teams. Competitive compensation package and career growth opportunities. Flexible work arrangements (on-site / hybrid / remote based on location). Professional development support including certifications and training programs. Pay: $120,000.00 - $150,000.00 per year Work Location: In person #J-18808-Ljbffr Socket.dev