Business Analyst

Overview

We are seeking an experienced Business Analyst to join our team on a contractual basis at our Bengaluru location. The ideal candidate will manage complex data tasks, prepare detailed MIS reports and presentations, and maintain high standards of data integrity and reporting accuracy.

Key Duties and Responsibilities

• Gather, consolidate, and cleanse data from various internal sources, resolving inconsistencies and duplicates.
• Validate datasets and ensure quality control for accurate reporting outcomes.
• Standardize data structures for consistent analytical use and maintain data integrity across repetitive reports.
• Analyze extensive data to uncover business insights, trends, and patterns that inform decision-making.
• Deliver timely MIS reports including weekly, monthly, quarterly, and ad hoc analyses and dashboards.
• Employ advanced Microsoft Excel techniques to build efficient workbooks incorporating formulas, pivot tables, power query, and automation.
• Create polished PowerPoint presentations translating raw data into meaningful visualizations suitable for executive reviews.
• Maintain documentation, standard operating procedures, and continuously enhance reporting methodologies and templates.
• Support internal stakeholders with reliable, clean data sets for various reporting needs.

Required Skills and Experience

• Advanced Excel proficiency including XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, Pivot Tables/Charts, Power Query, Power Pivot, conditional formatting, and data validation.
• Expertise in Microsoft PowerPoint to develop engaging, brand-consistent presentations and business review decks.
• Strong skills in data cleansing, validation, reconciliation, and MIS reporting.
• Familiarity with data visualization and maintaining reporting templates.
• Preferred knowledge of Power BI, SQL (basic to intermediate), VBA/Macros, Power Automate, and introductory Python for data manipulation.

Qualifications and Experience

• Bachelor's degree in Business Administration, Commerce, Statistics, Mathematics, Computer Science, Engineering, or closely related fields.
• Certifications in Excel, Power BI, or Data Analytics are beneficial.
• Minimum of five years’ professional experience in business analysis, data analytics, or MIS reporting roles, with exposure to handling large data sets and preparing executive reports.