The life-insurance IT team delivers division-level management reporting and budget control tools. This role exists to move a fragmented set of Excel files, PowerPoint reports and in-house extracts into a single automated Power BI solution, so you will work on Power BI dashboard automation and BI reporting consolidation using strong MS Office skills.
The mission
The project replaces manual reporting across the life-insurance division with an automated Power BI dashboard that refreshes from source systems. The current landscape includes multiple Excel workbooks, several existing dashboards and monthly management slide decks; the deliverable is a consolidated, refreshable Power BI solution that supports budget owners and KPI owners and reduces manual extraction.
Day to day you will analyse existing data flows and report logic, recreate and consolidate existing reports into new Power BI pages, implement scheduled data refreshes and document the end-to-end solution. You will work alongside a small delivery team (3-5 people) and business subject-matter experts, provide training so a business expert reaches autonomy in maintenance, and present progress to division management during the 6-month engagement.
Your responsibilities
- Analyse existing Excel, PowerPoint and dashboard reports to map data flows and report calculations, ensuring a single source of truth.
- Design and build the consolidated Power BI dashboard, including data model, measures and visuals that replace current reports.
- Implement automated data extraction and scheduled refreshes, and where appropriate use Power Automate to streamline processes.
- Migrate and validate report content so monthly and weekly management reports match or improve current outputs.
- Train and hand over to a nominated business expert, producing clear documentation and best-practice guidance for Power BI structure and maintenance.
- Communicate progress and decisions to division management with structured, concise reporting.
Your profile
Essential skills
- Senior experience in BI reporting, with 5+ years building and maintaining dashboards and reports.
- Advanced Power BI capability, including data modelling, DAX and performance tuning.
- Strong MS Office skills, especially Excel for analysis and validation.
- Accurate analytical mindset, clear presentation skills and experience working collaboratively in small technical-business teams.
- Ability to explain technical choices to management and produce handover documentation.
Preferred skills
- Practical experience with Power Automate to orchestrate refresh or file flows.
- Project management knowledge and experience working in insurance or financial reporting contexts.
Languages
- English, Dutch, French: CEFR C1
Education
- Bachelor or Master degree in IT, data, business analytics or equivalent professional experience.