compLogoPower BI DeveloperCompany: ITHR Technologies Consulting LLC On-siteKhobar Saudi ArabiaUnited Arab Emirates

 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.