Financial BI Analyst (Power BI & SQL)

Quick Facts

• Role: Financial BI Analyst (Power BI & SQL)

• Focus: financial reporting reconciliation, data validation, and Power BI dashboard development

Description

Work as a Financial BI Analyst combining financial reporting expertise with hands-on SQL and Power BI to investigate discrepancies, strengthen data validation, and improve dashboards used by finance and executive stakeholders.

Responsibilities

• Investigate discrepancies by comparing ERP records with downstream data and reports to find missing records, duplicates, timing differences, and inconsistent calculation logic

• Design and maintain recurring data validation checks across source systems, databases, Lakehouses, semantic models, and reports

• Maintain and extend a Data Reconciliation Dashboard to detect issues before results are shared

• Reconcile figures across reports, align business logic, and explain legitimate differences

• Follow issues through to resolution by coordinating fixes with relevant specialists; flag or temporarily restrict affected reports when necessary

• Maintain and develop Power BI reports: refine visuals, adjust DAX measures, improve performance, and deliver new reports

• Improve dashboard usability by consolidating overlapping reports into cohesive executive views

• Coordinate technical changes with Data Engineering and the Power BI team to incorporate new data sources and update shared models

• Gather requirements, clarify reporting logic, support business users, and create practical guides and training materials

• Document KPI definitions, calculations, filters, access rules, and data lineage; provide timely stakeholder updates on changes and blockers

Requirements

• Practical experience in financial reporting, finance analytics, or BI supporting finance teams

• Solid SQL query-writing skills for reconciliation and discrepancy investigation

• Hands-on Power BI experience with semantic models; able to write or adjust basic to intermediate DAX measures

• Root-cause analysis skills to trace issues across systems and distinguish technical errors vs business logic differences vs timing effects

• Functional understanding of data pipelines and data architecture (databases, Lakehouses, Microsoft Fabric concepts)

• Strong English communication skills to explain findings to non-technical stakeholders

• Proactive ownership to resolve issues and keep stakeholders informed

Benefits

• Long-term, stable contract

• Opportunities to strengthen skills in a learning-focused environment

• Comprehensive benefits package

• Remote-first work environment with hybrid options available