STEM OPT Power BI Jobs

INTRODUCTION

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 a Fabric Power BI Developer to join K&L Gates. The Fabric Power BI Developer creates scalable, governed, and optimized dashboards and Microsoft Fabric semantic models for enterprise use. Collaborating with stakeholders and data engineering, they define KPIs, validate data integrity, and establish durable modeling patterns. Utilizing Microsoft Fabric (e.g., Direct Lake) and Copilot in Power BI, they accelerate insights while ensuring governance and usability. The role leads complex analytics delivery, establishes visualization standards, and supports data-driven decision-making. Working in an Agile environment, the developer ensures scalable solutions that align with organizational needs and promote effective analytics practices. Candidates must be self-starters who possess the ability to work independently and as part of a team. Excellent communication skills and a commitment to providing the highest quality client service are strongly preferred.

KEY RELATIONSHIPS

• Director, Enterprise Applications, Data, and AI Platforms
• Senior Manager, Automation and Development
• Senior Manager, Data Engineering
• Senior Manager, Enterprise Applications
• Senior Applications Architect
• Data Architect
• Team Lead, Workflow and Automation
• Technical Program Manager
• Project Manager
• Business Relationship Manager
• Vendor and Partner Delivery Leads
• Senior Manager, Data Governance

ESSENTIAL DUTIES

• Leading the design, development, and lifecycle oversight of Power BI dashboards and reporting solutions, establishing visualization standards across the organization.
• Owning semantic model strategy in Microsoft Fabric, enabling reusable datasets, governed calculations, and enterprise analytics standards.
• Developing advanced DAX measures, KPIs, and calculations while leading performance optimization across models, DAX, report responsiveness, and underlying SQL sources.
• Building and managing Microsoft Fabric datasets using Direct Lake mode, optimizing performance through design considerations and platform constraints.
• Applying Medallion architecture (Bronze/Silver/Gold) and data mesh concepts while ensuring semantic models align with data pipelines and governance frameworks throughout their lifecycle.
• Establishing and maintaining key metric definitions, validation routines, and traceability using SQL and predefined business rules.
• Driving governance best practices for semantic models and datasets ensuring scalability, consistency, and maintainability while fostering adoption within the BI ecosystem.
• Defining and managing the testing strategy, incorporating quality standards, User Acceptance Testing frameworks, and validation of business functions and reporting outputs.
• Partnering with business stakeholders and analysts to translate requirements into semantic models and visualizations, ensuring clarity on outcomes and success measures.
• Providing Agile delivery leadership within sprint ceremonies and cross-functional planning to deliver prioritized analytics outcomes.
• Leveraging AI tools, contributing to AI-powered analytics solutions, and adhering to firm AI governance standards, including responsible use, classification, and deployment controls.
• Advocating enterprise processes, procedures, security standards, and a knowledge-first approach, serving as an example for the Enterprise Applications team.

EXPERIENCE SKILLS REQUIRED

• Hold Bachelor’s degree in a technical field or equivalent experience; possess or obtain relevant Microsoft certifications including PL-300 and DP-600.
• Demonstrate knowledge of Medallion architecture and data mesh concepts, with experience implementing and governing Microsoft Fabric semantic models and enterprise analytics standards.
• Maintain a secure, professional workspace and be available to travel up to 10% for offices, vendors, conferences, or seminars.
• Be available for scheduled release windows and production support events, occurring 2–4 times per quarter, including evenings or weekends.
• Demonstrate advanced DAX expertise and Power BI development skills, including semantic modeling, visualization creation, and performance optimization.
• Demonstrate ability translating business needs into functional analytics requirements, with the ability to communicate technical concepts clearly to non-technical stakeholders.
• Demonstrate exceptional SQL skills for querying and validation, with experience validating KPIs and metrics against business rules and source systems.
• Demonstrate exceptional stakeholder communication and ability to lead delivery within an Agile model (e.g., Jira, Azure DevOps, Confluence).
• Collaborate, engage, and communicate with team members across locations and time zones while interacting professionally with diverse personalities.
• Communicate technical concepts visually through diagramming, whiteboarding, and collaborative tools in hybrid or remote work settings effectively.
• 2+ years of progressive experience as a Power BI Developer or BI Engineer delivering enterprise reporting solutions.
• Possess experience using Microsoft Copilot and AI-assisted tools within enterprise environments to accelerate analytics development, quality, and insight delivery.

ADDITIONAL ABILITIES REQUIRED

COMPENSATION

• Salary: $112,000 - $209,000 / year

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:

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