Mis Data Analyst at PwC · Raipur · 3 - 9 years · ₹7L - ₹14L / yr · Profitable · Posted 17 Sep 2021
-
Make Business Trend Analysis based on past trends & current market conditions
-
Working on Effective Budgeting of the Company
-
Scheduling – Operational process improvisation.
-
To Provide Business data Analysis & Intelligence support including to the Management.
-
Identify Gaps, identify the problems, Analyse root cause and then suggest solutions which should increase the efficiency of the business process. Monthly Business transfer report.
-
Ensure proper maintenance of historic data which can be made easily available for any reference & Trend Study
-
Introduce / modify the business reports basis business dynamics and the requirement to develop effective reporting.
-
Pricing Strategies and Rate Management
-
Competition Mapping and Analysis
-
Planning Events and special Initiatives to drive incremental business apart from Regular advertising.
-
To keep a track on Rate Approval, Deal, Rate Contract, State centric Events & Initiatives
TECHNICAL SKILLS
-
MS-Office 365 (Excel, Word, PowerPoint).
-
Google Doc/Google Sheet/G Suite, Google Slides.
-
Advanced Excel & Power Pivot, Power BI.
-
Data Visualization on Excel
-

About PwC
About
Price Waterhouse and Cooper & Lybrand merged their businesses in 1998, resulting in the formation of the accounting firm known as Price Waterhouse Cooper. Not only is PricewaterhouseCoopers (PwC) the second largest company in the professional services industry, but we are also one of the Big Four accounting firms. In 2016, we were the sixth largest industry in the United States that was privately owned. The company has a workforce of over 223,000 people and provides services to customers in 756 locations throughout 157 countries.
PwC is a network of problem solvers that uses human creativity, knowledge, technology, and solutions to assist organizations in developing a culture of trust and achieving outcomes over the long term. Through the provision of quality assurance, tax, and advising services, we support individuals and businesses in the generation of the value that they want.
Similar jobs (5)
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
Experience Required: Minimum 8 Years
About the Role:
Key Responsibilities
- Design and manage organization-wide MIS reports, dashboards, and executive reports.
- Develop automated reporting solutions using Python, VBA Macros, Power Query, and Advanced Excel.
- Analyze large datasets and provide business insights to leadership.
Eligibility Criteria
- 5+ years of experience in Business Intelligence, MIS, Business Analytics, or Data Analytics.
- Strong analytical and logical thinking with the ability to understand business requirements and convert data into meaningful business insights.
- Experience in developing dashboards and management reports using any Business Intelligence tool (Power BI, Tableau, Zoho Analytics, etc.).
Apply Now:
About the Role
Work at the intersection of business and technology, supporting operations, data analysis, automation, and digital tools to improve efficiency and growth.
Responsibilities
- Support business operations using tech tools (Excel, CRM, dashboards)
- Analyze data and generate insights for decision-making
- Assist in automation workflows and process improvements
- Coordinate between tech and business teams
- Help in implementing digital solutions and tools
Skills Required
- Basic knowledge of Excel / Google Sheets
- Good analytical and problem-solving skills
- Understanding of business processes
- Interest in technology and automation
Details
- Duration: 3–6 months
- Mode: Remote
- Certificate + PPO based on performance
The Power BI Intern will assist the analytics team in using Microsoft Power BI to create interactive dashboards and reports. Working with actual datasets to assist well-informed business decision-making, this position provides practical exposure to data analysis, visualization, and business intelligence techniques.
Key Responsibilities
- Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
- Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
- Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
- Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
- Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
- Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
- Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
- Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
- Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.
Required Skills & Qualifications
- Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.
- Proven experience (1–3 years or as per company requirement) in MIS, data reporting/analysis, or similar role.
- Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
- Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
- Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
- Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
- Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.
BizTech Internship (Business + Technology)
Role Overview
Work at the intersection of business and technology, supporting operations, data analysis, automation, and digital tools to improve efficiency and growth.
Responsibilities
- Support business operations using tech tools (Excel, CRM, dashboards)
- Analyze data and generate insights for decision-making
- Assist in automation workflows and process improvements
- Coordinate between tech and business teams
- Help in implementing digital solutions and tools
Skills Required
- Basic knowledge of Excel / Google Sheets
- Good analytical and problem-solving skills
- Understanding of business processes
- Interest in technology and automation
Details
- Duration: 3–6 months
- Mode: Remote
- Certificate + PPO based on performance







