Data Analyst
Stefanini · Noida · onsite · Posted 12d ago
Not disclosedFresherfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Description
Remaining Positions:
0
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.
- 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
Pay Range:
Based on Experience
Sourced from foundit
Skills
power querydaxDashboard DevelopmentProcess automationData Quality ManagementVariance AnalysisChartsBusiness requirements gatheringPivot Tablesaudit analyticsPower BiSQLFinancial Reportingdata analysisreconciliationexcelLookup FunctionsConditional formulas
About Stefanini
Stefanini
IT Services & Consulting
725
employees
2002
24 years old
Jaguariúna, Michigan
US
About
Stefanini provides AI and IT solutions to transform business and build the solutions of tomorrow.
Industries
IT Services & Consulting
Employee ratings
349 reviews
2.7/ 5
Culture
2.6
Career growth
2.2
Work-life
2.7
Employees rate it well for
Senior Management68Salary33Work Culture32Work Life Balance29Job Security26
Find them on