About the job
Join our dynamic team at joinmakropro as a Department Manager specializing in Advanced Analytics. We are seeking a highly skilled Power BI Expert to spearhead the comprehensive development and delivery of enterprise BI solutions. Your expertise will cover Power BI Administration, advanced data modeling, and the creation of pixel-perfect reporting through Power BI Report Builder (Paginated Reports). You will play a pivotal role in ensuring the reliability and governance of our Power BI environment, collaborating closely with data engineering, analytics, and business stakeholders to deliver high-performance dashboards, robust datasets, and scheduled paginated reports that adhere to our governance standards.
Key Responsibilities
- Reporting & Delivery: Craft high-quality reports using Power BI Desktop and create pixel-perfect artifacts in Power BI Report Builder (Paginated Reports), including managing email scheduling and MHTML delivery constraints.
- Data Modeling & Performance: Design intricate star schemas, establish fact/dimension granularity, relationship cardinality, calculation groups, and DAX patterns; utilize composite models, weigh DirectQuery against Import options, and implement Incremental Refresh and Query Folding.
- Platform Administration & Reliability: Oversee tenant management, capacities, workspaces, gateways, service principals/service accounts, and deployment pipelines; monitor performance and adjust capacities as necessary.
- Governance & Security: Enforce Row-Level Security (RLS) and object-level security in alignment with our RBAC model and data security matrix; partner with business data owners to uphold policies and DLP guidelines.
- Collaboration & Enablement: Collaborate with Data Engineering to ensure the establishment of robust pipelines, gateway configurations, and source connectivity; resolve incidents and share root cause analysis; mentor analysts and developers on best practices.
