Junior Data Analyst

MIS Executive / Junior Data Analyst

Strong analytical skills, attention to detail, and proficiency in MIS tools and data visualization software are must haves.

Key Responsibilities:

• Fetch and extract data

  from multiple sources including internal databases, CRMs, payment gateways, and external web platforms.

• Develop dashboards

  and

  trackers

  for performance metrics, and operations.

• Perform

  basic web scraping

  to collect publicly available data.

• Ensuring Data is pulled from correct and verified sources.

• Maintain and update internal databases to ensure data accuracy and integrity.

• Prepare reports for management decision-making.

• Automate reporting processes and enhance efficiency through scripting or advanced Excel techniques. (

  Macros, Power Query, Zapier, Make (Integromat

  )

• Support different teams by providing accurate, timely, and relevant data insights.

• Assist in audits and data reconciliation tasks.

Required Skills & Qualifications:

• Bachelors degree in Commerce, Business Administration, IT, or a related field.
• 2-4 years of experience in MIS or a similar role.
• Strong analytical and problem-solving skills.
• Good communication and coordination abilities.
• High level of accuracy and attention to detail.

Tools & Technologies:

• Microsoft Excel

  Advanced

  functions (VLOOKUP, HLOOKUP, Pivot Tables, Macros, Power Query)

• Google Sheets

  – Formulas, collaboration, and dashboarding
• Microsoft Power BI –

  Dashboards,

  Data Visualization, DAX
• Tableau –

  Reports

  and

  Visualization

  (optional)
• SQL – Basic queries for data extraction and reports
• Zapier / Make (Integromat) – Workflow automation (optional)

Preferred:

• Experience in automating reports and workflows.
• Basic knowledge of

  Python

  or

  R

  for data analysis (optional).
• Understanding of business operations and KPIs