BA Automation Specialist - Mumbai

Overview

Work closely with Operations teams to identify manual, repetitive, inefficient, and risk-prone processes and convert them into scalable automation solutions. Use Alteryx, UiPath, Power BI, Excel/VBA, and other workflow automation platforms to improve process efficiency, reduce manual touchpoints, strengthen controls, lower operational risk, and support departmental automation and capacity-saving objectives.

What you'll do

• Partner with Operations teams to understand process pain points, manual activities, recurring issues, control gaps, and operational inefficiencies.
• Assess processes for automation suitability, considering repeatability, data availability, transaction volumes, potential effort savings, risk reduction, and scalability.
• Translate operational challenges into clearly defined automation use cases, business requirements, and measurable benefit cases.
• Support automation idea intake, benefit tracking, prioritisation, and delivery-readiness activities.
• Design, develop, test, and implement automation solutions using Alteryx and UiPath, with potential integration across Excel, Outlook, Power BI, SharePoint, and other Operations tools.
• Build Alteryx workflows to transform, reconcile, validate, and prepare operational data.
• Develop UiPath automations for repetitive, rules-based activities, including downloading files, navigating systems, extracting data, preparing reports, routing information, and reducing manual intervention.
• Ensure solutions are robust, controlled, scalable, easy for Operations users to run, and straightforward to maintain.
• Produce runbooks, user guides, control documentation, and handover materials for business-as-usual teams.

What you'll need

• 5-8 years of experience.
• Advanced Alteryx / Power BI knowledge, including Alteryx Server / Power BI Cloud experience.
• Ability to develop complex Alteryx workflows connecting to multiple data sources.
• Ability to write DAX functions in Power BI.
• Ability to develop bots using UiPath StudioX.
• Strong analytical skills coupled with ability to support and upskill users in using the tool and building their solutions.
• Strong hands-on experience with Alteryx Designer, including data preparation, joins, transformations, filtering, reconciliation logic, workflow optimisation, and output generation.
• Practical experience with UiPath or comparable robotic process automation tools used to automate repetitive, rules-based operational activities.
• Strong Excel skills.
• Ability to work with structured and semi-structured data from multiple sources.
• Understanding of the automation delivery lifecycle, including requirements gathering, solution design, development, user acceptance testing, production deployment, documentation, and ongoing support.
• Self-motivated and able to work independently with minimal guidance.
• Strong analytical capability and attention to detail.
• Curious, solution-focused, and comfortable challenging inefficient manual processes.
• Effective communication skills, with the ability to explain technical solutions to non-technical Operations users.
• Ability to manage priorities across multiple automation initiatives.
• Collaborative approach, with the ability to establish trust with Operations subject-matter experts and senior stakeholders.

Nice to have

• Data connectivity experience.
• Experience with VBA, Power Query, Power BI, SharePoint Lists, and Power Automate.
• Familiarity with automation idea intake, prioritization, or benefit-tracking processes.

Details

• Location: Mumbai, India.