Company Overview : HairOriginals is a renowned manufacturer and leading brand specializing in 100% human hair extensions in India. With a commitment to quality, innovation, and customer satisfaction, we have established ourselves as a trusted name in the industry. Our products are known for their premium quality, versatility, and superior craftsmanship, catering to a diverse clientele both domestically and internationally.
Role Overview :
We are looking for a highly skilled MIS Executive with strong expertise in Excel, Google Sheets, and automation of reports / dashboards . The candidate will be responsible for building, maintaining, and optimizing critical MIS reports where multiple sheets are interlinked, and by pasting a single data dump, all dashboards and reports update automatically.
This role requires excellent problem-solving skills, attention to detail, and the ability to work closely with business teams to ensure timely, accurate, and actionable reporting.
Key Responsibilities :
- Develop and maintain MIS dashboards and reports in Google Sheets & Excel.
- Design automated reporting systems where one data dump refreshes multiple reports seamlessly.
- Build and optimize reports using advanced formulas, pivot tables, macros, and query functions .
- Create linked and interdependent Google Sheets / Excel models for sales, operations, and business performance tracking.
- Ensure accuracy, consistency, and reliability of data across multiple reports.
- Collaborate with business teams to understand reporting requirements and deliver actionable insights.
- Maintain data hygiene and ensure timely availability of MIS for decision-making.
- Identify opportunities to automate repetitive reporting tasks and improve efficiency.
Required Skills & Expertise :
Advanced Excel Skills :Complex formulas (INDEX, MATCH, VLOOKUP, XLOOKUP, IF, Nested IFs, SUMIFS, COUNTIFS, etc.)Pivot Tables & Pivot ChartsData validation, conditional formatting, error handlingMacros / VBA (for automation in Excel)Google Sheets Expertise :Query function, Array formulas, ImportRange, IMPORTRANGE linking, Filter, Unique, Split, Text functionsScript / Apps Script knowledge (added advantage for automation)Building dashboards with linked multiple sheetsReporting & Analysis :Ability to design reports that provide actionable business insightsStrong eye for detail and accuracyAbility to manage large datasets efficientlyOther Skills :Strong problem-solving & analytical thinkingGood communication skills to work with cross-functional teamsAbility to deliver under tight timelinesQualifications :
Graduate in Commerce, Statistics, Economics, Computer Science, or related fields .2–5 years of experience in MIS, reporting, or data analysis roles.Prior experience in building automated dashboards in Google Sheets / Excel is a must.Knowledge of SQL / BI tools (like Power BI, Tableau, Looker Studio) will be a plus but not mandatory.Job Location & Work Mode'
On site – 6 days a weekYou can apply by sharing resume at [HIDDEN TEXT]
Skills Required
Conditional Formatting, Pivot Tables, Data Validation, array formulas , reporting analysis, filter , Pivot Charts