> Markdown version of [/jobs/ext/520146-data-engineer](https://www.wearedevelopers.com/jobs/ext/520146-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - **Company:** Intellectyx Inc. - **Location:** Pasadena, CA, United States (Remote available) - **Experience:** Expert - **Salary:** $120,000.0 - $150,000.0 - **Contract:** Permanent contract - **Skills:** Unity 3d, Application Programming Interfaces (APIs), Business Analytics Applications, Data Analysis, Business Logic, Authentication Protocols, Microsoft Azure, Cloud Computing, Databases, Information Engineering, Data Governance, Data Integration, Data Security, Data Sharing, Data Structures, Data Warehousing, Identity and Access Management, JSON, PostgreSQL, Meta-Data Management, Microsoft SQL Server, Netsuite, OAuth, Open Database Connectivity, Power BI, Cloud Services, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Analysis Services, Data Streaming, Transact-SQL, Document Metadata, Sql Optimization, Snowflake, Data Build Tool (dbt), Database Optimization, Apache Spark, Indexer, Git, Microsoft Fabric, Data Lakes, Information Technology, Data Analytics, Star Schema, Google Bigquery, Apache Kafka, Data Management, Hubspot, Api Design, Restful APIs, Azure Synapse Analytics, Data Pipelines, Ssas Tabular, Databricks - **Published:** June 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=4692482ce562c2f3 ## About the Role Do you have experience in T-SQL?, Do you have a Bachelor's degree?, * 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. ## Description 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. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Keeping applications secure by evolving OAuth 2.0 and OpenID Connect](https://www.wearedevelopers.com/videos/100152-keeping-applications-secure-by-evolving-oauth-2-0-and-openid-connect) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Delay the AI Overlords: How OAuth and OpenFGA Can Keep Your AI Agents from Going Rogue](https://www.wearedevelopers.com/videos/1637-delay-the-ai-overlords-how-oauth-and-openfga-can-keep-your-ai-agents-from-going-rogue) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)