Finance Business Intelligence Analyst

The role

You turn finance and operational data into the dashboards a whole company runs on. Sales wants margin by store and promotion, procurement wants supplier cost and quality, production wants scrap, overrun and on-time delivery, and the CEO wants six numbers that say whether the business is on track. You build one model that serves all of them, straight from the source databases, and you know the finance behind every measure.

• Power BI models on a clean star schema, built from the source databases rather than spreadsheet exports
• DAX for every department: margin, discount and promotion dilution, cost variance, scrap, on-time delivery, working capital
• Three layers of reporting: a CEO page, manager pages with drill-down, and daily action lists for the operations team
• Financial analysis and management reporting: what moved, why, and who should act
• Python for the heavier data work and checks the model cannot do on its own

What we look for

• Power BI modelling and fluent DAX — time intelligence, ranking, conditional formatting driven by measures
• SQL and relational database basics; comfortable with data outside the finance function
• Dashboards designed for non-finance users: the right page for the right person
• Finance grounding: management reporting, variance analysis, working capital
• Good to have: Python basics (pandas); Oracle Fusion data — GL, AP, AR, Procurement, CRM and Payroll / HCM — via OTBI or BI Publisher extracts

What you'll be tested on

Two Data Dare datasets. Type an answer per question, and upload your solved Power BI file for each dataset — required, and what the reviewer reads. A Python notebook is optional and strengthens your profile. No deadline: submit when your work is complete. Datasets unlock when you apply.