Senior Analyst

An MIS Executive is responsible for managing data, generating reports, and supporting decision-making by maintaining accurate information systems—mostly using tools like Excel, databases, and reporting software.

🔹 Key Responsibilities

• Collect, clean, and manage large sets of data
• Prepare daily / weekly / monthly reports for management
• Create dashboards using tools like Excel, Google Sheets, or BI tools
• Analyze data trends to support business decisions
• Maintain and update databases regularly
• Coordinate with different departments for data requirements
• Ensure data accuracy and consistency
• Automate reports using formulas, macros, or scripts

🔹 Required Skills

• Strong knowledge of Microsoft Excel (VLOOKUP, Pivot Tables, Macros)
• Basic understanding of SQL (optional but valuable)
• Familiarity with reporting tools like Power BI or Tableau
• Good analytical and problem-solving skills
• Attention to detail
• Basic communication skills 

Key Responsibilities

1. Data Management & Reporting

• Collect, clean, validate, and consolidate data from multiple internal and external sources.

• Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.

• Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.

2. Database & Data Accuracy Management

• Manage and regularly update internal databases, spreadsheets, and reporting systems.

• Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.

• Implement best practices for data validation, version control, and audit checks.

3. Data Analysis & Business Insights

• Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.

• Translate data findings into clear, actionable insights and recommendations to support strategic and operational decision-making.

4. Reporting Automation, System Recommendation & Implementation

• Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.

• Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.

• Proactively suggest new automation tools, system enhancements, or integrations to improve efficiency, accuracy, and scalability.

• Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.

• Continuously monitor and optimize automated systems in line with business growth and evolving data needs.

5. Cross-Functional Coordination & Support

• Collaborate with Sales, HR, Finance, Operations, and other departments to understand reporting and data requirements.

• Provide support for ad-hoc analysis, custom reports, and special data requests.

• Act as a data partner to department heads for decision support and performance tracking.

6. Documentation & Compliance

• Maintain complete and updated documentation for MIS processes, reports, data models, automation logic, and system changes.

• Ensure compliance with company data governance policies and applicable data protection standards.

________________________________________

System Development & Data Structuring Responsibilities

• Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.

• Review existing manual and digital data systems to identify operational gaps, risks, and improvement opportunities.

• Recommend structured data models, reporting formats, and storage solutions aligned with business requirements.

• Coordinate with department heads to define data structures, access levels, and reporting standards.

• Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP integrations) with minimal operational disruption.

• Design structured data formats and role-based access controls to ensure secure and organized data management.

• Train employees on newly implemented systems and provide post-implementation support.

• Monitor system performance, resolve issues, and continuously improve systems based on user feedback and organizational growth.

________________________________________

Qualifications & Experience

• Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.

• 3–5 years of experience in data analytics, reporting, or system automation roles.

• Strong analytical thinking, logical reasoning, and problem-solving abilities.

• High attention to detail with excellent organizational and documentation skills.

________________________________________

Technical Skills (Must Have)

• Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts

• SQL: Complex joins, subqueries, CTEs, performance tuning

• Python or R: Data cleaning, analysis, automation (Pandas, NumPy, etc.)

• BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)

• Data Warehousing Concepts: ETL processes, OLAP, Star/Snowflake schema

ROLES AND RESPONSIBILITIES:

Standardization and Governance:

• Establishing and maintaining project management standards, processes, and methodologies.
• Ensuring consistent application of project management policies and procedures.
• Implementing and managing project governance processes.

Resource Management:

• Facilitating the sharing of resources, tools, and methodologies across projects.
• Planning and allocating resources effectively.
• Managing resource capacity and forecasting future needs.

Communication and Reporting:

• Ensuring effective communication and information flow among project teams and stakeholders.
• Monitoring project progress and reporting on performance.
• Communicating strategic work progress, including risks and benefits.

Project Portfolio Management:

• Supporting strategic decision-making by aligning projects with organizational goals.
• Selecting and prioritizing projects based on business objectives.
• Managing project portfolios and ensuring efficient resource allocation across projects.

Process Improvement:

• Identifying and implementing industry best practices into workflows.
• Improving project management processes and methodologies.
• Optimizing project delivery and resource utilization.

Training and Support:

• Providing training and support to project managers and team members.
• Offering project management tools, best practices, and reporting templates.

Other Responsibilities:

• Managing documentation of project history for future reference.
• Coaching project teams on implementing project management steps.
• Analysing financial data and managing project costs.
• Interfacing with functional units (Domain, Delivery, Support, Devops, HR etc).
• Advising and supporting senior management.

IDEAL CANDIDATE:

• 3+ years of proven experience in Project Management roles with strong exposure to PMO processes, standards, and governance frameworks.
• Demonstrated ability to manage project status tracking, risk assessments, budgeting, variance analysis, and defect tracking across multiple projects.
• Proficient in Project Planning and Scheduling using tools like MS Project and Advanced Excel (e.g., Gantt charts, pivot tables, macros).
• Experienced in developing project dashboards, reports, and executive summaries for senior management and stakeholders.
• Active participant in Agile environments, attending and contributing to Scrum calls, sprint planning, and retrospectives.
• Holds a Bachelor’s degree in a relevant field (e.g., Engineering, Business, IT, etc.).
• Preferably familiar with Jira, Azure DevOps, and Power BI for tracking and visualization of project data.
• Exposure to working in product-based companies or fast-paced, innovation-driven environments is a strong advantage.

Task:

• Make documentations with formatting and in proper detailing
• Basic knowledge on Excel working with formula handling & reporting.
• Need to do multitasking, able to deliver tasks on time with expected quality
• Candidate should have thinking out of the box which supports the department to deliver good results in the pre-defined processes.
• Needs to be quick learner and able to come up with own thoughts on the tasks explained/shared to deliver good results
• Work closely with German team for operative processes/execution/deliverables.
• Flexible to adopt the changes in terms of processes/task handling.
• Knowledge on order fulfillment processes, managing support content on the website, inputs on support handling processes are added advantage.

We wish:

• At least bachelor in any stream or equivalent experience
• At least 1 year of experience in MS-Excel or similar office tools – is preferred
• Knowledge on VB script, macros is preferred
• Documentation skills
• Good Communication skills, at least speaking in English is required
• Good analytical skills
• Eager to know/experiment new technology and tools
• Web Browsing , ability to search quick results from web
• Experience on process documentation & presentation is preferred
• Ability to work independently with little or no daily supervision
• Out of box thinking and quick learner with willingness to learn new things

We Offer:

• Freedom to realise your own ideas & individual career & development opportunity.
• A motivating work environment, flat hierarchical structure, numerous company events which cannot be forgotten and fun at work place with flexibilities.
• Professional challenges and career development opportunities.

• Relevant work experience as an Accountant
• Graduation is a must. Female candidates preferred
• Excellent communication skills
• Willingness to work 6 days a week
• Good knowledge and work experience in Tally
• Excellent in time management and critical thinking
• Candidate who can multitask and with an eye for detail    

• Assess automation opportunities from a technical perspective and provide document solutions in the form of SDD
• Perform detailed estimations towards the finalized scope
• Design, develop, and test automation workflows
• Prepare solution presentation documents, present the solution and implementation plan to the CoE teams and project stakeholders
• Understand client’s business requirements and clearly document them in order for RPA developers to deploy the automation projects in an optimal manner
• Deploy RPA components including bots, robots, development tools, code repositories, and logging tools
• Create process and end-user documentation
• Collaborate with other development team members and guide junior developers to ensure proper implementation and integration of the solutions
• Perform peer review of developed components and test cases
• Support deployments or troubleshoot production issues; flexible to work in shifts when the demand arises
• Should be able to report project status to the stakeholders.

Skills Required

• UiPath
• UiPath Orchestrator
• Sound Knowledge of Microsoft VB, Excel, Macros
• Microsoft Visio, Freemind or equivalent tool
• Documentation and presentation using Microsoft Word and Powerpoint
• Understanding of CSS, HTML
• Experience in automating SAP flows in UiPath
• Excellent communication and presentation skills
• Template development in ABBYY OCR tool and integration if the solution in UiPath
• Knowledge of processes in the Manufacturing/Automotive domain
• Certified Advanced RPA Developer (UiARD)
• Knowledge of other RPA tools

• 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA 
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts 
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas 
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team 
• Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens 
• Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access 
• Must have strong database concepts and DB designing skills 
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates 
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# 

• VBA, SQL 

• Strong analytical and problem-solving skills 
• Excellent interpersonal and communication skills 
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance 
• Should be able to work independently 
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail 
• Effective time management skills 
• Customer Focus, Willing to learn and self- teach any new technology 
• Strong business and collaboration skills, and responsive to service needs and operational demands.

Job Description

Create intelligent dashboards and analytics for business team using advanced excel/access and powerpoint

Understand the sales and leadership metrics and create business reports with insights and recommendation

Maintain documentation related to reports/procedures and personal tasks

Collaborate with internal team for required inputs within deadline

Perform quality checks for data correctness and execute with fine attention to details

2-5 years of industry experience in MIS reports

Proficiency in advanced excel including Macros

High attention to details with ability to keep track of the assigned tasks

Willingness to work on flexible hours, ability to plan, estimate deadlines, prioritize workload

Skills required:

1. Advanced excel knowledge

2. Practical knowledge of Macros

3. Graduation is necessary

4. Min. experience of 2-3 years