Senior Data Analyst-MS excel
Posted
Summary
Senior data analyst (5+ yrs) building and automating financial reporting and MIS dashboards for business stakeholders at SWITS DIGITAL in Bangalore. Day-to-day work centers on Advanced Microsoft Excel and Power Query to consolidate, cleanse, and analyze financial data across cost centres, budgets, and WBS structures.
Job Title- Sr.Data Analyst-MS Excel
Experience-5+ years
Location -Bangalore
Job Summary
We are looking for an experienced Financial Reporting & MIS Analyst with strong hands-on expertise in Advanced Microsoft Excel and Power Query. The ideal candidate should have a good understanding of business processes, financial reporting, cost centre management, and Work Breakdown Structure (WBS).
The candidate will be responsible for handling complex financial data, consolidating information from multiple sources, transforming data using Power Query, and preparing accurate reports to support business decisions.
Key Responsibilities
Experience-5+ years
Location -Bangalore
Job Summary
We are looking for an experienced Financial Reporting & MIS Analyst with strong hands-on expertise in Advanced Microsoft Excel and Power Query. The ideal candidate should have a good understanding of business processes, financial reporting, cost centre management, and Work Breakdown Structure (WBS).
The candidate will be responsible for handling complex financial data, consolidating information from multiple sources, transforming data using Power Query, and preparing accurate reports to support business decisions.
Key Responsibilities
- Develop, maintain, and automate financial reports using Advanced Microsoft Excel.
- Work with large financial datasets, reporting sheets, and business information to ensure accuracy and consistency.
- Use Power Query for data extraction, cleansing, transformation, consolidation, and analysis.
- Prepare and maintain financial reports related to cost centres, budgets, expenses, and business performance.
- Understand and analyze business processes, financial data, cost centre structures, and Work Breakdown Structure (WBS).
- Consolidate data from multiple sources and convert complex information into meaningful reports.
- Perform data validation, reconciliation, and quality checks to ensure reporting accuracy.
- Analyze financial and business data, identify trends and discrepancies, and provide actionable insights.
- Prepare dashboards, summaries, and management reports for business stakeholders.
- Collaborate with Finance, Operations, and other business teams to understand reporting requirements.
- Present analytical findings and communicate insights effectively to stakeholders.
- Identify opportunities to improve reporting processes and reduce manual effort through Excel and Power Query automation.
- Minimum 5+ years of experience working with Advanced Microsoft Excel
- Hands-on experience with Power Query for data transformation, cleansing, merging, appending, and consolidation.
- Strong understanding of business processes and financial reporting.
- Experience working with financial data, reporting sheets, and management reports.
- Knowledge of Cost Centre reporting and Work Breakdown Structure (WBS).
- Strong analytical, problem-solving, and data interpretation skills.
- Ability to consolidate and present complex business and financial data effectively.
- Excellent stakeholder communication and business understanding.
Skills
Sign in to read and join the discussion.