MIS - Google Scripting - Pitampura

3 days ago

Delhi NCR, India The Global Zone Full time ₹ 1,04,000 - ₹ 1,30,878 per year

Design & implement MIS for core functions (sales, operations, inventory, finance)with clear data flows and governance.

• Build dashboards & reports (daily/weekly/monthly) using Advanced Excel and Google Sheets; standardize templates and automate refreshes.

• Automate workflows with Google Apps Script (custom functions, triggers,

email/slack alerts, form-handling, data cleaning, API pulls where applicable).

• Ensure data quality: validation rules, de-duplication, audit logs, version control,

and documentation.

• Drive analysis: variance, trend, and cohort analysis; create actionable insights andrecommendations for stakeholders.

• Stakeholder collaboration: gather requirements, translate into technical specs,

deliver on timelines, and train end-users.

• SOPs & documentation: maintain data dictionaries, process notes, and user guides for all MIS assets.

• Ad-hoc reporting for leadership with quick turnaround and high accuracy.

Must-Have Skills

• Advanced Excel: Pivot Tables, Power Query / Get & Transform,

XLOOKUP/INDEX-MATCH, dynamic arrays, nested formulas, data validation,

conditional formatting, charts.

• Google Sheets: QUERY, ARRAYFORMULA, IMPORTRANGE, named functions,

connected sheets; strong understanding of sheet architecture and performance.

• Google Apps Script & JavaScript: building automations, custom

menus, triggers (time-based/on-edit), REST API calls, error handling, and code

organization.


• Mathematics background preferred: comfort with statistics, ratios, growth/variance

math, forecasting basics.

• Data handling: cleaning, normalization, reconciliations, large dataset performance

techniques.

• Communication & documentation: clear written specs and stakeholder updates.

Nice to Have

• Basics of SQL (SELECT/JOIN/GROUP BY) for data extraction.

• Experience integrating Sheets/Excel with external tools (CRMs/ERPs) via APIs.

• Exposure to BI tools (e.g., Data Studio/Looker Studio, Power BI).

• Knowledge of inventory/operations metrics in manufacturing/solar domains.

Qualifications

• Bachelors degree in Mathematics/Statistics/Engineering/Computer

Science/Commerce (or equivalent).

• Prior MIS or data analysis experience is a plus; strong freshers with the above

skills are welcome to apply.

Key Performance Indicators (KPIs)

• On-time delivery of scheduled reports (D/W/M) with ~100% accuracy.

• Reduction in manual reporting time via automation (target improvement %).

• Data quality: error rate, reconciliation success, and stakeholder satisfaction

scores.

• Adoption of dashboards/SOPs by business teams.

Reporting & Collaboration

• Reports to: Operations/Finance Lead (or as designated).

• Works closely with: Sales, Procurement, Projects/Operations, and Finance teams

If Interested kindly share your resume with your update details

Current Ctc

Expected Ctc

notice period

  • Mis Executive Google App Script

    7 days ago

    Delhi, Delhi, India Vibgyor International Pvt. Ltd Full time

    **Designation**:MIS cum Google App Script** **Location: Rajendra Place** **Salary Package: 20k - 25k** **About Us**: **Skills Required**: - Preparation of MIS reports from the data available on sheets. - Data Management Executive (DME) who is good with EXCEL, Google Sheets - He should have good knowledge of different Excel Formulas - He should have...

  • Mis Executive

    2 weeks ago

    Pitampura, Delhi, Delhi, India Saya Stationeries Private Limited Full time

    **As an MIS (Management Information Systems) Executive, you are required to work with Data**: **Reporting to MD** - **This role is a role for professionals who are good with numbers**: - **Knowledge of Excel (vlookup, hlookup, pivot table, charts) is a must**: - **Must be able to create reports using data**: - **Must have experience of working on google...

  • Mis Executive

    2 weeks ago

    Delhi, NCR, India Career Kendra Full time ₹ 5,00,000 - ₹ 10,00,000 per year

    Skills-MIS Exp Exp Good Expertise in Excel, Vlookup,Hlookup,Pivot table,Formulas,Advance excel formulas,data Analsyt ,Google App Script mustwork from officeimmediate joiner

  • Sales and Mis Coordinator

    2 weeks ago

    Delhi, India Saya Stationeries Private Limited Full time

    Require MIS cum Coordinator Experience of using formulas like vlookup etc and pivot tables in MS excel and google sheets, Communication skills required. Job Location: Kohat Enclave (Pitampura, Near NSP) Timings: 10AM to 7PM Package: 18-22k per month **Salary**: ₹18,000.00 - ₹22,000.00 per month **Benefits**: - Cell phone reimbursement - Health...

  • Performance Marketing Executive

    3 days ago

    Pitampura, Delhi, Delhi, India Digifuels Pitampura Full time

    Company - Digifuels Location - Pitampura, Delhi (on site job) Working hours - 10 am - 6:30 pm Working Days - 6 (Sunday fixed off) Position - 1 Designation: Digital Marketing Manager (Meta and Google both must) Experience: 1 - 2 years **Salary**: upto 30000 (depending on interview) Joining: Immediate **Responsibilities**: - Understanding the needs...

  • SEO Executive

    7 days ago

    Delhi, Delhi, India Alpha Pro Services Full time

    We are looking for **SEO Executive - Pitampura (WhatsApp: 8595624304)** **Job Description: - ** **Roles & Responsibility** - Hands on experience of all off page activities. - Carrying out keyword research using tools such as Semrush or ahrefs. - Performing On Page & Technical SEO Audit for the website. - Tracking metrics such as organic traffic,...

  • Mis Executive

    1 week ago

    Pitampura, Delhi, Delhi, India TOXMO ELECTRIC MOTORS PVT.LTD Full time

    company name : Rocklight address : pitampura delhi **Responsibilities of MIS Executives**: - Hire a Data Management Executive (DME) who is good with EXCEL❖ He should have good knowledge of different Excel Formulas❖ He should have knowledge of Macros, if possible❖ Thorough Knowledge of Excel or Google Sheets❖ Should know Pivot Tables❖ A background...

  • Mis Executive

    1 week ago

    Rohini, Delhi, Delhi, India Uddo INC Full time

    **Position**: MIS Executive **Location**: Rohini sec-24 We are hiring an **MIS Executive** with strong knowledge of **Advanced Excel, Google Sheets, Google App Script/JavaScript, basic coding, API integration, and Google Website Builder**. The role involves creating and automating reports, managing data dashboards, and supporting business decisions with...

  • Mis Coordinator

    1 week ago

    Pitampura, Delhi, Delhi, India ROCKLIGHT Full time

    **Job Title**: MIS Coordinator **Reports to**: Operations Manager **Location**: [Pitampura, n.s.p ) **Employment Type**: Full-time **Job Summary**: The MIS Coordinator is responsible for managing, maintaining, and enhancing the organization's information systems. This role ensures timely and accurate data reporting, supports decision-making through data...

  • Mis Executive

    1 week ago

    Delhi, Delhi, India Alankrita enterprises Full time

    We have urgent hiring for our client. Industry type - FMCG Job location - NSP - Google Scripting ❖ Macros, Loops, Function &User Forms, Pivot table, sheet linked, input box ❖ Google Drive Formula - Query, Filter, import data, import range, Sheet linkedetc. ❖ Google Sheet | Google Form | Google Form Script | Google Sheet Script |Advanced Excel | Macro...