Power BI / Microsoft Fabric Developer for CFO Dashboard
Worldwide
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- IntermediateExperience Level
- Remote Job
- Ongoing projectProject Type
Skills and Expertise
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
- United KingdomLondon7:34 AM
- $320 total spent3 hires, 0 active
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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