{"schemaVersion":"jobsearcher.job.v1","id":"ba755008ccf98df72101cafc","url":"https://jobsearcher.com/jobs/ba755008ccf98df72101cafc","canonicalUrl":"https://jobsearcher.com/jobs/ba755008ccf98df72101cafc","title":"Data Engineer","description":"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.\r\nYou 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.\r\nRequired Skills & Qualifications Core Experience Minimum 5 years of hands-on experience in Data Engineering roles.\r\nProven experience with Microsoft Fabric — Lakehouse, Pipelines, Datawarehouse, and Notebooks.\r\nStrong experience with Azure Synapse Analytics — Pipelines, Spark Pools, SQL Pools.\r\nDemonstrated expertise in Data Warehouse design and implementation.\r\nExperience with Master Data Management (MDM) using scripting/notebook-based approaches.\r\nIntegration & Connectivity Experience with API-based data integrations (REST/JSON), specifically with HubSpot or similar CRM platforms.\r\nHands-on experience with ODBC driver-based integrations, specifically with NetSuite or similar ERP systems.\r\nFamiliarity with authentication mechanisms: OAuth 2.0, API keys, and service accounts.\r\nSQL & Database Expert-level SQL skills: Advanced SQL, Dynamic SQL, Stored Procedures, Functions, Views, and CTEs.\r\nProficiency in Microsoft SQL Server (T-SQL) and PostgreSQL.\r\nUnderstanding of database performance tuning — indexing, query plans, partitioning.\r\nPower BI Solid experience with Power BI Desktop and Power BI Service.\r\nProficiency in DAX (Data Analysis Expressions) for complex measures and KPIs.\r\nExperience building enterprise semantic models and managing Power BI workspaces.\r\nAzure Analysis Services & Semantic Models Hands-on experience designing and developing Tabular models in Azure Analysis Services (AAS) or SSAS Tabular.\r\nProficiency with DAX for complex business logic: time intelligence, semi-additive measures, row context and filter context manipulation.\r\nExperience with Semantic Model design best practices — star schema, measure tables, calculation groups, and field parameters.\r\nAbility to manage AAS deployments, processing schedules, and role-based access via XMLA or REST API.\r\nFamiliarity with Tabular Model Scripting Language (TMSL) and Tabular Editor for model development and automation.\r\nDomain Knowledge Demonstrated experience working within one or more of the following specialist domains is highly valued:\r\n– Marketing & Customer Analytics — working knowledge of CRM data structures (HubSpot), campaign attribution models, customer journey mapping, segmentation, churn prediction, and marketing funnel KPIs.\r\n– Affordable Housing — understanding of tenancy management systems, social housing allocation, waitlist data modelling, regulatory compliance reporting, and community impact measurement.\r\n– 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.\r\n– 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.\r\nAbility to rapidly acquire domain knowledge in new sectors and translate complex business requirements into accurate data models and analytics solutions.\r\nAwareness of data sensitivity, privacy regulations (GDPR, sector-specific legislation), and access governance obligations within legal, justice, and social services domains.\r\nCloud & Other Platforms Awareness and working knowledge of other cloud data platforms such as:\r\n– Databricks — Delta Lake, Spark, Unity Catalog\r\n– Google BigQuery — SQL, partitioned tables, streaming\r\n– Snowflake — Warehouses, stages, data sharing\r\nNice to Have Experience with dbt (data build tool) for transformation layer management.\r\nFamiliarity with Medallion Architecture (Bronze / Silver / Gold layers).\r\nKnowledge of data governance frameworks and metadata management tools.\r\nExperience with CI/CD pipelines for data engineering (Azure DevOps, Git).\r\nExposure to real-time streaming technologies (Azure Event Hubs, Kafka).\r\nPower BI certification (PL-300), Microsoft Fabric certification (DP-600), or Azure Analysis Services / SSAS certification is a plus.\r\nEducation Bachelor's degree or higher in Computer Science, Information Technology, Data Science, or a related field.\r\nEquivalent professional experience will be considered in lieu of formal education.\r\nWhat We Offer Opportunity to work on a high-impact, modern data platform using cutting-edge Microsoft technologies.\r\nCollaborative environment with skilled data, analytics, and engineering teams.\r\nCompetitive compensation package and career growth opportunities.\r\nFlexible work arrangements (on-site / hybrid / remote based on location).\r\nProfessional development support including certifications and training programs.\r\nPay: $120,000.00 - $150,000.00 per year\r\nWork Location: In person#J-18808-Ljbffr","company":"Socket","rawCompany":"socket","city":"Pasadena","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-08-13T02:11:32.643Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Engineer","description":"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.\r\nYou 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.\r\nRequired Skills & Qualifications Core Experience Minimum 5 years of hands-on experience in Data Engineering roles.\r\nProven experience with Microsoft Fabric — Lakehouse, Pipelines, Datawarehouse, and Notebooks.\r\nStrong experience with Azure Synapse Analytics — Pipelines, Spark Pools, SQL Pools.\r\nDemonstrated expertise in Data Warehouse design and implementation.\r\nExperience with Master Data Management (MDM) using scripting/notebook-based approaches.\r\nIntegration & Connectivity Experience with API-based data integrations (REST/JSON), specifically with HubSpot or similar CRM platforms.\r\nHands-on experience with ODBC driver-based integrations, specifically with NetSuite or similar ERP systems.\r\nFamiliarity with authentication mechanisms: OAuth 2.0, API keys, and service accounts.\r\nSQL & Database Expert-level SQL skills: Advanced SQL, Dynamic SQL, Stored Procedures, Functions, Views, and CTEs.\r\nProficiency in Microsoft SQL Server (T-SQL) and PostgreSQL.\r\nUnderstanding of database performance tuning — indexing, query plans, partitioning.\r\nPower BI Solid experience with Power BI Desktop and Power BI Service.\r\nProficiency in DAX (Data Analysis Expressions) for complex measures and KPIs.\r\nExperience building enterprise semantic models and managing Power BI workspaces.\r\nAzure Analysis Services & Semantic Models Hands-on experience designing and developing Tabular models in Azure Analysis Services (AAS) or SSAS Tabular.\r\nProficiency with DAX for complex business logic: time intelligence, semi-additive measures, row context and filter context manipulation.\r\nExperience with Semantic Model design best practices — star schema, measure tables, calculation groups, and field parameters.\r\nAbility to manage AAS deployments, processing schedules, and role-based access via XMLA or REST API.\r\nFamiliarity with Tabular Model Scripting Language (TMSL) and Tabular Editor for model development and automation.\r\nDomain Knowledge Demonstrated experience working within one or more of the following specialist domains is highly valued:\r\n– Marketing & Customer Analytics — working knowledge of CRM data structures (HubSpot), campaign attribution models, customer journey mapping, segmentation, churn prediction, and marketing funnel KPIs.\r\n– Affordable Housing — understanding of tenancy management systems, social housing allocation, waitlist data modelling, regulatory compliance reporting, and community impact measurement.\r\n– 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.\r\n– 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.\r\nAbility to rapidly acquire domain knowledge in new sectors and translate complex business requirements into accurate data models and analytics solutions.\r\nAwareness of data sensitivity, privacy regulations (GDPR, sector-specific legislation), and access governance obligations within legal, justice, and social services domains.\r\nCloud & Other Platforms Awareness and working knowledge of other cloud data platforms such as:\r\n– Databricks — Delta Lake, Spark, Unity Catalog\r\n– Google BigQuery — SQL, partitioned tables, streaming\r\n– Snowflake — Warehouses, stages, data sharing\r\nNice to Have Experience with dbt (data build tool) for transformation layer management.\r\nFamiliarity with Medallion Architecture (Bronze / Silver / Gold layers).\r\nKnowledge of data governance frameworks and metadata management tools.\r\nExperience with CI/CD pipelines for data engineering (Azure DevOps, Git).\r\nExposure to real-time streaming technologies (Azure Event Hubs, Kafka).\r\nPower BI certification (PL-300), Microsoft Fabric certification (DP-600), or Azure Analysis Services / SSAS certification is a plus.\r\nEducation Bachelor's degree or higher in Computer Science, Information Technology, Data Science, or a related field.\r\nEquivalent professional experience will be considered in lieu of formal education.\r\nWhat We Offer Opportunity to work on a high-impact, modern data platform using cutting-edge Microsoft technologies.\r\nCollaborative environment with skilled data, analytics, and engineering teams.\r\nCompetitive compensation package and career growth opportunities.\r\nFlexible work arrangements (on-site / hybrid / remote based on location).\r\nProfessional development support including certifications and training programs.\r\nPay: $120,000.00 - $150,000.00 per year\r\nWork Location: In person#J-18808-Ljbffr","datePosted":"2026-08-13T02:11:32.643Z","dateModified":"2026-08-13T02:11:32.643Z","hiringOrganization":{"@type":"Organization","name":"Socket","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Pasadena","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"ba755008ccf98df72101cafc"},"url":"https://jobsearcher.com/jobs/ba755008ccf98df72101cafc"}}