Senior Data Analyst-MS excel

5 years

Bengaluru

Posted:1 day ago

Job Description

Job Title- Sr.Data Analyst-MS Excel

Experience-5+ yearsLocation -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.

Required Skills & Experience

  • 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 Required

MS Excel Financial Reporting MIS Microsoft Excel Power Query Business Processes Data Extraction Data Validation Reconciliation Finance Excel Automation

Learn the skills this job asks for

See your skill gap for Data Analyst →

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You