Experienced Power Bi Developer for Medical Supplies Report with Advanced Dax

We are seeking an experienced Power BI developer to finalize a critical report for a medical supplies distributor. The foundational data model and Power Query scripts are already in place, allowing the focus to be on advanced report development and calculations.

The primary responsibilities for this project include:
- Developing DAX calculated columns and approximately 35 complex measures.
- Designing the report layout and ensuring all labels are in Spanish.
- Implementing calculations for stock levels, expiry dates, risk assessment, product valuation, returns, and material status.
- Integrating a 'what-if' parameter to analyze different expiry windows.
- Applying a custom JSON theme for consistent branding and aesthetics.
- Creating 6 comprehensive report pages featuring key performance indicators (KPIs), various charts, detailed tables, heatmaps, and interactive slicers.
- Ensuring slicers are synchronized across all report pages for a cohesive user experience.
- Performing thorough validation of all report totals against provided Excel pivot tables to ensure data accuracy.
- Documenting each developed measure with clear, concise explanations.

The report will utilize existing SAP Excel data, covering operations across 4 hospitals, approximately 50 distinct products, and multiple lots per product. We will provide the current PBIX file, M code, draft DAX logic, and expected validation values.

Required Skills:
- Strong proficiency with Power BI Desktop.
- Exceptional DAX formula writing skills.
- Proven experience in data modeling and effective report design.
- Ability to communicate effectively in English.
- Mandatory requirement for Spanish report labels.