Data Engineer

### Job Description

At K&L Gates, we are looking for smart, imaginative and hard-working people with diverse backgrounds, experiences and ideas to join us. Perhaps our search for talented visionaries and your search for important and impactful work lead to the same place.

We are seeking an experienced Data Engineer with a strong focus on Microsoft Fabric to design, implement, and maintain enterprise data solutions. The ideal candidate will have a minimum of 2 years of hands-on experience implementing Microsoft Fabric, including deep expertise in Fabric Data Factory, Dataflow Gen2, Notebooks, and Data Warehouse and Lakehouse design.

This role will collaborate with business units across Finance, HR, Client Growth, and other departments to deliver scalable, reliable, and business-aligned data products. The successful candidate must demonstrate the ability to choose the right Fabric technology (Lakehouse vs. Warehouse) for each business scenario and apply modern data engineering practices within an Agile DevOps environment.

Key Responsibilities

1. Data Engineering & Pipeline Development

• Design, develop, and maintain data pipelines using Microsoft Fabric Data Factory for data ingestion, transformation, and orchestration.
• Build Dataflow Gen2 processes to prepare and enrich data from multiple sources for analytical consumption.
• Develop and manage Fabric Notebooks (Python, Spark, SQL) for advanced transformations and automation.
• Deploy, monitor, and optimize data pipelines using CI/CD processes in Azure DevOps or GitHub Actions.
• Implement robust data quality, validation, and monitoring processes.

2. Data Architecture & Modeling

• Design and implement Data Warehouses and Lakehouses within Microsoft Fabric to meet analytical and operational needs.
• Understand when to use Lakehouse vs. Warehouse based on data volume, structure, performance requirements, and business use cases.
• Apply best practices for data modeling (star/snow...