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/snowflake schema, dimensional modeling, and semantic models).
• Ensure alignment with enterprise architecture and data governance standards.

3. Analytics & Business Enablement

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

4. DevOps & Agile Delivery

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

5. Cross-Departmental Collaboration

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

Required Qualifications

• 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 Qualifications

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

Join our team to shape the future of data-driven decision-making with Microsoft Fabric.
Be part of an innovative organization where your technical expertise drives meaningful business outcomes.

Compensation Salary $111,000 - $209,000

The compensation salary for this position will be determined during the interview process and will vary based on multiple factors, including but not limited to prior experience, relevant expertise, current business needs, and market factors.

#LI-NW1

In accordance with the Los Angeles Fair Chance Ordinance, San Francisco Fair Chance Ordinance, and the California Fair Chance Act, qualified applicants for our Los Angeles and San Francisco offices with arrest and conviction records will be considered.

ABOUT THE FIRM

K&L Gates is a fully integrated global law firm with lawyers located across five continents in more than 40 offices. We have experienced dramatic growth in the past decade and now rank among the largest U.S. based law firms in the world. We take pride in constantly striving for innovation, imagination and an entrepreneurial spirit. We come up with big ideas and then roll up our sleeves to get the job done, guiding our clients through their most complex issues in a variety of industry sectors and across multiple regions of the world.


The industry recognition the firm has garnered emanates from the foundation of a global community aligned on behalf of our clients. The people at K&L Gates are committed to working together to create a legacy for each other, the firm, our clients, and the communities in which we serve. We thrive in an inclusive and socially conscious environment that embraces diversity and takes a holistic approach to the career evolution of all our professionals.

For more information or to view other job opportunities, please click here to go back to our careers page.

Notice: We participate in E-Verify in certain Firm locations for purposes of verifying employment eligibility.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

BENEFITS

K&L Gates offers our personnel a comprehensive suite of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time personnel include:

• 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

EQUAL EMPLOYMENT OPPORTUNITY

The Firm is an equal opportunity employer. It is the policy of the Firm that employment decisions shall be based on merit, qualifications and competence. Employment practices will not be influenced or affected by virtue of a person's race (including traits associated with race, including hair texture and protective hairstyles such as afros, braids, locks, and twists), religion, creed, color, national origin, ancestry, citizenship, physical disability, mental disability, medical condition, genetic information, marital status, sex, pregnancy, childbirth, breastfeeding, gender, parental status, gender identity, gender expression, sexual orientation, age, familial status, domestic violence victim status, military and veteran status, or any other characteristic protected by applicable federal, state, or local law. This policy governs all aspects of employment including, without limitation, recruiting, hiring, compensation, benefits, promotion, assignment, and dismissal. In addition, it is the Firm's policy to provide an environment that is free of prohibited harassment of any kind including, without limitation, that which is based on sex, race, age, disability, ethnic background, or any other category protected by law (including the categories listed above). The Firm complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If you require reasonable accommodation in completing this application, interviewing, or otherwise participating in the employee selection process, please contact View email address on click.appcast.io.