We're looking for a seasoned Power BI Expert to lead endtoend delivery of enterprise BI solutions spanning Power BI Administration, advanced data modeling, pixelperfect reporting with Power BI Report Builder (Paginated Reports), and bestpractice use of external tools. You'll own our Power BI environment's reliability and governance while partnering with data engineering, analytics, and business stakeholders to ship performant dashboards, robust datasets, and scheduled paginated reports aligned to our governance standards.
Key Responsibilities
- Reporting & Delivery: Build highquality reports in Power BI Desktop and pixelperfect artifacts in Power BI Report Builder (Paginated Reports)including email scheduling needs and MHTML delivery constraints.
- Data Modeling & Performance: Design star schemas, define fact/dimension granularity, relationship cardinality, calculation groups, and DAX patterns; apply composite models, DirectQuery vs Import tradeoffs, Incremental Refresh, and Query Folding.
- Platform Administration & Reliability: Administer tenants, capacities, workspaces, gateways, service principals/service accounts, and deployment pipelines; monitor performance and autoscale/resize capacities as needed.
- Governance & Security: Implement and audit Row-Level Security (RLS) and objectlevel security aligned to our RBAC model and data security matrix; collaborate with business data owners to enforce policies and DLP guidance.
- Collaboration & Enablement: Partner with Data Engineering to ensure robust pipelines, gateway setups, and source connectivity; triage incidents and publish RCA; coach analysts/developers on best practices.
Requirements
- 5+ years of handson experience with Power BI (Desktop, Service, Gateway, Admin), delivering production datasets and reports at enterprise scale.
- Advanced data modeling and DAX expertise; strong command of Incremental Refresh, composite models, and performance tuning via external tools.
- Production delivery with Power BI Report Builder for Paginated Reports (pixelperfect), including parameterized reports and scheduled distributions.
- Experience implementing RLS/OLS, AAD groupbased access, and collaborating on data governance/DLP practices.
- Strong SQL and understanding of enterprise data pipelines; ability to work with data engineers on connectivity/auth (including MFA/Conditional Access considerations).
- Proven Power BI Administration skills: capacities, workspaces, gateway clusters, deployment pipelines, tenant settings, auditing, and monitoring.
- Experience with Tabular Editor, DAX Studio, ALM Toolkit, and Azure/Onprem gateways.
- Familiarity with CI/CD for BI (deployment pipelines, parameterization, environment variables).
- Exposure to broader Azure analytics stack (e.g.,/Data Lake/Databricks) and DevOps practices.
- Past work optimizing app performance and capacity utilization, with evidence of handling user complaints and scaling actions.
