Data Engineer Microsoft Fabric

Bilzin Sumberg seeks a Data Engineer to design, build, and maintain the Firm’s modern data platform on Microsoft Fabric. This role centers on data pipeline engineering, ETL/ELT development, and AI-enablement across the Firm’s core systems. The role is approximately 70% new development / 30% maintenance, supporting practice and business operations across the Firm., The ideal candidate is fluent in the Medallion architecture (Bronze/Silver/Gold), thrives in a Lakehouse environment, and is excited to operationalize AI-driven data products. The role requires strong collaboration skills, a governance-first mindset, and the ability to clearly communicate complex data issues to both technical and non-technical audiences. SharePoint Online / SPFx experience is a plus but not required. This role is part of the Knowledge Management & Data team, reporting to the Chief Knowledge Officer., * Design, build, and maintain data warehouses and lakehouses in Microsoft Fabric, ingesting from source systems (Aderant, iManage, Intapp, InterAction, ClientSense, Foundation/Litera, Bloomberg Law) into a governed OneLake environment.

• Develop and optimize ETL/ELT pipelines across the Medallion architecture (Bronze/Silver/Gold), including notebook-based transformations (Python, SQL), data quality enforcement, and incremental refresh logic.
• Build and support AI-enabled data products, including upstream generation of AI narrative summaries and enrichment pipelines feeding Power BI, Harvey, CoCounsel, and enterprise search.
• Model and curate Gold-layer semantic models supporting Power BI reports, dashboards, dataflows, and embedded analytics.
• Implement data governance controls, including row-level security (RLS), workspace-layer security, and audience targeting via Entra ID.
• Orchestrate and monitor pipelines (Fabric data pipelines, Apache Airflow, Power Automate), diagnosing and resolving refresh and performance issues.
• Manage credentials and secrets via Azure Key Vault and support secure integrations across the platform.
• Support ongoing initiatives including Fabric modernization, Enterprise Search, and other Knowledge Management & Data projects.
• Collaborate with stakeholders, product managers, business owners, DBAs, and vendors on system integrations; produce clear data dictionaries, lineage, and architecture documentation.

• Strong hands-on experience building data pipelines and ETL/ELT processes in Microsoft Fabric (or comparable modern data platform: Databricks, Synapse, Snowflake).
• Proficiency with the Medallion / Lakehouse architecture, OneLake, semantic modeling, and dimensional data modeling.
• Advanced Microsoft SQL - schemas, stored procedures, views, and complex queries - and Python (including PySpark / notebook development).
• Power BI dashboard design, semantic models, DAX, Power Query, dataset/dataflow maintenance, and RLS.
• Familiarity with Azure services (Entra ID, Azure Key Vault, Azure OpenAI or comparable AI services).
• Experience integrating and orchestrating data across multiple enterprise source systems via APIs and connectors.
• Experience with GitHub, Power Automate flows, and scripting/cmdlets.
• Strong data governance, security, and documentation discipline.
• Ability to analyze business needs, design solutions, and produce clear technical documentation.
• Strong verbal and written communication skills; effective self-organization and adaptability; proactive, decisive, and creative problem-solving.

Preferred

• SharePoint Online / SPFx development experience - custom libraries, lists, views, and workflows.
• Front-end development with HTML5, JavaScript, jQuery, Kendo, CSS3, and React.js.
• Experience in a professional services or legal environment.
• Familiarity with legal-specific systems (Aderant, iManage, Intapp, InterAction) and Sitecore., Bachelor’s degree in computer science or a related field; 3+ years of data engineering or software development experience required, with demonstrable pipeline/ETL experience. Law firm or professional services experience a plus., Microsoft Fabric OneLake/Lakehouse · Power BI · SQL Server / SSMS · Azure OpenAI

Languages

SQL · Python (PySpark, notebooks) · DAX · Power Query (M)

Orchestration

Fabric data pipelines · Apache Airflow · Power Automate

Azure Services

Entra ID · Azure Key Vault · Azure OpenAI

DevOps

Azure DevOps Boards · GitHub Enterprise · CI/CD

Source Systems

Aderant · iManage · Intapp · InterAction CRM · ClientSense · Foundation/Litera · Bloomberg Law