joinmakropro logojoinmakropro logo

Department Manager - Advanced Analytics Partner

joinmakroproBangkok, Bangkok, Thailand
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Experience Level

Mid to Senior

Qualifications

Requirements5+ years of professional experience with Power BI (Desktop, Service, Gateway, Admin), successfully delivering production datasets and reports at an enterprise scale. Expertise in advanced data modeling and DAX; proficient in Incremental Refresh, composite models, and performance optimization using external tools. Experience in production delivery utilizing Power BI Report Builder for Paginated Reports, including parameterized reports and scheduled distributions. Knowledge of implementing RLS/OLS, AAD group-based access, and active collaboration on data governance and DLP practices. Strong SQL skills and understanding of enterprise data pipelines; capability to collaborate with data engineers on connectivity/authentication (including MFA/Conditional Access considerations). Demonstrated Power BI Administration capabilities: managing capacities, workspaces, gateway clusters, deployment pipelines, tenant settings, auditing, and monitoring. Familiarity with tools such as Tabular Editor, DAX Studio, ALM Toolkit, and Azure/On-premises gateways. Understanding of CI/CD for BI, including deployment pipelines, parameterization, and environment variables. Exposure to the broader Azure analytics stack (e.g., Data Lake, Databricks) and DevOps methodologies.

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.

About joinmakropro

At joinmakropro, we are committed to leading the way in advanced analytics and business intelligence solutions. Our team is a blend of innovative thinkers and seasoned experts dedicated to transforming data into actionable insights for our clients across various industries. Join us and be part of a forward-thinking company that values collaboration, creativity, and a commitment to excellence.

Similar jobs

Browse all companies, explore by city & role, or SEO search pages.

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.