Management Information System Executive

We are Hiring – MIS ExecutiveJob Profile – MIS ExecutiveDetails

Company:
Transmission Line Products

Location:
Office – Kolkata, West Bengal, India

Factory – Sankrail Industrial Park

Industry:
Railway Infrastructure Manufacturing (overhead electrification fittings)

Employment Type:
      Full-time

Openings:
One (1)

Job Summary

The MIS Executive will be responsible for creating and managing sheets that provide correct data to the business quickly. The Executive will also support the business in analysing the data and in decision-making. The role involves working with Excel and Google Sheets. The ideal candidate will know how to use various formulas, know how to create pivot tables, and know how to extend and automate spreadsheet functionality using Apps Script/JavaScript. The ideal candidate will also have strong analytical skills, problem-solving abilities, and expertise in data manipulation and reporting.

Key Responsibilities1.     Data Management and Reporting

· Collect, compile, and analyse data from multiple sources.

· Generate and maintain daily/weekly/monthly reports using Excel, Google Sheets, and other BI tools.

· Create pivot tables, charts, and dashboards for business insights.

2.     Automation & Advanced Tools

· Develop and maintain Excel macros (VBA) and Google Apps Script/JavaScript to automate repetitive tasks and flow data seamlessly in an error-free way to various sheets.

· Build custom functions and scripts to enhance data processing efficiency.

· Troubleshoot and optimize existing automation workflows.

1. Database & System Integration

· Extract and transform data from databases (SQL knowledge is a plus).

· Integrate data between different platforms using APIs or scripting.

4.     Data Validation & Accuracy

· Ensure data integrity by performing regular checks and validations.

· Identify and resolve discrepancies in reports.

5.     Collaboration & Support

· Work with cross-functional teams to understand reporting requirements.

· Train end-users on dashboards, reports, and automation tools.

Qualifications & SkillsEducation

Bachelor's degree in computer science, IT, Business Analytics, or related field.

Experience

· years of experience in MIS, Data Analysis, or a similar role.

· Prior experience in automation using VBA/Apps Script/JavaScript is a must.

Technical Skills

· Advanced proficiency in Microsoft Excel (Formulas, Pivot Tables, VBA Macros, etc.)

· Expertise in Google Sheets (QUERY, ARRAYFORMULA, IMPORTRANGE, etc.)

· Hands-on experience with Google App Script/JavaScript for automation

· Knowledge of SQL & database management (preferred)

· Familiarity with BI tools like Power BI, Tableau (optional)

Analytical Skills

· Strong problem-solving and logical reasoning abilities

· Ability to interpret data trends and generate actionable insights

Soft Skills

· Excellent communication and collaboration skills

· Detail-oriented with a focus on accuracy

· Ability to work under tight deadlines

· Problem-solving, multitasking, and adaptability in a dynamic environment.

Preferred Certifications

· Google Workspace Developer Certification

· Microsoft Excel Expert Certification

· Data Analytics/Business Intelligence Certifications

Reporting & Work Dynamics

Work Mode:
On-site at the factory in Sankrail. Will go to the Kolkata office as and when required. May require occasional extended hours during critical reporting periods.

Key to Success

· Technical knowledge

· Ability to learn new skills

· Thrives in a high-pressure environment with multiple moving parts

· Can bring order to disorder

Why Join Us?

· Opportunity to work closely with leadership in a niche sector critical to Indian Railways.

· Exposure to high-impact projects that contribute to nation-building

· Competitive salary, growth prospects, and a structured work environment.

Application Process

Interested candidates may fill this form for Face-to Face Interview and share your CV on WhatsApp number

Kindly fill out this form to schedule your interview