Data Analytics and MIS Executive (VLOOKUP, pivot tables, macros) (Gurugram)

Data Analytics and MIS Executive (VLOOKUP, pivot tables, macros) (Gurugram)

19 Sep
|
CAREERBLOC ~
|
Gurugram

19 Sep

CAREERBLOC ~

Gurugram

**BUDGET: 4-5LPA

LOCATION: Gurugram Haryana

EXPERIENCE: 3-5 years

About the Role

We are looking for an analytical and detail-oriented Data Analytics and MIS Executive to manage reporting systems, generate actionable business insights, and support data-driven decision-making across departments.

Key Responsibilities

- Design, maintain, and update MIS reports and dashboards for sales, production, and operations
- Collect, consolidate, and analyze data from multiple departments to generate accurate reports
- Develop and automate reports using Excel (advanced formulas, pivot tables, macros) and other Bl tools
- Track key business metrics and KPls, and present insights to management for decision-making
- Identify trends, patterns, and anomalies in data to support business planning
- Coordinate with cross-functional teams to gather data requirements and ensure data accuracy
- Prepare daily, weekly, and monthly MIS reports within defined timelines
- Maintain data integrity and confidentiality across all reporting systems
- Support management with ad-hoc data analysis and reports as required

Required Skills & Qualifications
- Graduate/Postgraduate in any discipline (preference for Statistics, Commerce, or IT background)
- 3-5 years of relevant experience in MIS/Data Analytics, preferably in the solar or renewable energy
- Advanced proficiency in MS Excel (VLOOKUP, pivot tables, macros) and PowerPoint
- Working knowledge of Power BI, Tableau, or similar data visualization tools preferred
- Basic knowledge of SQL for data extraction and querying is an advantage
- Strong analytical, problem-solving,



and report-writing skills
- High attention to detail and accuracy in data handling
- Ability to manage multiple reports and meet strict deadlines

Company Description CareerBloc is a recruitment and marketing partner that connects talent with organizations while helping businesses grow through result-driven marketing solutions. The company provides end-to-end hiring, candidate sourcing, and workforce services, acting as a trusted mediator between candidates and clients. In parallel, CareerBloc offers strategic marketing services, including social media growth, lead generation, SEO, and brand strategy, to boost visibility and measurable business performance.

With a proven track record in placing top talent and strengthening brand presence, CareerBloc is a one-stop solution for organizations looking to scale both their teams and their market impact. The company focuses on building futures and fueling growth for professionals and business es alike.

Role Description This is a full-time, in office Staff role based in Gurugram. The staff member will support daily operations across recruitment and marketing functions, including coordinating candidate sourcing activities, maintaining records,



and assisting with interview scheduling and communication.

The role may involve collaborating with recruitment consultants, helping prepare job postings, and ensuring timely follow-up with candidates and clients. On the marketing side, the staff member may assist in executing campaigns, gathering data for reports, and supporting social media and outreach efforts. The position requires close collaboration with internal teams, adherence to established processes, and a proactive approach to administrative and operational tasks.

Qualifications

- Strong organizational, time management, and administrative skills to handle multiple tasks and maintain accurate records.
- Effective communication and interpersonal skills for interacting with candidates, clients, and internal team members.
- Basic understanding of recruitment processes, including candidate sourcing, screening, and interview coordination.
- Comfort with using office productivity tools (e.g., spreadsheets, documents, email, and messaging platforms) and learning new systems quickly.
- Attention to detail and problem-solving skills with the ability to follow established procedures and meet deadlines.
- Ability to work on-site in Gurugram, collaborate in a team environment, and adapt to evolving business needs.
- Prior experience in recruitment support, HR operations, or office administration is an advantage.
- Bachelor’s degree or equivalent education/experience in business, administration, human resources, or a related field is preferred.**

📌 Data Analytics and MIS Executive (VLOOKUP, pivot tables, macros) (Gurugram)
🏢 CAREERBLOC ~
📍 Gurugram

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data analytics and mis executive (vlookup, pivot tables, macros) (gurugram) / gurugram

Subscribe to this job alert:

Get the latest job offers by email for: data analytics and mis executive (vlookup, pivot tables, macros) (gurugram) / gurugram