Senior Data Analyst

Capco; India; Hybrid; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Capco, a Wipro company, is seeking a Data Analyst / Senior Data Analyst in Bengaluru/Pune. You will define source data requirements, map data across sources, and drive data migration activities for complex banking and financial services projects.

The role emphasizes data quality, governance, and stakeholder collaboration. The candidate should have strong Python and PySpark skills (4+ years), SQL and Hive knowledge, and experience with large-scale data programs.

Qualifications

• Minimum 4+ years of experience with Python and PySpark.
• Experience in Banking/Financial Markets data modelling.
• SQL queries and Hive/Putty proficiency.
• Strong written and verbal communication skills; stakeholder engagement aptitude.
• Experience with big data programs is preferred.

Responsibilities

• Define and obtain source data required to deliver insights and use cases.
• Map data across multiple sources to join datasets.
• Highlight data inconsistencies and enable review with feedback from users.
• Propose data migration sets to stakeholders and assist with migration.
• Coordinate data migration activities and maintain run-books and scope per customer.

Skills

Python

PySpark

SQL

Data analysis

Stakeholder comms

Education

Bachelor's degree in a relevant field

Tools

Hive

Putty

Notepad++

Job description

Job Title: Data Analyst (Python +Pyspark)

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 acrossbanking, 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 Description:

Role: Data Analyst / Senior Data Analyst

Location: Bangalore/ Pune

• Define and obtain source data required to successfully deliver insights and use cases
• Determine the data mapping required to join multiple data sets together across multiple sources
• Create methods to highlight and report data inconsistencies, allowing users to review and provide feedback on
• Propose suitable data migration sets to the relevant stakeholders
• Assist teams with processing the data migration sets as required
• Assist with the planning, tracking and coordination of the data migration team and with the migration run-book and the scope for each customer

Role Requirements

• Strong Data Analyst with Financial Services experience,
• Knowledge of and experience using data models and data dictionaries in a Banking and Financial Markets context
• Knowledge of one or more of the following domains (including market data vendors):
• Party/Client
• Trade
• Settlements
• Payments
• Instrument and pricing
• Market and/or Credit Risk
• Demonstrate a continual desire to implement "strategic" or "optimal" solutions and where possible, avoid workarounds or short term tactical solutions
• Working with stakeholders to ensure that negative customer and business impacts are avoided
• Manage stakeholder expectations and ensure that robust communication and escalation mechanisms are in place across the project portfolio
• Good understanding of the control requirement surrounding data handling

Experience/Skillset

• Excellent analytical skills and commercial acumen, Minimum 4+ years of experience with Python & Pyspark.
• Good understanding of the control requirements surrounding data handling
• Experience of big data programmes preferable
• Strong verbal and written communication skills
• Strong self-starter with strong change delivery skills who enjoys the challenge of delivering change within tight deadlines
• Ability to manage multiple priorities
• Business analysis skills, defining and understanding requirements
• Knowledge of and experience using data models and data dictionaries in a Banking and Financial Markets context
• Can write SQL queries and navigate data bases especially Hive, CMD, Putty, Note++
• Enthusiastic and energetic problem solver to join an ambitious team
• Good knowledge of SDLC and formal Agile processes, a bias towards TDD and a willingness to test products as part of the delivery cycle
• Ability to communicate effectively in a multi-programme environment across a range of stakeholders
• Attention to detail
• Preferable knowledge and experience in Data Quality & Governance

Good to have

• For Spark Scala - should have working experience using scala (preferable) or java for spark
• For Senior DAs: proven track record of managing small delivery-focussed data teams

[09:07] Mishra, Aditi

#LI-Hybrid