Power BI / Microsoft Fabric Developer for CFO Dashboard

Posted last week

Worldwide

Summary

Seeking an experienced Power BI / Microsoft Fabric developer to create a reusable white-label CFO dashboard for eCommerce clients. The project involves integrating financial data from various sources and creating a user-friendly interface for financial analysis. The ideal candidate will have experience in data visualisation and financial reporting. I am looking for an experienced Power BI / Microsoft Fabric developer to build a reusable white-label CFO / CEO dashboard for eCommerce clients. The first project will be a pilot dashboard for Superspace, with the intention of rolling the same framework out to at least two further clients. The dashboard needs to connect data from Xero or QuickBooks, Shopify, Meta Ads, Google Ads and Google Sheets, with daily refreshes and secure deployment into each client’s own Microsoft tenant. This is not just a visual dashboard project — I need a proper reusable data model, KPI structure and reporting framework that can be replicated across multiple eCommerce clients. The dashboard should include CEO-level financial and commercial reporting, including net sales, gross margin, product margin, contribution margin, EBITDA, cash, ad spend, MER, ROAS, CAC, CLV vs CAC by monthly customer cohort, new customers, customer value since first order, forecast vs actuals, sales by product/market/channel, and margin analysis. Xero or QuickBooks will be the financial source of truth, while Shopify will provide product, customer, order and market-level detail. Forecast and inventory/product cost data will initially come from Google Sheets. The dashboard must also support branded reporting, investor views, alerts based on custom thresholds, weekly CEO email outputs, and high-quality PDF/PowerPoint exports. The right person will have strong Power BI, DAX, Power Query, data modelling and ideally Microsoft Fabric experience, plus practical experience connecting and reconciling data from Xero/QuickBooks, Shopify, Meta Ads, Google Ads and Google Sheets. eCommerce KPI experience is important, especially around net revenue, refunds, discounts, VAT/sales tax, gross margin, contribution margin, CAC, MER, ROAS and cohort-based CLV. Please apply only if you can build a robust, reusable model rather than a one-off report. In your response, please include examples of similar dashboards you have built, your recommended technical approach, expected timeline, and whether you would propose using managed connectors or custom API integrations.

  • $5,000.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Data Modeling
Microsoft Power BI Development
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:last week
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Sep 18, 2024
  • United Kingdom
    London7:34 AM
  • $320 total spent
    3 hires, 0 active

Explore similar jobs on Upwork

Accounting
Financial Planning
Cash Flow Modeling
Company Valuation
Budget Management
Financial Modeling
Finance & Accounting
Financial Management
Financial Policies & Procedures
Air Ticket GDS and ARC SpecialistHourly‐ Posted 1 month ago

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo