Senior Financial Analyst

Overview

Reporting Analyst - Finance role focused on finance reporting, Excel-based analysis and Power BI dashboards for management reporting.

What you'll do

• Prepare daily, weekly, and monthly finance reports.
• Work on revenue, cost, expenses, budget, forecast, and variance analysis reports.
• Manage Excel reports with large data, multiple sheets, and complex formulas.
• Use formulas such as XLOOKUP, VLOOKUP, SUMIFS, IF, INDEX-MATCH, Pivot Tables, and charts.
• Check data accuracy and perform basic reconciliations.
• Create summary reports and management dashboards.
• Build and maintain Power BI dashboards for finance reporting.
• Use Power Query to clean and transform data.
• Create basic to intermediate DAX measures such as revenue, cost, margin, variance, MTD, and YTD.
• Manage relationships between tables in Power BI.
• Refresh reports and ensure dashboards are updated on time.
• Coordinate with finance, accounting, and business teams for reporting requirements.

What you'll need

• Strong knowledge of Microsoft Excel and complex formulas.
• Experience working with large datasets.
• Intermediate knowledge of Power BI Desktop.
• Knowledge of Power Query for data cleaning and preparation.
• Ability to create Power BI visuals, slicers, filters, cards, charts, and tables.
• Basic to intermediate understanding of DAX formulas.
• Good understanding of P&L, budget vs actuals, expense reports, and variance analysis.
• Ability to validate data and identify reporting errors.
• Good analytical skills, attention to detail, and ability to meet deadlines.
• 2 to 5 years of experience in finance reporting, MIS reporting, Power BI reporting, or similar roles.

Nice to have

• Knowledge of Excel Power Query, macros, or basic VBA.
• Experience in preparing management reports, P&L reports, budget reports, and financial dashboards.
• Ability to explain reports and insights to finance and business teams.