Power BI Lead

Stack

Responsibilities

• ▹Design and own the Power BI semantic layer (datasets, shared models, calculated measures)
• ▹Define the data-sourcing strategy from both MCP/LOS and the data warehouse/mart
• ▹Establish medallion or equivalent layering conventions for data freshness and reliability
• ▹Govern gateway configuration, scheduled refresh, and performance optimization
• ▹Define and enforce naming conventions, measure libraries, and report templates
• ▹Own workspace organization, access control, and row-level security (RLS) patterns
• ▹Establish version control and deployment pipeline practices (e.g. PBIP/Git)
• ▹Maintain documentation standards for datasets, measures, and data lineage
• ▹Build and own the most complex reports - executive dashboards, KPI scorecards, regulatory outputs
• ▹Write advanced DAX for complex time intelligence, ratios, and dynamic filtering
• ▹Design Power Query/M transformations from MCP DB and warehouse sources
• ▹Review and approve analyst-produced reports before publishing
• ▹Manage and prioritize the BI request intake queue across stakeholder groups
• ▹Assign, scope, and review analyst work, providing technical mentorship
• ▹Represent BI capability in cross-functional planning and project discussions
• ▹Partner with IT/Engineering on data model changes affecting reporting

Requirements

• ▹Advanced Power BI Desktop - complex data models, composite models, DirectQuery
• ▹Advanced DAX - time intelligence, iterators, context transition, dynamic measures
• ▹Power Query / M - multi-source transformation, parameterization, error handling
• ▹SQL proficiency - query optimization, joins, aggregations against relational databases
• ▹Familiarity with data warehouse concepts - star schema, slowly changing dimensions
• ▹Power BI Service administration - workspaces, deployment pipelines, RLS, gateway
• ▹Version control fundamentals (Git or equivalent)
• ▹Proven ability to define BI standards and enforce adoption across a team
• ▹Experience designing executive-facing dashboards with clear KPI storytelling

Nice to have

• ▹Mortgage/lending industry familiarity - pipeline metrics, pull-through, cycle time, regulatory reporting

Soft skills