Analyze, transform, validate, and investigate large datasets using SQL, Python, and PySpark. Develop ETL processes, resolve data quality issues, document data mappings and transformation rules, and support regulatory and management reporting. Collaborate with data engineers, business analysts, and stakeholders on corporate banking and financial services data, including ESG and regulatory reporting.
Data Analyst – Python, SQL & PySpark (Financial Services)
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.
- 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
Similar Jobs at Capco
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead enterprise data architecture for complex transformation programs, defining target-state architectures, data models, integration patterns, scalable cloud data platforms, governance standards, and security practices. Collaborate with stakeholders and engineering teams, conduct design reviews, assess risks, document decisions, and guide implementation across financial services and enterprise client engagements.
Top Skills:
Api GatewaysCloud-Native ServicesDbtEltETLMicroservicesRest ApisSnowflake
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Conduct cybersecurity threat and risk assessments across infrastructure, cloud environments, applications, platforms, and business services. Evaluate security controls, identify vulnerabilities and control gaps, document risk scenarios, and recommend remediation. Collaborate with security, architecture, engineering, risk, and business stakeholders to embed security assessments into technology delivery. Produce risk reports supporting governance, risk acceptance, remediation planning, and informed decision-making.
Top Skills:
Cloud ComputingCybersecurity FrameworksInformation Security
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Analyzes enterprise data across PostgreSQL, Salesforce, Splunk, and integrated systems. Writes complex SQL queries, investigates logs and data discrepancies, performs reconciliation and validation, identifies root causes, and recommends improvements. Collaborates with technical and business stakeholders to translate requirements into actionable insights, document findings, resolve cross-system issues, and improve data quality and operational efficiency in a financial services environment.
Top Skills:
APIsConfluenceEtl/EltJIRAPostgresSalesforceSOQLSplunkSQL
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
