Crystal Works

MIS Executive / Analyst

Crystal Works
Saket, Delhi-NCR
₹20,000 - ₹30,000 monthly

Fixed

₹20,000 - ₹30,000

Earning Potential

₹30,000

Work from OfficeWork from Office
Full TimeFull Time
Min. 3 yearsMin. 3 years
Good (Intermediate / Advanced) EnglishGood (Intermediate / Advanced) English

Job highlights

Urgently hiring

Urgently hiring

18 applicants

18 applicants

Benefits include:  Internet Allowance, Laptop

Benefits include: Internet Allowance, Laptop

Job Description

Job Description MIS- Executive / Sr Exexutive - Tender / GEM for Crystal Works Sainik Farms Near Saket New Delhi 110062

AGe :- 28 + Yrs


We are looking for a detail-oriented and analytical Data who is proficient in Tender Data , API INTEGRATION , Who knows how to pulled data from GEM Portal to Google Sheets.... Google Sheets, MIS reporting, dashboards, Performance Management Systems (PMS), KPI tracking, and AI-based automation.

The candidate will be responsible for maintaining accurate business data, preparing daily/weekly/monthly MIS reports, developing management dashboards, monitoring employee and business KPIs, and automating repetitive reporting processes using Google Workspace and AI tools.

  • Key Responsibilities1. MIS & Reporting Prepare daily, weekly, and monthly MIS reports.
  • Maintain accurate and updated business databases.
  • Track sales, operations, attendance, productivity, recruitment, and other business performance metrics.
  • Identify data errors, gaps, and inconsistencies.
  • Provide timely reports to management for decision-making.
  • 2. Google Sheets & DashboardCreate advanced Google Sheets for MIS and business reporting.
  • Develop interactive dashboards using formulas, Pivot Tables, charts, filters, and data validation.
  • Maintain real-time management dashboards.
  • Use functions such as QUERY, FILTER, VLOOKUP/XLOOKUP, INDEX-MATCH, ARRAYFORMULA, IMPORTRANGE, IF/IFS, SUMIFS and COUNTIFS.
  • Consolidate data from multiple Google Sheets and sources.
  • 3. PMS & KPI ManagementDevelop and maintain Performance Management System (PMS) trackers.
  • Define and monitor employee KPIs/KRAs in coordination with management.
  • Prepare employee performance reports and scorecards.
  • Track targets vs. actual performance.
  • Generate monthly performance summaries.
  • Highlight underperformance, high performers, pending activities, and critical gaps.
  • 4. AI & AutomationUse AI tools such as ChatGPT and other AI platforms to improve reporting and data analysis.
  • Automate repetitive MIS activities wherever possible.
  • Develop automated reporting workflows using Google Apps Script, AI tools, formulas, and integrations.
  • Automate dashboard updates, alerts, reminders, data cleaning, and report generation.
  • Explore AI-based methods for forecasting, trend analysis, anomaly detection, and management insights.
  • 5. Data AnalysisAnalyze business data and identify trends and performance gaps.
  • Prepare management summaries and actionable insights.
  • Support management with data-driven recommendations.
  • Track historical performance and prepare comparative analysis.
  • Required SkillsStrong knowledge of Google Sheets / MS Excel.
  • Excellent knowledge of MIS reporting and dashboard creation.
  • Good understanding of PMS, KPI and KRA tracking.
  • Knowledge of Google Workspace.
  • Basic to advanced knowledge of Google Apps Script will be an advantage.
  • Practical knowledge of AI tools and AI automation.
  • Strong analytical and problem-solving skills.
  • Good attention to detail and data accuracy.
  • Ability to manage multiple reports and deadlines.
  • Preferred Qualifications Graduate in B.Com, BBA, MBA, Computer Applications, Statistics, Data Analytics, or a related field.
  • 3–8 years of experience in Tender / GEM - Data Analyst ,MIS, reporting, data analysis, or operations reporting.
  • Candidates with hands-on experience in Google Sheets Dashboard + PMS + AI Automation will be preferred.


Job role

Work location
Work location172, Cariappa Marg, Mehrauli - Badarpur Rd, Block J, Saket, New Delhi, Delhi 110062, India Saket, Delhi-NCR
Department
DepartmentFinance & Accounting
Role / Category
Role / CategoryMIS Operations
Employment type
Employment typeFull Time
Shift
ShiftDay Shift

Job requirements

Experience
ExperienceMin. 3 years
Education
EducationGraduate
English level
English levelGood (Intermediate / Advanced) English
Age limit
Age limit27 - 60 years
Gender
GenderAny gender

About company

Name
NameCrystal Works
Address
Address172, Cariappa Marg, Mehrauli - Badarpur Rd, Block J, Saket, New Delhi, Delhi 110062, India Saket, Delhi-NCR
Job posted by Crystal Works

Similar jobs you can apply for

Accounts / Finance

Accountant

Tvamevaa Consumer Products LLP
Surajpur Site V, Delhi-NCR
₹25,000 - ₹35,000
Work from Office
Full Time
Min. 3 years
Good (Intermediate / Advanced) English
Parama & Co.

Accountant

Parama & Co.
Connaught Place, New Delhi
₹15,000 - ₹30,000
Work from Office
Full Time
Min. 2 years
Basic English
Career Kendra

MIS Executive

Career Kendra
Sector 55, Gurgaon/Gurugram
₹25,000 - ₹30,000
Work from Office
Full Time
Min. 2 years
Basic English

Analytical Chemist

Aadii Anaylitical Services Private Limited
Sector 49, Noida
₹12,000 - ₹20,000
Work from Office
Full Time
Min. 2 years
Basic English
Grg Business Solutions Private Limited

Housekeeper

Grg Business Solutions Private Limited
Ghaziabad
₹8,000 - ₹11,000
Work from Office
Full Time
Night Shift
Min. 1 year
No English Required

Cashier

Gujrat Bakery
Tihar Village, New Delhi
₹14,000 - ₹16,000
Work from Office
Full Time
Any experience
Basic English

You can expect a minimum salary of 20,000 INR and can go up to 30,000 INR. The salary offered will depend on your skills, experience and performance in the interview.

The candidate should have completed Graduate degree and people who have 3 to 31 years are eligible to apply for this job. You can apply for more jobs in Delhi-NCR to get hired quickly.

The candidate should have Good (Intermediate / Advanced) English skills and sound communication skills for this job.

Both Male and Female candidates can apply for this job.

No, it's not a work from home job and can't be done online. You can explore and apply for other work from home jobs in Delhi-NCR at apna.

No work-related deposit needs to be made during your employment with the company.

Go to the apna app and apply for this job. Click on the apply button and call HR directly to schedule your interview.

The last date to apply for this job is 3 Dec 2026. For more details, download apna app and find Full Time jobs in Delhi-NCR . Through apna, you can find jobs in 64 cities across India. Join NOW!