Data Engineer (Azure, Fabric, Databricks)

Role Overview The Data Engineer is responsible for designing, implementing, and supporting modern data platforms using Microsoft Fabric and Databricks , with a strong emphasis on lakehouse architecture, analytics engineering, and semantic modeling. This role is client-facing and requires translating business requirements into scalable technical solutions while adhering to data engineering best practices. You will collaborate with client stakeholders, Collectiv consultants, and cross-functional teams to deliver data platforms that support reporting, advanced analytics, and self-service BI. Key Responsibilities Client Delivery & Solution Design Design and implement modern data platforms leveraging Microsoft Fabric (OneLake, Lakehouse, Data Factory, Power BI) and Databricks (Spark, Delta Lake, SQL Warehouses) Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices Develop scalable lakehouse architectures that support analytics, reporting, and downstream data products Translate business and analytical requirements into technical designs and data models Analytics & BI Enablement Develop and maintain semantic models that enable performant reporting and self-service analytics Partner with analytics and business teams to deliver trusted datasets and dashboards (Power BI or equivalent) Ensure data quality, reliability, and usability across the analytics platform Engineering Best Practices Write, optimize, and tune SQL and Spa