Excel Analytics & Dashboards Specialist

Kennect; Hinoba-an; Hybrid; PHP 296,000 - 427,000; Full time

Benefits offered by this job

Comprehensive health insurance

Hybrid work culture

Mon-Fri schedule

Job summary

Kennect Technologies, a SaaS company, is seeking an MIS analyst in Mumbai to work with raw datasets, build Excel-based logics, and translate outputs into professional PowerPoint decks and Excel dashboards.

The role emphasizes strong analytical thinking, attention to detail, and the ability to communicate insights. Exposure to automating Excel workflows with Power Query, VBA, and Power BI is a plus.

Qualifications

• 1-2 years of analytics, reporting, or business analysis.
• Strong proficiency in Microsoft Excel (formulas, logic building, and automation).
• Ability to translate business requirements into structured Excel calculations.
• Experience creating professional PowerPoint presentations.
• Exposure to Power Query, VBA, or Power BI is a plus.
• Experience handling large datasets.

Responsibilities

• Work with raw datasets and understand client business requirements.
• Create and implement business logics using Excel formulas.
• Validate data outputs and ensure accuracy.
• Build summary tables, charts, and dashboards in Excel.
• Prepare clean and professional PPT decks with key insights.
• Ensure consistency between Excel outputs and presentations.
• Support logic discussions and incorporate feedback during client calls.
• Run automated Excel workflows by updating data and parameters.
• Maintain documentation for business logics and assumptions.

Skills

Excel

Data analysis

Presentation skills

Business analysis

Excel automation

Structured thinking

Ownership

Client-facing

Large datasets

Tools

Power BI

Power Query

VBA

Job description

Kennect Technologies, a SaaS company, is seeking an MIS analyst in Mumbai to work with raw datasets, build Excel-based logics, and translate outputs into professional PowerPoint decks and Excel dashboards.

The role emphasizes strong analytical thinking, attention to detail, and the ability to communicate insights. Exposure to automating Excel workflows with Power Query, VBA, and Power BI is a plus.