Job
Description
Job description Key Responsibilities: Design and maintain regular and ad-hoc reports, dashboards, and trackers using Excel and Google Sheets. Create automated tools and solutions using Excel macros (VBA) to reduce manual effort and improve reporting efficiency. Develop Google Sheets-based dashboards using formulas, conditional formatting, pivot tables, charts, and Google Apps Script (if required). Collaborate with different departments to gather, validate, and consolidate data. Analyze large sets of data to identify trends, variances, and insights for business decision-making. Ensure timely delivery and accuracy of all MIS reports. Maintain version control and documentation for all reporting tools and automation scripts. Provide support and training to teams on using Excel and Google Sheets effectively. Key Skills & Competencies: Advanced Excel proficiency (PivotTables, VLOOKUP, INDEX-MATCH, Data Validation, Conditional Formatting, etc.) Excel Macros & VBA programming Strong Google Sheets knowledge (formulas, charts, filters, pivot tables, data validation) Basic knowledge of Google Apps Script is a plus Strong analytical and problem-solving abilities High attention to detail and data accuracy Good communication and interpersonal skills Ability to manage multiple tasks and meet deadlines Qualifications: Bachelor’s degree in Commerce, Business, IT, or a related field 1–3 years of experience in MIS, reporting, or data analysis Experience working with cloud-based tools like Google Workspace (Sheets, Docs, Drive) Knowledge of SQL or BI tools (Power BI, Tableau, etc.) is an added advantage Job Type: Full-time Pay: ₹20,000.00 - ₹30,000.00 per month Benefits: Cell phone reimbursement Commuter assistance Food provided Internet reimbursement Provident Fund Schedule: Day shift Supplemental Pay: Yearly bonus Application Question(s): Our location is Maheshtala Kolkata. Will it be convenient for you? Kindly share your exact location Work Location: In person
