MIS Executive

Marconix inc; Bengaluru; On-site; INR 134,000 - 167,000; Full time

Benefits offered by this job

Paid sick time

Job summary

Marconix inc in Bengaluru is hiring a Junior MIS Executive / Data Reporting Analyst to manage, track, and analyze daily operations data at our HSR Layout office. This entry‑level role emphasizes strong data management, numerical skills, and proficiency in spreadsheet tools like MS Excel.

The position focuses on generating daily to monthly sales MIS reports, data collection and sanitization, and creating dashboards in Excel and Google Sheets, with opportunities to leverage Power BI and SQL.

Qualifications

• Bachelor’s degree in Commerce, Computer Applications, Science, or Business Administration (B.Com, BCA, B.Sc, BBA).
• 1–2 years of experience; freshers with training or strong Excel knowledge welcome.
• Proficient in MS Excel (VLOOKUP/XLOOKUP, Pivot Tables, SUMIFS, Conditional Formatting, Data Validation).
• Knowledge of Google Sheets, Power BI, or SQL is a plus.
• Excellent attention to detail and ability to handle large data sets.

Responsibilities

• Generate and maintain daily, weekly, and monthly MIS reports.
• Collect, sanitize, and aggregate data from internal teams.
• Create and update operational trackers and dashboards using MS Excel and Google Sheets.
• Validate data and correct discrepancies or missing information.
• Coordinate with team leads to ensure timely submission of metrics.
• Automate recurring reporting formats with formulas to save time.
• Present reporting trends to senior management during reviews.

Skills

MS Excel

Google Sheets

Power BI

SQL

VLOOKUP

XLOOKUP

Pivot Tables

Data Validation

Dashboard development

Attention to detail

Education

Bachelor’s degree in Commerce, CPA, Science, or BBA

Tools

MS Excel

Google Sheets

Power BI

SQL

Job description

Full job description

• Job Title: Junior MIS Executive / Data Reporting Analyst (MS Excel)
• Location: HSR Layout, Bengaluru (Work from Office)
• Salary: ₹12,000 – ₹15,000 per month
• Job Type: Full-time, Permanent

About the Role

We are hiring a detail-oriented Junior MIS Executive to manage, track, and analyze our daily business operations data at our HSR Layout office. This role is ideal for entry-level candidates with strong data management skills, sharp numerical ability, and proficiency in spreadsheet tools like MS Excel.

Key Responsibilities

• Generate and maintain daily, weekly, and monthly sales MIS (Management Information System) reports.
• Collect, sanitize, and aggregate raw data from different internal departments.
• Create and update operational performance trackers and visual summary dashboards using MS Excel and Google Sheets.
• Perform data validation to identify and correct discrepancies, errors, or missing information.
• Coordinate with team leads to ensure timely submission of operational metrics and records.
• Automate recurring reporting formats using formulas to save processing time.
• Present routine reporting trends to senior management during operational reviews.

Requirements & Qualifications

• Education: Bachelor’s degree in Commerce, Computer Applications, Science, or Business Administration (B.Com, BCA, B.Sc, BBA).
• Experience: 1 to 2 years (Freshers with certified training or strong practical Excel knowledge are welcome to apply).
• Technical Skills: Mandatory practical knowledge of MS Excel (VLOOKUP/XLOOKUP, Pivot Tables, SUMIFS, COUNTIF, Conditional Formatting, Data Validation).
• Knowledge of Google Sheets, Power BI, or SQL will be a distinct advantage.
• Excellent attention to detail and ability to work accurately with large data sets.
• Basic written and verbal communication skills.

Pay

₹12,000.00 - ₹15,000.00 per month

Benefits

• Paid sick time

Ability to commute/relocate

• HSR Layout, Bengaluru, Karnataka: Reliably commute or planning to relocate before starting work (Required)

Education

• Bachelor’s (Required)

Experience

• Microsoft Excel: 1 year (Required)
• Advance Excel: 1 year (Required)
• VLOOKUP: 1 year (Required)
• XLOOKUP: 1 year (Required)
• Data Validation: 1 year (Required)
• Dashboard development: 1 year (Required)

Language

• Hindi (Preferred)

Work Location

In person