MIS Analyst
1 week ago
Job Role: MIS Analyst
An MIS (Management Information Systems) Analyst plays a crucial role in the collection, analysis, and interpretation of data to support decision-making processes within an organization. Below is a detailed overview of the job role, focusing on the necessary Excel skills, formal functions, VBA, and Power BI capabilities.
Key Responsibilities
- Data Management and Analysis
- Collect and maintain large datasets from various sources.
- Clean and transform raw data into structured formats for analysis.
- Perform statistical analyses to identify trends and insights.
- Reporting and Visualization
- Develop and maintain regular reports and dashboards to provide actionable insights.
- Present data findings to stakeholders through comprehensive visualizations and summaries.
- Ensure the accuracy and reliability of all reports and dashboards.
- Automation and Optimization
- Utilize VBA to automate repetitive tasks and streamline data processing workflows.
- Optimize data processes for efficiency and accuracy.
- Stakeholder Collaboration
- Work closely with different departments to understand their data needs and provide customized solutions.
- Train and support end-users on using reports, dashboards, and other data tools.
Required Skills and Tools
- Excel Skills
- Advanced Functions and Formulas: Proficiency in using a wide range of Excel functions and formulas for data manipulation and analysis.
- PivotTables and PivotCharts: Expertise in creating and customizing PivotTables and PivotCharts for dynamic data summarization.
- Data Validation and Conditional Formatting: Ability to enforce data integrity and enhance data presentation through validation rules and conditional formatting.
- Power Query: Proficient in using Power Query for data transformation and connection to multiple data sources.
- VBA (Visual Basic for Applications)
- Macro Development: Create and manage macros to automate repetitive tasks.
- Custom Functions and Procedures: Develop custom functions and procedures to extend Excels capabilities.
- User Forms: Design and implement user forms for improved data entry and user interaction.
- Power BI
- Data Connectivity: Connect to various data sources, such as databases, Excel files, and cloud services.
- Data Modeling: Build and manage data models to support complex analyses.
- DAX (Data Analysis Expressions): Use DAX for creating measures, calculated columns, and complex data aggregations.
- Dashboard Design: Design interactive and visually appealing dashboards to present data insights.
- Power BI Service: Publish and share reports and dashboards through the Power BI service.
- Creating Monthly Billing Reports Using Excel and VBA
- Automate the generation of monthly Billing reports by pulling data from multiple sheets and summarizing it using VBA.
- Design a dashboard with visuals such as bar charts, line charts, and pie charts to represent sales performance.
Regards
Dhanush H
Human Resource
Teleradiology Solutions
-
MIS Analyst
1 week ago
Bengaluru, Karnataka, India NETSACH GLOBAL Full timeGreetings from Netsach - A Cyber Security Company.Job OverviewLooking for Mid-Level MIS Analyst role with 4 to 6 years of experience. This is an Onsite opportunity in Dubai.Job Title: MIS AnalystExp: 4-6yrsLocation: Dubai Interested candidates kindly share your updated resume at Qualifications and SkillsProven experience as an MIS Analyst in the banking...
-
MIS Analyst
1 week ago
Bengaluru, Karnataka, India Teleradiology Solutions Full timeJob Role: MIS AnalystAn MIS (Management Information Systems) Analyst plays a crucial role in the collection, analysis, and interpretation of data to support decision-making processes within an organization. Below is a detailed overview of the job role, focusing on the necessary Excel skills, formal functions, VBA, and Power BI capabilities.Key...
-
Senior MIS Analyst
1 week ago
Bengaluru, Karnataka, India Corporate Resources Full timeJob Description Design and implement Sales MIS operation to improve the following: Publish RBIS_India formal reporting for sales effectiveness and productivity Carry on the Sales Operation activities cordially partnering with Commercial team Role is to analyze the sales performance in respect to sales objectives, achieve organizations strengths and...
-
Associate, MIS Reporting
1 week ago
Bengaluru, Karnataka, India Hudson's Bay Company Full timeJob Title: MIS Reporting Analyst - RetailWelcome to our retail team! We are looking for a skilled MIS Reporting Analyst who can dive into data and extract insights for better business decisions.The ideal candidate will have a deep understanding of retail analytics tools like Looker, MicroStrategy, XRBI Store Force, and Tulip Clienteling systems.Key...
-
Manager MIS(Sales
1 week ago
Bengaluru, Karnataka, India Placement Partners Consulting Full timeHiring Manager - MIS (Sales and Marketing Analyst) with 7 to 10 years of experience in a similar role.Generating daily/weekly /annual business reportsAnnual/Monthly target vs achieved.Performance related MIS and data analyticsCoordinating with Sales /EMT/CRM and analyzing data to understand performance gaps/TrendsCost analysis on marketing spends and helping...
-
Technology Analyst
1 week ago
Bengaluru, Karnataka, India Infosys Full timeResponsibilities Should be having understanding on ITIL framework (IT reporting metrics/MIS) and create different reports as per the framework.Manage the team of analysts who support end user's IT tickets and act as SME for them. Attend to service requests and incidents, Analyze the root cause and provide solutions to meet the defined SLA target and avoid...
-
Business Analyst
1 week ago
Bengaluru, Karnataka, India Scimplify Full timeJob DescriptionBusiness Analyst at Scimplify Join Our Team at Scimplify We are hiring a Business Analyst to join our dynamic startup team If you are a motivated and detail-oriented professional looking to make a significant impact, this is the opportunity for youWhat You'll Do:Develop and maintain business-level MIS for internal teams.Contribute to...
-
Business Finance Analyst
1 week ago
Bengaluru, Karnataka, India Flipkart Full timeAbout the role: We are seeking a highly skilled Data Analyst or MIS Specialist to join our Business Finance team. The ideal candidate will possess strong analytical abilities and a solid understanding of financial data management. This role will primarily focus on managing data in Google Sheets or Excel to support various financial analysis and reporting...
-
Business Analyst
1 week ago
Bengaluru, Karnataka, India Scimplify Full timeJob Description Business Analyst at Scimplify Join Our Team at Scimplify We are hiring a Business Analyst to join our dynamic startup team If you are a motivated and detail-oriented professional looking to make a significant impact, this is the opportunity for you What You'll Do: Develop and maintain business-level MIS for internal teams. Contribute to...
-
Business Analyst
1 week ago
Bengaluru, Karnataka, India Scimplify Full timeJob DescriptionBusiness Analyst at ScimplifyWe are looking for a Business Analyst to be part of our vibrant team at Scimplify. If you're a detail-oriented and driven professional seeking to make a meaningful impact, this could be the perfect fit for you.What You'll Be Doing:Create and maintain business-level MIS for internal teams.Contribute to...
-
Financial Analyst
1 week ago
Bengaluru, Karnataka, India Angel and Genie Full timeWe are looking for a Finance and Accounts Analyst for an IT company in Bangalore. 1) Role: Senior Finance and Accounts Analyst Experience: 2 - 3 years Budget: 8LPA Location: Bangalore Preferred:: CA/CMA Inter Qualified Or MBA (Finance) Responsibilities: ● Oversee and manage daily program-wide accounting and finance functions including timely recording of...
-
Ops Analyst
1 week ago
Bengaluru, Karnataka, India PhonePe Full timePlease Note: This is FTC PositionJob Title:Operations Analyst- Life InsuranceLocation:Bengaluru - Work on all days from PhonePe Office - Salarpuria Softzone, BellandurJob Description:We are seeking an Operations Analyst to join our team who will play a pivotal role in ensuring the smooth flow of operational data and processes. This role entails extensive...
-
Resource Management Analyst
1 week ago
Bengaluru, Karnataka, India HighPoints Technologies India Pvt Ltd Full timeJob Description Template Requirement Resource Management Analyst Job Responsibility Job Responsibility Responsible for keeping resource management data (Demand and Supply) up to date in systems and providing MIS reporting to stakeholders. Coordination with project managers and operations for resource allocations. Take ownership in following up...
-
Ops Analyst
1 week ago
Bengaluru, Karnataka, India PhonePe Full timePlease Note: This is FTC PositionJob Title: Operations Analyst- Life InsuranceLocation: Bengaluru - Work on all days from PhonePe Office - Salarpuria Softzone, Bellandur Job Description:We are seeking an Operations Analyst to join our team who will play a pivotal role in ensuring the smooth flow of operational data and processes. This role entails extensive...
-
Management Information System Analysis Role
1 week ago
Bengaluru, Karnataka, India Seven Full timeJob Title: Management Information System AnalystLocation: Bangalore, Whitefield, Analyzing data to detect trends, patterns, and inconsistencies. Develop and maintain reports and dashboards utilizing Excel (VLOOKUP, pivot tables). Collaborate with teams to comprehend data needs and offer insights. Monitor Key Performance Indicators (KPIs) and provide regular...
-
Customer Service
2 months ago
Bengaluru, Karnataka, India NatWest Digital X Full timeJoin us as a Customer Service & Operations AnalystIn this customer centric role, you'll deliver successful outcomes for your customers by investigating their queries and understanding their needsYou'll be liaising with customers and businesses to accurately collect information in order to solve their queriesThis is an opportunity to be recognised as a...
-
Customer Service
2 months ago
Bengaluru, Karnataka, India NatWest Group Full timeJoin us as a Customer Service & Operations AnalystIn this customer centric role, you'll deliver successful outcomes for your customers by investigating their queries and understanding their needsYou'll be liaising with customers and businesses to accurately collect information in order to solve their queriesThis is an opportunity to be recognised as a...
-
QlikView BI Analyst
1 week ago
Bengaluru, Karnataka, India The Cigna Group Full timeBI Analyst - Operational Analytics - IM D&A Job Role: BI Analyst Location: Bangalore, India Business Intelligence/Analytics: Responsible for Testing and support of Operations Analytics. Demonstrates ability to interpret and refine customer requirements and effectively fulfils information needs using available business intelligence and analytical tools and...
-
Finance Analyst
1 month ago
Bengaluru, Karnataka, India ABB Full timeFinance Analyst - Accounts ReceivableTake your next career step at ABB with a global team that is energizing the transformation of society and industry to achieve a more productive, sustainable future.At ABB, we have the clear goal of driving diversity and inclusion across all dimensions: gender, LGBTQ+, abilities, ethnicity and generations. Together, we are...
-
Finance Analyst
3 weeks ago
Bengaluru, Karnataka, India ABB Full timeFinance Analyst - Accounts ReceivableTake your next career step at ABB with a global team that is energizing the transformation of society and industry to achieve a more productive, sustainable future.At ABB, we have the clear goal of driving diversity and inclusion across all dimensions: gender, LGBTQ+, abilities, ethnicity and generations. Together, we are...