MIS & Business Systems Executive

Rawatsons Engineers Pvt. Ltd.; Kolkata District; On-site; INR 600,000 - 900,000; Full time

Benefits offered by this job

PF and ESI

Health insurance

Mobile phone plan reimbursement

Annual leave & holidays

Job summary

Rawatsons Engineers Pvt. Ltd. in Kolkata seeks an MIS & Business Systems Executive who can turn tendering, projects, billing and HR workflows into practical AppSheet apps and Looker Studio dashboards.

You will own the development of connected datasets and automations that link office, fabrication and site teams. Strong communication in English/Hindi/Bengali is valued. Monday–Friday work pattern applies; 2–5 years experience preferred, freshers welcome.

Qualifications

• Must be able to translate business processes into AppSheet apps and Looker Studio dashboards.
• Experience in connecting Google Workspace automations to business systems.
• Strong communication to work with cross-functional teams across office, production, and site.

Responsibilities

• Design, develop and maintain AppSheet apps with connected data, forms, views and automations.
• Build Looker Studio dashboards for tendering, project progress, billing, procurement and manpower.
• Collaborate with office, fabrication and site teams to map workflows and implement improvements.
• Organise data in Google Sheets with robust data validation and automation via Apps Script.
• Test, deploy and secure applications and dashboards; provide user training and support.

Skills

Multilingual communication

Ownership & accountability

Analytical thinking

Problem solving

Education

Bachelor's degree in engineering, computer applications, commerce or related field

Tools

AppSheet

Looker Studio

Google Apps Script

Job description

A hands-on role for someone who can turn real business processes into useful AppSheet applications, Looker Studio dashboards and connected Google Workspace systems.

Career opportunity

MIS & Business Systems Executive

Build and own the AppSheet applications, Looker Studio dashboards and Google Workspace automations that connect how our tendering, projects, billing, procurement, fabrication, site operations and HR teams work.

Core stack

• AppSheet
• Looker Studio
• Google Apps Script

Role at a glance

• Location Mani Square Mall, Kolkata
• Experience 2–5 years preferred · strong freshers welcome

What you will do

• Design, build and maintain practical AppSheet applications with connected records, forms, views, validations, actions, approvals and automations.
• Build and maintain Looker Studio dashboards for tendering, BOQ preparation, project progress, billing, collections, procurement, material movement, fabrication and manpower.
• Work directly with office, fabrication and site teams to understand workflows, identify gaps and convert requirements into usable business systems.
• Organise reliable, connected datasets in Google Sheets and reduce repetitive work with Apps Script and AppSheet automation.
• Test applications, dashboard calculations and automations; manage appropriate access; troubleshoot issues; and keep systems reliable and secure.
• Document workflows, train users, support day-to-day adoption and recommend practical improvements to leadership.

What you should bring

• Hands-on AppSheet development: tables and relationships, expressions, forms, views, actions, validations, automations and user access.
• Hands-on Looker Studio development: data sources, dashboards, metrics, calculated fields, filters and data-quality checks.
• Advanced Google Sheets skills, including QUERY, lookup functions, pivot tables, data validation and connected datasets.
• Working knowledge of Google Apps Script, or strong programming aptitude supported by working automation examples.
• Comfort using AI tools such as ChatGPT, Claude or Copilot to research, write, debug and test solutions—and the ability to understand and maintain the result.
• Clear communication in English, Hindi and Bengali, with the patience and emotional intelligence to work across office, factory and site teams.
• A bachelor’s degree in engineering, computer applications, commerce or a related field.
• Ownership, analytical thinking, curiosity and close attention to data and operational detail.

Useful, but not essential

• Experience with APIs, SQL or databases, CRM systems such as Salesforce, accounting-software integrations or WhatsApp Business integrations.
• Exposure to construction, infrastructure, manufacturing or another project-based business.
• Advanced Excel skills in addition to the essential AppSheet and Looker Studio capability.

Working hours

• Monday–Friday: 10:30 a.m.–7:00 p.m.
• Saturday: 10:30 a.m.–4:00 p.m.
• Sunday: Off

04 · The offer

• PF and ESI, as applicable, health insurance and mobile phone plan reimbursement
• 14 holidays and 26 days of annual leave, with leave encashment as per company policy
• Direct exposure to leadership and the visible business impact of the systems you build
• Learning, professional growth and increasing responsibility in a supportive, merit-focused workplace