“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.
Skills Required
- 5-8 years of experience
- Advanced Alteryx knowledge including Alteryx Server experience
- Advanced Power BI knowledge including ability to write DAX and Power BI Cloud experience
- UiPath development experience (UiPath StudioX)
- Strong hands-on experience with Alteryx Designer (data preparation, joins, transformations, reconciliation, workflow optimisation)
- Practical experience with UiPath or comparable RPA tools for rules-based automation
- Strong Excel skills
- Experience with VBA, Power Query, SharePoint Lists, and Power Automate
- Ability to work with structured and semi-structured data and multiple data sources
- Understanding of the automation delivery lifecycle (requirements, design, development, UAT, deployment, documentation, support)
- Strong analytical skills, effective communication, ability to work independently and manage multiple automation initiatives
What the Team is Saying
Capco Compensation & Benefits Highlights
-
Wellbeing & Lifestyle Benefits — Wellbeing is emphasized as part of culture with flexible/hybrid work, mental-health resources, coaching, and a global Wellbeing@Capco group. Flexible arrangements and regional wellbeing programs are positioned to support work–life integration.
-
Parental & Family Support — Enhanced maternity, adoption, and shared-parental leave are highlighted alongside paid leave for sickness, pregnancy loss, fertility treatment, menopause, and bereavement. Return-to-work supports and family-friendly flexibility are explicitly called out.
-
Healthcare Strength — Core benefits include medical, dental, and vision coverage, with disability and life insurance noted in some markets. Health coverage is consistently presented as a solid part of the package.
Capco Insights
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent. TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients. DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success. DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions. ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
