Data Analyst

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