Data & Business Analyst – Financial Reporting

Stefanini North America and APAC; Dadri; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Stefanini North America and APAC seeks a Data & Business Analyst to analyze financial data, audit reports, and provide insights for management decisions.

The ideal candidate will have hands-on SQL, Power BI, and advanced Excel skills to create reports, dashboards, and analytics that drive performance and process improvements across finance and operations.

Qualifications

• Bachelor’s degree in finance, accounting, business, data analytics, or a related field.
• 4–5 years of relevant experience in data analysis, business analysis, financial reporting, BI, or audit analytics.
• Strong proficiency in SQL and relational databases.
• Hands-on experience with Power BI, dashboards, Power Query, data modeling, and DAX.
• Advanced Excel skills: pivot tables, lookup functions, conditional formulas, charts, reconciliations.
• Experience with financial reporting, variance analysis, data validation, and reconciliations.
• Ability to audit financial data and investigate discrepancies.
• Strong analytical, problem-solving, communication, and presentation skills.
• Ability to work with multiple stakeholders and manage deadlines independently.

Responsibilities

• Extract, analyze, and validate data using SQL.
• Write queries using joins, subqueries, CTEs, aggregations, temporary tables, and window functions.
• Prepare and maintain financial, operational, and management reports.
• Audit financial data and reconcile information from multiple sources.
• Analyze P&L, revenue, costs, AR, collections, DSO, WIP, and other metrics.
• Perform MoM, QoQ, YoY, and forecast-versus-actual variance analyses.
• Identify data discrepancies, unusual trends, duplicates, and reporting errors.
• Use Excel for pivot tables, lookups, formulas, charts, and data analysis.
• Gather business requirements and translate them into reports, dashboards, and analytics.
• Identify opportunities to automate reporting and reconciliation.
• Present findings and recommendations to management.
• Maintain documentation for reports, queries, dashboards, and processes.

Skills

SQL

Power BI

Excel

Data analysis

Business analysis

Financial reporting

Education

Bachelor’s degree in finance, accounting, business, data analytics, computer science, statistics, or related field

Tools

Power BI

Excel

Job description

Do you want to be a part of a highly innovative, digitally transformative team and work on cutting-edge, state-of-the-art technologies? If yes, then this is for you!

An exciting opportunity awaits, let us help you get started!

Job Title: Data & Business Analyst – Financial Reporting

Job Summary

We are looking for an experienced Data & Business Analyst who can analyze business and financial data, audit reports, identify discrepancies, and provide meaningful insights to support management decision-making.

The ideal candidate should have strong hands‑on experience with SQL, Microsoft Excel, Power BI, financial reporting, reconciliations, and business analysis. The candidate must be able to work independently, understand business requirements, and convert data into accurate reports and actionable recommendations.

Key Responsibilities

• Extract, analyze, and validate data using SQL.
• Write queries using joins, subqueries, CTEs, aggregations, temporary tables, and window functions.
• Prepare and maintain financial, operational, and management reports.
• Audit financial data and reconcile information from multiple sources.
• Analyze P&L, revenue, costs, accounts receivable, collections, DSO, WIP, and other business metrics.
• Perform month-over-month, quarter-over-quarter, year-over-year, and forecast‑versus‑actual variance analysis.
• Identify data discrepancies, unusual trends, duplicate records, and reporting errors.
• Use Excel for pivot tables, lookups, formulas, reconciliations, charts, and data analysis.
• Gather business requirements and translate them into reports, dashboards, and analytical solutions.
• Identify opportunities to automate manual reporting and reconciliation activities.
• Present findings and recommendations clearly to management and business stakeholders.
• Maintain documentation for reports, queries, dashboards, and business processes.

Required Qualifications

• Bachelor’s degree in finance, Accounting, Business, Data Analytics, Computer Science, Statistics, or a related field.
• 4–5 years of relevant experience in data analysis, business analysis, financial reporting, business intelligence, or audit analytics.
• Strong proficiency in SQL and relational databases.
• Hands‑on experience with Microsoft Power BI, including dashboards, Power Query, data modeling, and DAX.
• Advanced Microsoft Excel skills, including pivot tables, lookup functions, conditional formulas, charts, and reconciliations.
• Experience with financial reporting, variance analysis, data validation, and reconciliations.
• Ability to audit financial data and investigate reporting discrepancies.
• Strong analytical, problem‑solving, communication, and presentation skills.
• Ability to work with multiple stakeholders and manage deadlines independently.

Preferred Qualifications

• Experience working with financial, ERP, CRM, billing, payroll, ATS or operational data.
• Knowledge of P&L, AR, WIP, collections, provisions, DSO, forecasting, and budgeting.
• Experience with Power Automate, Excel VBA/macros, Python, or other automation tools.
• Experience in an IT service, consulting, staffing, or multinational organization.