Data Analyst

Job Title: Data Analyst (Python +Pyspark)

About Us

Consultancy of the year in the British Bank Award

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.

Role: Data Analyst / Senior Data Analyst

Location : Bangalore/ Pune

Responsibilities

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

Must have -

• Excellent analytical skills and commercial acumen, Minimum 4+ years of experience with Python.

• 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-focused data teams