Senior Power BI & Excel Dashboard Developer for Enterprise Business Intelligence Platform

About the project

We are looking for an experienced Power BI and Excel Dashboard Developer to help finalize an enterprise-level Business Intelligence and reporting platform built on Microsoft Excel and Microsoft 365. This is not a simple dashboard project. The platform has already been architected and includes project management, KPI management, executive reporting, organizational hierarchy, master data management, and operational workspaces. We need an experienced consultant to help complete, optimize, and polish the dashboards and reporting layer into a production-ready solution. ⸻ Project Overview The platform already includes: * Enterprise Master Data * Project Portfolio Management * PMO Framework * KPI Management Framework * Employee Performance Management * Organizational Hierarchy * Executive Reporting Structure * Operational Workspaces * Business Rules * Data Validation Framework * Power BI Data Model Planning The selected freelancer will help transform this into a professional executive reporting platform. ⸻ Scope of Work Executive Dashboards Develop executive dashboards including: * Executive Overview * Project Portfolio Dashboard * Project Health Dashboard * Financial Dashboard * PMO Dashboard * Commercial Dashboard * HR Dashboard * Procurement Dashboard * Engineering Dashboard * Quality Dashboard * HSE Dashboard * Sales Dashboard ⸻ Power BI * Build interactive executive dashboards * Create an optimized data model * Develop DAX measures and KPIs * Design drill-through pages * Implement role-based reporting * Optimize report performance ⸻ Excel Enhance existing Excel workbooks by: * Building interactive dashboards * Creating KPI scorecards * Dynamic charts and visualizations * Conditional formatting * Data validation * Performance optimization * User-friendly navigation ⸻ Reporting Develop automated: * Weekly Reports * Monthly Reports * Executive Reports * Department Performance Reports * Portfolio Reports ⸻ Data Quality Review and improve: * Data relationships * Lookup tables * Validation rules * Duplicate detection * Dashboard performance * Data consistency ⸻ User Experience Improve: * Dashboard design * Navigation * Executive presentation quality * Visual consistency * Ease of use ⸻ Technology Stack Current environment includes: * Microsoft Excel * Power BI * Microsoft 365 * SharePoint Online * Power Automate (planned) * Future ERP integration ⸻ Required Skills The ideal candidate should have proven experience with: * Power BI * Microsoft Excel (Advanced) * Power Query * DAX * Power Pivot * Data Modeling * Business Intelligence * KPI Dashboard Development * Executive Reporting * PMO Reporting * Project Portfolio Management Experience with construction, engineering, EPC, or project-based organizations is highly desirable. ⸻ Nice to Have Experience with: * SharePoint * Power Automate * SQL * ERP systems (Odoo, SAP, Oracle, Dynamics, etc.) * Microsoft Fabric * Portfolio Management * Enterprise KPI Frameworks ⸻ Deliverables The selected freelancer will help deliver: * Production-ready Power BI dashboards * Executive reporting dashboards * Optimized Excel dashboard workbooks * Improved data model * KPI calculations and measures * Dashboard documentation * Performance optimization * Final polished reporting package ⸻ Project Duration This is an initial implementation phase with the potential for a long-term collaboration on future Microsoft 365 automation, business intelligence enhancements, and ERP integration. ⸻ To Apply Please include: 1. Links or screenshots of Power BI dashboards you’ve built. 2. Examples of executive dashboards or management reporting solutions. 3. Experience with project portfolio or PMO reporting. 4. Experience with Excel-based business intelligence systems. 5. Your availability. 6. A brief description of how you would approach this project. ⸻ Additional Notes * Existing architecture and data model are already available. * The focus is on implementation, optimization, and delivering a polished production-quality solution. * Strong communication skills and attention to detail are essential. * Preference will be given to freelancers who have previously delivered enterprise dashboard solutions for medium or large organizations.

Skills required