Position Title: Assistant Manager - Process Automation & Reporting, Analytics

Location: Goregaon East, Mumbai, India

Job Timings: 9 AM to 6 PM

Role Description:

- Take complete ownership of developing, administering, and enhancing solutions in Power BI, Power Apps, Power Automate, and VBA, ensuring scalability and efficiency.
- Design, build, and maintain interactive dashboards, Automation workflows, and apps to deliver timely, accurate, and standardized information for improved decision-making.
- Business partnering Collaborate with internal stakeholders in Australia to gather requirements and understand business needs and translate to make essential technical and strategic changes to improvise present business intelligence systems and reports.
- Must demonstrate analytical thinking & excellent communication skills - to understand and communicate needs with client and internal teams successfully.
- The role will be responsible for driving automation, analytics, and reporting solutions using Microsoft Power Platform (Power Automate, Power Apps, Power BI) along with VBA development to optimize processes and support business decisions.
- This role requires a self-starter who can work independently, drive automation initiatives, and deliver impactful reporting and visualization solutions that add value to the business.

Key Responsibilities

- Deliver Standard and Adhoc BI Reports & Analysis/tics | Build Reports/Tools from scratch (40%)
- Design, develop, maintain and optimize reporting with the aim to deliver timely and accurate information in a standardized manner to increase efficiency and support decision making
- Master and own the weekly/monthly deliverables in the form of dashboard reports & presentations and send quality output in a timely manner
- Upgrade weekly/monthly deliverables based on business requirements and facilitate the larger team create functional, high impact efficient reports
- Comprehend the nuances of process & functional strategies and leverage various tools to build real-time performance trackers from scratch with crisp observations and insights
- Work alongside peers and inculcate best practices and tackle real time business questions with value adds
- Display a high sense of accountability and presence of mind when completing requests with high visibility or tight turnaround times and communicate effectively




- Find synergies in the reports/database to avoid redundancy
- Resource Pool on complex projects with the team and contribute to brand building
- Business partnering Collaborate with internal stakeholders to gather requirements and understand business needs and translate to make essential technical and strategic changes to improvise present business intelligence systems
- Technical Expertise Power platform (Power app and Power Automate RPA/Cloud Flows) (50%)
- Apply intermediate to advanced expertise in Power Automate and Power Apps to design, develop, and deploy scalable automation workflows and business applications.
- Actively learn and implement best practices for automation governance, security, and compliance in alignment with organizational guidelines.
- Build a robust audit and monitoring system for all automation and app-related activities to ensure transparency, reliability, and control.
- Optimize existing processes by identifying opportunities for automation and re-using developed flows or apps to improve efficiency and effectiveness.
- Continuously enhance skills through self-learning and recommended training to stay up to date with evolving Power Platform capabilities.
- Share knowledge with the team by documenting solutions, conducting walkthroughs, and enabling wider adoption of automation and app-based solutions across the business.
- Continuous Improvement to deliver Executional Excellence, Stakeholder and Project Management (10%)
- Ensure TAT is upheld via awareness on process requirements, meeting benchmark time estimates and through articulate expectation settings with the stakeholder
- Guarantee data quality and accuracy through thorough comprehension of request, accurate application of tools/platforms with an eye for detail and a robust data & logic check
- CI Mindset: develop a lens of continuous improvement for the projects, process & larger team
- Stakeholder Management:



Engage with the stakeholders to understand the requirement, explain tactical application in our reports/process, cross reference projects and present final output upon project completion.
- Project Management: Handle and manage multiple projects seamlessly starting with project scoping, to tackling hurdles to timely communication/iterations with peers and stakeholders to high impact completion and presentation.

Qualifications:

Education

Minimum Degree Requirements: Bachelors Preferred Degree Requirements: Bachelors/Masters Preferred Major Area of Study: Business Management/Statistics/Computer Science/Information Systems

Experience

Minimum years: 6-10 years of relevant

Business Reporting or Analytics experience

Specific Job Experience or Skills Needed

- Working Experience of Advanced Power BI (ability to implement complex queries viz DAX etc.) & Visualization skills (Exposure to visualization tools like Tableau is a plus)
- Working Experience on Power Automate & Power App is Must
- MS Office proficiency preferred (Advanced Excel must: Formulae & Dashboarding)
- Experience of working in SQL, Excel, and MS Access
- Strong understanding of data models, ETL cycles
- Comprehending complex requests & meeting timelines and expectations
- Strong understanding of financial data and concepts
- Strong command over oral and written English
- Continuous Improvement mindset
- Multitasking ability - work on a host of tools/databases and software's/platforms
- Organization and Prioritization
- Collaborate with peers to align with the teams vision

Competencies/Behaviors required for job

- Analytical thinking & Excellent communication skills - to understand and communicate needs with client and internal teams successfully
- Seeks assistance, information, and resources at the right time to make quick, valuable decisions
- Resilience - willingness to change mind or approach given new information
- Develops an awareness of own's strengths and development needs; seeks and learns from feedback
- Inclination to learn end-to-end project completion
- Communicate effectively with peers & stakeholders; influence team on applying initiatives
- Have excellent written and spoken business English language skills.
- Proactive and the ability to handle ambiguous situations in a calm, composed manner

📌 Assistant Manager - Process Automation & Reporting (Mumbai)
🏢 Sodexo
📍 Mumbai