MIS Analyst

AVASO Technology Solutions

5 years

0 Lacs

Sahibzada Ajit Singh Nagar Punjab India

Posted:5 days ago| Platform:

Apply

Skills Required

excel macros vba data visualization ai reporting efficiency design automate power query pivot support scripting training dashboarding statistics mathematics analytics dax relational zapier workflow presentation communication management tableau sql python certification ml

Work Mode

On-site

Job Type

Full Time

Job Description

Job description:

Job Title:

Role Overview:

MIS Analyst

Key Responsibilities:

Design, build, and automate
complex dashboards
using
Excel (Power Query, Pivot Tables, VBA Macros)
and other visualization tools.
Develop, maintain, and enhance
automated MIS reports
, ensuring data accuracy and timely delivery.
Work closely with stakeholders to
translate business needs into data-driven insights
and decision-support tools.
Perform
data wrangling and transformation
using Power Query, advanced formulas, and scripting where needed.
Build and maintain
data models
to support analytical solutions and dashboards.
Conduct
in-depth business and data analysis
to identify trends, patterns, and business opportunities.
Integrate AI-powered tools or platforms (e.g., ChatGPT, Power Automate, Copilot, etc.) to enhance reporting and process automation.
Collaborate with cross-functional teams to understand data requirements and deliver high-impact analytical solutions.
Conduct training sessions or workshops on advanced Excel, dashboarding, and analytical techniques when needed.

Required Skills & Qualifications:

Education:
Graduate/Postgraduate in Computer Science, Statistics, Mathematics, Commerce, or a related field.
Experience:
5+ years in MIS/Data Analytics roles with proven Level 3 capabilities.

Technical Skills:

Expert-level proficiency in Microsoft Excel
, including:

Advanced formulas and functions
Power Query and Power Pivot
VBA/Macros automation

Strong hands-on experience in
building interactive dashboards
and reports.
Proficiency in
data wrangling
and data cleansing techniques.
Solid understanding of
data modelling
, DAX (if working with Power BI), and relational databases.
Strong business acumen with the ability to translate data into insights.
Exposure to or working knowledge of
AI tools
such as:

Microsoft Copilot
ChatGPT for Excel/analytics tasks
Power Automate or Zapier for workflow automation

Soft Skills:

Excellent
presentation and storytelling
skills using data.
Strong communication and stakeholder management abilities.
Self-motivated, detail-oriented, and problem-solving mindset.

Preferred (Nice to Have):

Knowledge of Power BI, Tableau, or other visualization tools.
Familiarity with SQL or Python for data analysis.
Certification in Advanced Excel, Data Analytics, or AI/ML tools.

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.