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

Description

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.

Responsibilities

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

Requirements

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

Benefits

• B2B contract.
• Hybrid working model.
• 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