Jobs · Information Technology · Massachusetts

Fabric Power BI Developer

K&L Gates · Boston, MA · 1 wk ago
On-siteInformation Technology$112k–$209k/yrFull-time

About the role

The Fabric Power BI Developer creates scalable, governed, and optimized dashboards and Microsoft Fabric semantic models for enterprise use. They collaborate with stakeholders and data engineering to define Key Performance Indicators (KPIs), validate data integrity, and establish durable modeling patterns. Using 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 in an Agile environment.

Responsibilities

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

Requirements

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

Qualifications

  • Advanced DAX expertise and Power BI development skills, including semantic modeling, visualization creation, and performance optimization.
  • Exceptional SQL skills for querying and validation, with experience validating KPIs and metrics against business rules and source systems.
  • Exceptional stakeholder communication and ability to lead delivery within an Agile model (e.g., Jira, Azure DevOps, Confluence).
  • Collaboration, engagement, and communication with team members across locations and time zones while interacting professionally with diverse personalities.
  • Communication of technical concepts visually through diagramming, whiteboarding, and collaborative tools in hybrid or remote work settings effectively.
  • Experience using Microsoft Copilot and AI-assisted tools within enterprise environments to accelerate analytics development, quality, and insight delivery.

Similar jobs

Fabric Power BI Developer

K&L GatesCharleston, SC· 1 wk ago
Information Technology$112k–$209k/yrapply on klgates.recsolu.com