Job Description

Job Title:

Data Analyst - Advanced Excel, VBA & Macros

Location:

Kakkanad, Kochi

Employment Type:

Full-time

Job Summary:

We are looking for a detail-oriented and analytical

Data Analyst

with strong expertise in

Advanced Excel

,

VBA scripting

, and

Macros

. The ideal candidate will be responsible for data processing, report automation, dashboard creation, and providing actionable insights to support business decisions.

Key Responsibilities:

Handle large datasets efficiently using Excel functions and formulas (INDEX/MATCH, SUMIFS, PIVOT, etc.) Automate repetitive tasks using

Excel Macros and VBA programming

Design and maintain Excel-based dashboards and reports Clean, transform, and structure raw data for analysis Collaborate with internal teams to understand reporting needs and deliver custom solutions Ensure data integrity and accuracy across reports Generate weekly/monthly MIS reports, KPIs, and performance summaries Identify opportunities for process improvement and reporting automation

Required Skills:

Proficiency in

Advanced Excel

(Pivot Tables, Power Query, Array Formulas, etc.) Hands-on experience with

VBA

and

Macro development

Strong analytical and problem-solving skills Ability to work with large datasets and draw meaningful insights Basic knowledge of

SQL

or

Power BI

is a plus Good communication and interpersonal skills Ability to handle tight deadlines and multitask

Qualifications:

Bachelor's degree in Computer Science, Statistics, Mathematics, Commerce, or related field 0-3 years of relevant experience in data analysis or MIS reporting

Preferred:

Experience in pharmaceutical industries Exposure to

Power BI

,

Google Sheets scripting

, or

Python

is an advantage
Job Type: Full-time

Pay: ?20,000.00 - ?40,000.00 per month

Benefits:

Health insurance Provident Fund
Application Question(s):

Are you willing to relocate to Thodupuzha?
Experience:

VBA: 1 year (Required) Macros: 1 year (Required) Microsoft Excel: 1 year (Required)
Work Location: In person