Job description
Power BI Developer Experience: 5–6 years | Location: Dhahran/Khobar, KSA — onsite only | Duration: 3 months (extension possible) | Availability: Immediate Role Overview Deliver the reporting and visualization layer of the MRO Inventory Optimization platform — building performant, governed Power BI models and dashboards for operational users and executives, sourced from BigQuery and the project's data services.
Must-Have — technical depth expected Power BI: End-to-end report development, visual selection and design, drill-through, bookmarks, tooltips, performance tuning (reducing visual/query load).
DAX: Measures vs calculated columns, CALCULATE and filter context, time-intelligence functions, iterators (SUMX/AVERAGEX), variables, debugging context transition.
Power Query (M): Data shaping, merges/appends, parameterization, query folding awareness, handling incremental refresh sources.
Data modeling: Star schema design, fact/dimension modeling, relationship cardinality and filter direction, avoiding many-to-many pitfalls, optimizing model size (column cardinality, aggregations).
SQL / BigQuery: Writing and tuning source queries, DirectQuery vs Import trade-offs, working with partitioned warehouse tables.
Row-Level Security (RLS): Static and dynamic RLS, role definitions, USERPRINCIPALNAME-based filtering, testing security roles.
Good-to-Have Paginated reports (Report Builder), Power BI Service administration (workspaces, gateways, refresh schedules, deployment pipelines), data governance (sensitivity labels, lineage, certified datasets), Python/R visuals or scripting, Azure DevOps for version control and deployment.
Scope of Work Build KPI dashboards for inventory metrics (stock levels, turnover, carrying cost, stockout risk, slow-moving/obsolete inventory).
Develop inventory analytics views with drill-down by plant, material group, and criticality.
Create executive dashboards with high-level summaries and trend analysis.
Design the underlying semantic model, implement RLS for multi-plant/role access, and optimize refresh performance.
This job post has been translated by AI and may contain minor differences or errors.
Preferred candidate
Years of experience
No experience required
Degree
Bachelor's degree / higher diploma