System Analyst / Data Analyst

About Us

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

Job Title: System Analyst / Data Analyst

Location: Pune, India
Experience: 6 to 9 Years
Domain: Payments (Preferred)

About the Role:

We are seeking a detail-oriented and experienced System Analyst / Data Analyst with strong SQL skills and a background in the Payments domain. The ideal candidate will analyze complex business requirements, design data-driven solutions, and collaborate with cross-functional teams to improve business processes and decision-making.

Key Responsibilities:

• Analyze and translate business requirements into technical specifications and data models.
• Hands on experience in Hadoop
• Hands on experience in Unix and able to write complex queries
• Develop, optimize, and maintain complex SQL queries, stored procedures, and reports.
• Extract, transform, and load (ETL) data from various sources to support analytics and reporting.
• Perform data validation, quality checks, and troubleshooting to ensure data integrity.
• Collaborate with business stakeholders, product owners, and IT teams to deliver actionable insights.
• Design dashboards and reports using BI tools to support operational and strategic decision-making.
• Support Payment domain-specific analysis including transaction data, reconciliation, fraud detection, and settlement processes.
• Identify opportunities for process automation and improvements based on data analysis.
• Document system processes, workflows, and analytical findings clearly and concisely.

Required Skills & Experience:

• 6 to 9 years of professional experience as a System Analyst or Data Analyst.
• Strong hands-on experience with SQL (writing complex queries, joins, subqueries, optimizations).
• Experience with relational databases such as Oracle, SQL Server, MySQL, or PostgreSQL.
• Solid understanding of data modeling, ETL processes, and data warehousing concepts.
• Prior experience or exposure to the Payments domain (payment processing, clearing, settlement, fraud detection) is highly preferred.
• Familiarity with BI and reporting tools (Tableau, Power BI, QlikView, etc.) is a plus.
• Good problem-solving skills with an analytical mindset.
• Strong communication skills to liaise between technical teams and business stakeholders.
• Ability to work independently and as part of a team in an agile environment.

Educational Qualifications:

• Bachelor’s degree in computer science, Information Technology, Finance, or a related field.
• Relevant certifications in Data Analytics, SQL, or Payment’s domain will be an advantage.