MIS Assistant Manager- Provider Partnerships

We are seeking a detail-oriented and analytical Assistant Manager with expertise in Advanced Excel and Google Sheets. The ideal candidate will be responsible for data management, reporting, and streamlining processes, leveraging advanced spreadsheet tools and techniques to drive efficiency and insights for decision-making.

Key Responsibilities:

Data Management and Analysis:

• Collect, organize, and analyze large datasets using Advanced Excel and Google Sheets.
• Build and maintain dashboards for real-time reporting and performance tracking

• Advanced Excel Expertise:
• Develop and manage complex Excel models, including pivot tables, macros, Power Query, and VBA scripting.
• Automate repetitive tasks and streamline processes through advanced Excel functionalities.

• Google Sheets Expertise:
• Create dynamic and collaborative Google Sheets for data tracking and sharing.
• Leverage advanced Google Sheets functions, including QUERY, IMPORTRANGE, ARRAYFORMULA, and scripting through Google Apps Script.
• Integrate Google Sheets with automation using App script.

• Reporting and Insights:
• Prepare periodic and ad-hoc reports using both Excel and Google Sheets.
• Analyze data to generate actionable insights and recommendations for management

• Process Optimization:
• Identify inefficiencies in current workflows and design solutions using Excel and Google Sheets.
• Collaborate with stakeholders to ensure data accuracy and process alignment.

• Training and Collaboration:
• Train and mentor team members on advanced Excel and Google Sheets functionalities.
• Collaborate with cross-functional teams to gather data and provide analytical support.

Experience: 4-6 years of professional experience in data analysis, reporting, and process optimization.

Technical Skills:

• Proficiency in Advanced Excel (Pivot Tables, VBA, Macros, Power Query, etc.).
• Expertise in Google Sheets (QUERY, IMPORTRANGE, ARRAYFORMULA, Apps Script).
• Familiarity with data visualization tools like Power BI, Tableau, or Google Data Studio.
• Basic knowledge of SQL or scripting for automation is an advantage.
• Excellent analytical, problem-solving, and organizational skills.
• Strong communication and interpersonal abilities.

Key Attributes:

• High attention to detail and accuracy.
• Ability to manage multiple tasks and meet deadlines effectively.
• Proactive approach to identifying and solving problems.