Apply on Employer Site

K&L Gates · 1 day ago

Developer II - Data Engineer, Microsoft Fabric Specialist

Boston, MA

Full-time

Hybrid

Entry, Mid Level

$98K/yr - $183K/yr

2+ years exp

K&L Gates is a fully integrated global law firm seeking an experienced Data Engineer with a strong focus on Microsoft Fabric to design, implement, and maintain enterprise data solutions. The role involves collaborating with various business units to deliver scalable data products and applying modern data engineering practices within an Agile DevOps environment.

LegalReal Estate

H1B Sponsor Likely

Responsibilities

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

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/snowflake schema, dimensional modeling, and semantic models)

Ensure alignment with enterprise architecture and data governance standards

Develop Power BI semantic models and datasets using DAX and Power Query for reporting and self-service analytics

Collaborate with BI and business teams to ensure data products meet stakeholder needs

Optimize Power BI performance by tuning data models, queries, and refresh strategies

Support advanced analytics, forecasting, and AI initiatives through well-structured and high-quality data sources

Work within a DevOps Agile framework, participating in sprint planning, stand-ups, and retrospectives

Use version control and continuous integration tools to manage and deploy data assets

Collaborate closely with cross-functional teams including software engineers, BI developers, and business analysts

Create detailed technical documentation, reusable templates, and automated deployment scripts

Partner with stakeholders in Finance, HR, Client Growth, Operations, and IT to understand business needs and deliver tailored data solutions

Translate business requirements into technical specifications and implement scalable data solutions accordingly

Promote best practices for data accessibility, quality, and governance across departments

Qualification

Microsoft FabricData FactoryDataflow Gen2Data WarehouseData LakehousePower BIDAXSQLPythonDevOpsAgile methodologiesCommunication skillsCollaboration skillsTechnical documentation

Required

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or 10 years of working experience in related field

Minimum of 2 years of hands-on experience implementing Microsoft Fabric (Data Factory, Dataflow Gen2, Notebooks, Data Warehouse, Lakehouse)

Proven experience developing and deploying Fabric Data Factory pipelines with CI/CD automation

Strong working knowledge of Power BI, DAX, and Power Query (M language)

Expertise in SQL and Python for data transformations, query optimization, and automation

Solid understanding of data architecture principles, including data modeling, schema design, and performance tuning

Experience applying DevOps and Agile methodologies in data engineering projects

Ability to choose the right Fabric tools (Lakehouse, Warehouse, Dataflows, Notebooks, Power BI) to solve specific business problems

Familiarity with Data Mesh principles, including domain-oriented data ownership, federated governance, and self-service data platforms

Proficient in implementing Medallion Architecture (Bronze, Silver, Gold layers) within Microsoft Fabric for scalable and maintainable data solutions

Excellent communication and collaboration skills, with experience working across multiple business domains

Preferred

Microsoft certifications such as: Microsoft Certified: Fabric Analytics Engineer Associate, Microsoft Certified: Azure Data Engineer Associate

Experience with GitHub Actions or Azure DevOps YAML pipelines for CI/CD automation

Familiarity with data governance frameworks, metadata management, and security best practices

Exposure to real-time analytics, event-driven architecture, or AI/ML data preparation

Benefits

Medical/Prescription Drug Coverage (including a Health Savings Account feature)

Back-up Child/Elder Care and access to a caregiving concierge

Dental Insurance

Wellness Program

Vision Insurance

Pre-tax Commuting Benefits

401(k) Retirement Plan and Profit Sharing

Business Travel Accident Insurance

Short- and Long-term Disability Protection

Pet Insurance

Life Insurance (including Basic, Supplemental, Spouse, Child, and Accidental Death and Dismemberment)

Health Advocacy Services

Paid Time Off (25-30 days per year)

Identity Protection/Restoration and Fraud Insurance

Parental Leave (18 weeks of which 6 are paid; short-term disability may provide additional paid time off)

Student loan refinancing options and access to a student loan concierge service

Paid Holidays (12)

Addiction Resources

Family Building Benefits

Breast Milk Delivery and Lactation Support Services

Flexible Spending Accounts

Employees also may be eligible to receive bonuses and certain expense reimbursements

Employee Assistance Program

Professional Development and CLE Credit Opportunities

529 Deductions

Relocation

Accident Insurance

Employee Referral Program

Critical Illness Insurance

Hybrid/Remote Work Opportunities

Hospital Indemnity Insurance

Perks including: Technology, Entertainment, and Travel Discount Programs

Bereavement Leave

All other benefits (such as leaves of absence) required by law

Company

K&L Gates

Glassdoor3.5

At K&L Gates, we foster an inclusive and collaborative environment across our fully integrated global platform that enables us to diligently combine the knowledge and expertise of our lawyers and policy professionals to create teams that provide exceptional client solutions.

Founded in 1883

Pittsburgh, Pennsylvania, USA

1001-5000 employees

http://www.klgates.com/

H1B Sponsorship

K&L Gates has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (1)

2024 (3)

2023 (1)

2022 (6)

2021 (2)

2020 (19)