BA Automation Specialist - Mumbai

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount . With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery. WHY JOIN CAPCO? You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry. MAKE AN IMPACT Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services. #BEYOURSELFATWORK Capco has a tolerant, open culture that values diversity, inclusivity, and creativity. CAREER ADVANCEMENT With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands. DIVERSITY & INCLUSION We believe that diversity of people and perspective gives us a competitive advantage.

BA Automation Specialist Experience: 5-8 years Location: Mumbai

Role Overview We are seeking a highly motivated

Operations Automation Specialist to work closely with Operations teams to identify manual, repetitive, inefficient, and risk-prone processes and convert them into scalable automation solutions. The role will use technologies such as

Alteryx, UiPath, Power BI, Excel/VBA , and other workflow automation platforms. This position will support the Operations transformation agenda by improving process efficiency, reducing manual touchpoints, strengthening controls, lowering operational risk, and contributing to departmental automation and capacity-saving objectives. Alteryx will primarily be used to automate complex, manual, Excel-based processes, while UiPath will be used to automate repetitive, rules-based activities to improve efficiency and productivity. The successful candidate will have a strong analytical mindset, a practical understanding of Operations processes, and the ability to work independently with minimal supervision. They should be confident engaging directly with Operations subject-matter experts, identifying process pain points, translating business needs into automation solutions, and delivering production-ready outcomes.

Key Responsibilities Process Discovery and Opportunity Assessment

• 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.

Automation Development and Delivery

• 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.

Required Skills And Experience Advanced Alteryx / Power BI knowledge including Alteryx Server / Power BI Cloud experience

• Alteryx – Ability to develop complex workflows connecting to multiple data sources
• Power BI – Being able to write DAX functions is a must to be considered advanced enough for the role
• UiPath – 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
• Data connectivity experience helpful

Technical Skills

• 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. Experience with VBA, Power Query, Power BI, SharePoint Lists, and Power Automate would be advantageous.
• 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.
• Familiarity with automation idea intake, prioritization, or benefit-tracking processes would be beneficial.

Behavioral Skills

• 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.