Data Engineer Microsoft Fabric

.flexy { display: flex; flex-direction: row; flex-wrap: wrap; } .flex-item { flex-grow: 1; flex-basis: 500px; } .flex-item-big{ flex-grow: 1; flex-basis: 650px; } .flex-item-small{ flex-grow: 1; flex-basis: 300px; align-items: center; justify-content: center; } .flex-item iframe { height: 360px; width: 100%; } .bilzin-button{ display: inline-block; padding: 15px 30px; font-family: soleil; color: white; font-size: 20px; background: #ff7900; margin-right: 30px; margin-top: 20px; } .bilzin-.p{ margin-top: -100px; }

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.

Job Responsibilities

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.

Knowledge, Skills & Abilities

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.

Education & Experience

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.

Current Technologies

Area

Technologies

Data Platform

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

Nice to Have

SharePoint Online · SPFx · React.js · Sitecore

To Apply

Interested candidates should submit a resume to Jackie F. Gallego, Chief Human Resources Officer.