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 Power BI Developer with at least 5 years of experience designing, developing, and optimizing Power BI dashboards and semantic data models.
The ideal candidate will be proficient in SQL, DAX, performance tuning, and experienced in Microsoft Fabric, including Direct Lake mode, Medallion architecture, data mesh concepts, and semantic model implementation.

Hands-on experience with Microsoft Copilot in Power BI is highly desirable to assist in AI-powered dashboard development. The developer will work closely with business stakeholders, data engineers, and developers in an Agile environment to deliver high-quality, scalable, and governed data solutions.

Key Responsibilities:

Power BI & Semantic Model Development

• Design, build, and maintain interactive, high-performing Power BI dashboards.
• Implement semantic models in Microsoft Fabric to enable reusable datasets, governed calculations, and enterprise-level analytics.
• Use DAX to define complex measures, KPIs, and business logic.
• Leverage Microsoft Copilot to assist in report creation, analysis, and insight generation.
• Ensure semantic models and datasets follow best practices for scalability, performance, and governance.

Data Analysis & KPI Validation

• Validate KPIs and metrics against source systems using SQL and business rules.
• Analyze datasets for accuracy, completeness, and alignment with business requirements.
• Collaborate with business analysts and stakeholders to translate requirements into semantic models and visualizations.
• Apply business rules, transformations, and KPI definitions to maintain traceability.

Microsoft Fabric & Direct Lake

• Build and manage datasets using Direct Lake mode in Microsoft Fabric.
• Understand Direct Lake limitations and performance considerations and optimize models accordingly.
• Apply knowledge of Medallion architecture (Bronze, Silver, Gold layers) and data mesh concepts to navigate Fabric datasets efficiently.
• Collaborate with data engineers to ensure semantic models integrate seamlessly with data pipelines and governance frameworks.

Performance Optimization & Troubleshooting

• Diagnose and resolve Power BI performance issues, including DAX, model design, and dashboard responsiveness.
• Optimize SQL queries used in underlying data sources.
• Continuously review semantic models and dashboards for performance and usability improvements.

Collaboration & Agile Delivery

• Partner with business stakeholders, data engineers, and BI developers to ensure alignment with requirements and governance standards.
• Participate in Agile ceremonies (sprint planning, stand-ups, reviews, retrospectives).

Required Qualifications:

• Education: Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
• Experience:
  • 5+ years as a Power BI Developer or BI Engineer.
  • Advanced Power BI development and semantic model implementation in Microsoft Fabric.
  • Strong proficiency in SQL and DAX.
  • Hands-on experience with Microsoft Copilot in Power BI.
  • Experience with Direct Lake mode, Medallion architecture, and data mesh concepts.
  • Experience validating KPIs and metrics against source systems.
  • Proven ability to troubleshoot and optimize dashboards and semantic models.

Technical Skills:

• Power BI – report development, DAX, semantic modeling, and performance tuning.
• Microsoft Fabric – Direct Lake, semantic models, and integration with data pipelines.
• Microsoft Copilot – AI-assisted report and dashboard development.
• SQL – advanced querying, joins, aggregations, and data validation.
• Understanding of Medallion architecture and data mesh principles.
• Agile tools: Jira, Azure DevOps, Confluence.

Soft Skills:

• Excellent communication; able to bridge technical and non-technical audiences.
• Strong analytical and problem-solving abilities with high attention to detail.
• Highly organized and capable of managing multiple priorities in Agile sprints.
• Collaborative mindset focused on delivering business value through data.

Preferred (Nice-to-Have):

• Experience with Python or Power Query (M).
• Knowledge of row-level security (RLS) and data access governance.
• Familiarity with data quality and lineage tools (e.g., Microsoft Purview).
• Experience in integrating Power BI with Azure DevOps, SharePoint, or Teams.

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

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.

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:

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 askHR@klgates.com.