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.
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.