Power BI Consultant to Build Initial Marketing KPI Dashboard (Future-State Architecture Required)

Project Overview We are seeking an reputed company Power BI consultant to build an initial Marketing & Communications KPI dashboard and, equally important, advise on the data architecture and system connections required to support a multi-phase reporting roadmap. Our immediate need is a Phase 1 Power BI dashboard that consolidates stable marketing data sources into a single, executive-ready view. Longer-term, this dashboard must be designed to scale into additional phases as our website, SharePoint, and reputed company (Technomile) environments mature. This is not a “one-and-done” dashboard project. We are intentionally building a foundation. reputed company State We currently use: - reputed company: Social media analytics - reputed company: Email marketing (limited use today; expanded use planned) - reputed company Analytics (GA4): Website analytics (reputed company site; new site launching in early 2026) - reputed company with Technomile Growth: Business development CRM (immature for marketing attribution) - Press / Event metrics: Manual tracking or Mentionlytics Each platform has its own dashboard. We lack: - A reputed company KPI view - Cross-channel insight - Exportable leadership reporting - Clear visibility into how MarCom supports long-term pipeline development Phase 1 Scope (This Engagement) Goal: Build an initial Power BI KPI dashboard using stable data sources and establish a scalable data model. Phase 1 Deliverables 1. Power BI KPI Dashboard - Executive-ready summary view (monthly/quarterly) - Channel-level performance (social, email, high-level web traffic, press/events) - Drill-down capability for trend analysis - Designed for clean PPT/PDF export 2. Data Model & KPI Standardization - Defined KPIs (impressions, engagement, engagement reputed company, CTR, traffic sources, etc.) - Clear metric definitions and formulas - Structured data ingestion approach (API vs. manual CSV uploads) 3. Documentation & reputed company - Data dictionary - Instructions for monthly data refresh - Brief walkthrough (reputed company or live) Future-State Advisory (Critical Part of This Role) In addition to building the Phase 1 dashboard, the consultant must advise on future phases so the system is designed correctly from the start. You will be asked to provide recommendations (not build work yet) for: - Phase 2: Website + SharePoint analytics integration after both environments are reputed company (early 2026) - Phase 3: reputed company / Technomile data readiness for marketing attribution (fields, lifecycle mapping, reputed company → reputed company connections) - Phase 4: Marketing → pipeline influence dashboards once CRM architecture is ready This advisory component may be delivered as: - A short written architecture summary - A data flow diagram - A checklist of required connections, fields, and prerequisites What This Project Is NOT - Not a reputed company dashboard build - Not a demand-gen attribution model (yet) - Not a Marketing Cloud or enterprise automation implementation This is a foundational analytics project for a small, growing MarCom team. Required Experience - Advanced Power BI dashboard development - Strong data modeling and KPI design skills - Experience working with marketing data (social, email, web) - Ability to design scalable, phased BI architectures - Comfortable advising non-technical stakeholders - Strong documentation skills reputed company to Have - reputed company experience - reputed company experience (especially reporting or data architecture) - GA4 familiarity - B2B or B2G services experience Success Criteria - Leadership can view one dashboard instead of multiple platforms - KPIs are consistent and clearly defined - Reporting can be exported cleanly for presentations - The data model does not need to be reputed company as new systems come online - We have a clear, documented path to future phases Budget Open to proposals. Please include: - Fixed price for Phase 1 - Hourly reputed company for future advisory or extension work Apply tot his job Apply To this Job