Power BI Developer Needed for Dynamic Price Tracker Dashboard

We are looking for an experienced Power BI developer to build a Dynamic Price Tracker dashboard for retail and ecommerce pricing analysis. The dashboard will analyze selling prices across Channel, Retailer, Category, Segment, Brand, SKU, Variant, and Date. The goal is to help business users quickly understand price movement, retailer comparison, benchmark compliance, pricing gaps, and pricing opportunities. The developer is expected to study the data, understand the business objective, propose the dashboard structure, and build the report in Power BI. The dashboard should support: * Executive-level overview * Detailed analysis across retailer, channel, category, brand, SKU, and date * SKU-level investigation * Benchmark and compliance tracking * Price movement and trend analysis * Opportunity or exception identification * Drill-through and interactive filtering * Clean, business-friendly visual design Milestone 1: Prototype and Logic Validation, 50% The prototype must show the full proposed dashboard direction, not just one or two sample pages. This milestone should include: * Data review and data gap notes * Proposed data model * Initial Power Query transformations * Core DAX measures * Prototype views covering all major analysis areas * Basic slicers, filters, drill-through, and conditional formatting * Explanation of assumptions and limitations The prototype does not need final formatting, but it must prove that the model, logic, and dashboard direction are correct. Milestone 2: Final Dashboard Delivery, 40% Final delivery should include: * Completed PBIX file * Clean data model * Final Power Query transformations * Final DAX measures * Finished dashboard design * Working filters, slicers, and drill-through * Conditional formatting * Measure documentation * Data quality notes * Recommendations for improvement Milestone 3: Revisions and Handover, 10% This phase will cover: * Calculation fixes * Visual adjustments * Layout refinements * Minor stakeholder feedback * Final documentation * Handover walkthrough Required Skills: * Advanced Power BI * Strong DAX * Strong Power Query * Data modeling * Retail, ecommerce, or pricing analytics experience * Ability to translate business questions into dashboard logic * Ability to propose dashboard structure without a fixed design file Application Questions: 1. Have you built pricing, retail, ecommerce, or competitor analysis dashboards before? 2. How would you approach understanding the data before building the dashboard? 3. How would you structure a model for retailer, channel, brand, SKU, and date-level analysis? 4. How do you validate DAX measures to avoid incorrect aggregation? 5. What would you deliver in the prototype phase? 6. How would you make the dashboard easy for business users to understand quickly? 7. What is your estimated timeline for prototype and final delivery? Please apply only if you are comfortable with data modeling, DAX, Power Query, and business logic. We are not looking for someone who only creates basic visuals.