Details

We are looking to hire a data analyst to join our MIS team. You will take responsibility for managing our master data set, developing reports, and troubleshooting data issues. To do well in this role you need the work upon ATS .

An applicant tracking system (ATS) is software that manages the recruiting and hiring process, including job postings and job applications. It organizes information about job seekers and makes it searchable. As its name implies, an ATS tracks candidates through the hiring process.

It helps with interview scheduling, issues notifications and alerts, and sends automated emails to candidates and employees, such as recruiters and hiring managers.

Job Requirements

Details

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.
- Robust 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 Analyst (Noida)
🏢 Stefanini North America and APAC
📍 Noida