Data Analyst – Python, SQL & PySpark (Financial Services)

Capco; Warszawa; Hybrid; PLN 120,000 - 180,000; Full time

Benefits offered by this job

B2B contract

Access to modern data technologies

Collaborative environment

Job summary

Capco is seeking an experienced Data Analyst to join an international project for a leading global bank. You will work with large and complex datasets, analyse and transform data, and support regulatory reporting within the corporate clients segment.

You will collaborate with data engineers and business stakeholders, applying SQL, Python, and PySpark to deliver reliable data insights while expanding knowledge of ESG and regulatory reporting. Fluent English is required.

Qualifications

• Experience as a Data Analyst or similar data-focused role
• Strong SQL skills including joins, CTEs, aggregations, and data validation
• Hands-on Python, particularly Pandas
• Experience with PySpark and large-scale data processing
• Experience using Git and GitHub
• Experience working with large and complex datasets
• Understanding of ETL processes, data transformations, and data quality
• Strong analytical and problem-solving skills
• Good communication skills and fluent English

Responsibilities

• Analyse, transform, and validate large datasets using SQL, Python, and PySpark.
• Investigate data quality issues and identify root causes.
• Develop and validate data transformations and ETL processes.
• Work with data related to corporate clients, financial products, and reporting.
• Collaborate with data engineers, business analysts, and other stakeholders.
• Use Git and GitHub for version control and team collaboration.
• Document data mappings, transformation rules, and analytical findings.
• Support data preparation for regulatory and management reporting.

Skills

SQL

Python

PySpark

Git

Data analysis

ETL

Data quality

English

Tools

Git

GitHub

Jupyter Notebook

Prophecy

Job description

Poland - Warsaw

About Capco

Capco is a global technology and management consultancy specialising in financial services. We work with leading banks on data, technology, and transformation projects.

The Role

We are looking for an experienced Data Analyst to join an international project for a leading global bank.

The project focuses on data and regulatory reporting within the corporate clients segment.

You will work with large and complex datasets, analyse and transform data, investigate data quality issues, and collaborate closely with business and technical teams.

The role combines hands-on data analysis with exposure to ESG and regulatory reporting.

Familiarity with ESG concepts would be beneficial, while the key requirements are strong data analytics skills and a willingness to further develop knowledge in this area.

What You’ll Do

• Analyse, transform, and validate large datasets using SQL, Python, and PySpark.
• Investigate data quality issues and identify their root causes.
• Develop and validate data transformations and ETL processes.
• Work with data related to corporate clients, financial products, and reporting.
• Collaborate with data engineers, business analysts, and other stakeholders.
• Use Git and GitHub for version control and team collaboration.
• Document data mappings, transformation rules, and analytical findings.
• Support data preparation for regulatory and management reporting.

What We’re Looking For

• Experience working as a Data Analyst or in a similar data-focused role.
• Strong SQL skills, including joins, CTEs, aggregations, and data validation.
• Hands-on experience with Python, particularly Pandas.
• Practical experience with PySpark and large-scale data processing.
• Experience using Git and GitHub.
• Experience working with large and complex datasets.
• Understanding of ETL processes, data transformations, and data quality.
• Strong analytical and problem-solving skills.
• Good communication skills and fluent English.

Nice to Have

• Experience in banking or financial services.
• Understanding of ESG, regulatory reporting, SREP, or EBA reporting.
• Knowledge of corporate banking, credit risk, or financial exposures.
• Experience with Jupyter Notebook or Prophecy.

What We Offer

• B2B contract.
• Opportunity to work on an international banking project.
• Access to modern data technologies.
• Collaborative working environment and professional development opportunities.
• Opportunity to develop knowledge of ESG and regulatory reporting.

Recruitment Process

• Recruiter screening
• Capco technical interview
• Client interview
• Feedback and offer

Location:

Kraków or Warsaw - hybrid model, with office attendance depending on project needs.

#LI-HYBRID

Capco does not and shall notdiscriminateon the basis of race, color, religion (creed), gender, gender expression, age, national origin (ancestry), disability, marital status, sexual orientation, or military status, in any of its activities or operations. In order to track the effectiveness of our recruiting efforts, please consider participating in the optional questionnaire.