Stefanini Group is hiring!
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 prospect awaits, let us help you get started!
Click Apply now or email:
[email protected] for faster processing!
Job Title: Data & Business Analyst – Financial Reporting
Experience: 4–5 years
Location: NOIDA
Employment Type: Full-time
Primary Skills: SQL, Power BI, Excel, Financial Analysis, Business Analysis
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.
- Develop and maintain dashboards using Power BI.
- 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.
Key Skills
- SQL and data analysis
- Financial reporting and audit
- Power BI and dashboard development
- Advanced Excel
- Reconciliation and variance analysis
- Business requirements gathering
- Data quality management
- Process automation
- Stakeholder communication
📌 Data & Business Analyst – Financial Reporting (Noida)
🏢 Stefanini North America and APAC
📍 Noida