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

<p>&nbsp;</p> <p style="text-align: center;"><strong><span lang="en-US" data-olk-copy-source="MessageBody">Data Analyst – Python, SQL &amp; PySpark (Financial Services)</span></strong></p> <p><strong><span lang="en-US">About Capco</span></strong></p> <p><span lang="en-US">Capco is a global technology and management consultancy specialising in financial services. We work with leading banks on data, technology, and transformation projects.</span></p> <p><strong><span lang="en-US">&nbsp;</span></strong></p> <p><strong><span lang="en-US">The Role</span></strong></p> <p><span lang="en-US">We are looking for an experienced Data Analyst to join an international project for a leading global bank.</span></p> <p><span lang="en-US">The project focuses on data and regulatory reporting within the corporate clients segment.</span></p> <p><span lang="en-US">You will work with large and complex datasets, analyse and transform data, investigate data quality issues, and collaborate closely with business and technical teams.</span></p> <p><span lang="en-US">The role combines hands-on data analysis with exposure to ESG and regulatory reporting.</span></p> <p><span lang="en-US">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.</span></p> <p><strong><span lang="en-US">&nbsp;</span></strong></p> <p><strong>What You’ll Do</strong></p> <ul type="disc"> <li><span lang="en-US">Analyse, transform, and validate large datasets using <strong>SQL, Python, and PySpark</strong>.</span></li> <li><span lang="en-US">Investigate data quality issues and identify their root causes.</span></li> <li><span lang="en-US">Develop and validate data transformations and ETL processes.</span></li> <li><span lang="en-US">Work with data related to corporate clients, financial products, and reporting.</span></li> <li><span lang="en-US">Collaborate with data engineers, business analysts, and other stakeholders.</span></li> <li><span lang="en-US">Use <strong>Git and GitHub</strong> for version control and team collaboration.</span></li> <li><span lang="en-US">Document data mappings, transformation rules, and analytical findings.</span></li> <li><span lang="en-US">Support data preparation for regulatory and management reporting.</span></li> </ul> <p><strong>What We’re Looking For</strong></p> <ul type="disc"> <li><span lang="en-US">Experience working as a Data Analyst or in a similar data-focused role.</span></li> <li><span lang="en-US">Strong <strong>SQL</strong> skills, including joins, CTEs, aggregations, and data validation.</span></li> <li><span lang="en-US">Hands-on experience with <strong>Python</strong>, particularly Pandas.</span></li> <li><span lang="en-US">Practical experience with <strong>PySpark</strong> and large-scale data processing.</span></li> <li><span lang="en-US">Experience using <strong>Git and GitHub</strong>.</span></li> <li><span lang="en-US">Experience working with large and complex datasets.</span></li> <li><span lang="en-US">Understanding of ETL processes, data transformations, and data quality.</span></li> <li><span lang="en-US">Strong analytical and problem-solving skills.</span></li> <li><span lang="en-US">Good communication skills and fluent English.</span></li> </ul> <p><strong>Nice to Have</strong></p> <ul type="disc"> <li><span lang="en-US">Experience in banking or financial services.</span></li> <li><span lang="en-US">Understanding of <strong>ESG, regulatory reporting, SREP, or EBA reporting</strong>.</span></li> <li><span lang="en-US">Knowledge of corporate banking, credit risk, or financial exposures.</span></li> <li><span lang="en-US">Experience with Jupyter Notebook or Prophecy.</span></li> </ul> <p><strong>&nbsp;</strong></p> <p><strong>What We Offer</strong></p> <ul type="disc"> <li>B2B contract.</li> <li>Hybrid working model.</li> <li><span lang="en-US">Opportunity to work on an international banking project.</span></li> <li><span lang="en-US">Access to modern data technologies.</span></li> <li><span lang="en-US">Collaborative working environment and professional development opportunities.</span></li> <li><span lang="en-US">Opportunity to develop knowledge of ESG and regulatory reporting.</span></li> </ul> <p><strong>&nbsp;</strong></p> <p><strong>Recruitment Process</strong></p> <ol type="1"> <li>Recruiter screening</li> <li>Capco technical interview</li> <li>Client interview</li> <li>Feedback and offer</li> </ol> <p><strong><span lang="en-US">Location:</span></strong><span lang="en-US"> Kraków or Warsaw - hybrid model, with office attendance depending on project needs.</span></p> <p><strong>#LI-HYBRID</strong></p> <p>&nbsp;</p>