At a Glance
- Tasks: Support data transformation and controls remediation for a top-tier banking client.
- Company: Join a leading financial services firm in the heart of London.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Collaborative culture with a focus on innovation and career advancement.
- Why this job: Make a real impact in capital markets while developing your skills in a dynamic environment.
- Qualifications: 5+ years in data analytics, SQL, and Python; experience in financial services preferred.
The predicted salary is between 60000 - 80000 £ per year.
The Techno-Functional Business Analyst will support a data transformation and controls remediation program for a top-tier banking client, aligned to an ECB Remediation approach.
Responsibilities include:
- Supporting the stand-up and operating model of the remediation (pods structure, intake process, tooling, delivery routines).
- Driving delivery of quick-win remediation waves, ensuring requirements, triage, prioritization, and closure tracking across stakeholders.
- Contributing to and maintaining the controls gap assessment, supporting prioritization and ensuring closure plans are realistic and tracked.
- Identifying data sourcing gaps, coordinating root-cause discussions, and supporting agreement of closure plans with business and technology teams.
- Supporting delivery of manual controls automation waves, ensuring requirements, testing, evidence capture, and operational readiness.
- Ensuring catalogue lineage is populated, with measurable traceability coverage across critical data elements and reporting chains.
- Producing clear documentation and evidence to support UAT sign-off, audit reviews, and control attestations.
- Ensuring traceability from requirement → transformation logic → quality checks → reporting outputs → audit evidence, aligned to remediation governance.
Location: The role supports one of our top-tier banking clients in London (Canary Wharf) and requires a minimum of three days on-site presence.
Experience Requirements & Qualifications:
- Minimum 5 years of relevant experience in data analytics, data quality, reporting controls, or data transformation programs (preferably in financial services / Capital Markets).
- Experience working in regulated remediation environments, with exposure to audit evidence, controls testing, and structured governance.
- Strong domain understanding of Capital Markets data and reporting expectations (front-to-back awareness is a plus).
- Proficiency in SQL (advanced querying, performance tuning, reconciliation logic).
- Strong proficiency in Python for data analysis and automation (pandas, validation frameworks, scripting).
- Experience supporting or validating ETL/ELT pipelines and data quality frameworks (rules, thresholds, exception handling).
- Working knowledge of scheduling/orchestration tools such as Autosys and/or Apache Airflow (monitoring schedules, reruns, failure triage).
- Experience with CI/CD and release controls (Git, Harness, UrbanCode Deploy (UCD), Red Hat OpenShift or equivalent).
- Familiarity with large-scale storage patterns (e.g., AWS S3) for dataset movement and controls.
- Experience supporting BI/reporting outputs such as Tableau dashboards (data validation, extract refresh checks, reconciliation to source).
Nice-to-Have:
- Experience with tools such as PySpark, Spark SQL, Hive, Impala, HDFS, Parquet, and Oracle databases.
- Exposure to data governance concepts: critical data elements (CDEs), lineage, data quality dimensions, audit frameworks.
- Experience running delivery (intake, triage, prioritization, wave planning, pod execution, and reporting).
- Experience working in Agile/Scrum delivery models.
- Knowledge of monitoring/alerting tools for data pipelines and batch operations.
- Familiarity with control frameworks (data controls, attestations, audit readiness) and issue management tooling (e.g., DCRM).
- Familiarity with Visio or equivalent for process, lineage, and control mapping documentation.
Main tasks and responsibilities:
- Support remediation stand-up: pods model, intake process, tooling usage, delivery routines, and governance rhythms.
- Conduct discovery sessions to understand reporting objectives, key datasets, control expectations, and remediation edge cases.
- Drive delivery of quick-win remediation waves, ensuring triage, prioritization, and closure evidence are complete.
- Perform data profiling and produce findings on completeness, accuracy, consistency, and timeliness to support gap analysis.
- Design and execute reconciliation checks (source vs target, pre vs post transformation, report vs underlying data).
- Support delivery and maintenance of controls gap assessment outputs, including prioritization and closure tracking.
- Identify data sourcing gaps, coordinate root-cause analysis with SMEs, and document agreed closure plans.
- Support manual controls automation waves by defining requirements, validating outputs, and ensuring operational readiness.
- Ensure catalogue lineage is populated and traceability coverage is measurable and reported for key reporting chains.
- Lead/Support UAT activities for reporting and controls; validate outcomes and document evidence for sign-off.
- Produce an audit-ready documentation pack: test packs, control evidence, lineage evidence, decision logs, and explainable results.
- Track and communicate risks, dependencies, and changes impacting remediation outcomes, ensuring governance readiness.
“Techno-Functional” Analyst– Capital Markets Data Transformation employer: Boundaryless
As a leading employer in the financial services sector, we offer a dynamic work environment in the heart of Canary Wharf, London, where innovation meets excellence. Our commitment to employee growth is reflected in our robust training programmes and opportunities for career advancement, while our collaborative culture fosters teamwork and creativity. Join us to be part of a transformative journey in capital markets data, where your contributions will directly impact our top-tier banking clients and the industry at large.
StudySmarter Expert Advice🤫
We think this is how you could land “Techno-Functional” Analyst– Capital Markets Data Transformation
✨Tip Number 1
Network like a pro! Get out there and connect with folks in the industry. Attend meetups, webinars, or even casual coffee chats. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio or a GitHub repository showcasing your projects, especially those related to data transformation and analytics. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common questions and scenarios specific to the role. Think about how your experience aligns with the requirements, especially around data quality and controls. Confidence is key, so rehearse until you feel ready to shine!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive and engaged. So, hit that apply button and let’s get you on board!
We think you need these skills to ace “Techno-Functional” Analyst– Capital Markets Data Transformation
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the role of Techno-Functional Analyst. Highlight your experience in data transformation and controls remediation, especially in financial services. We want to see how your skills align with the job description!
Showcase Relevant Experience:When writing your application, focus on your relevant experience, particularly in data analytics and reporting controls. Use specific examples that demonstrate your proficiency in SQL and Python, as these are key for this role.
Be Clear and Concise:Keep your application clear and concise. Use bullet points where possible to make it easy for us to read through your qualifications and experiences. We appreciate straightforward communication!
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Boundaryless
✨Know Your Data Inside Out
Make sure you brush up on your knowledge of Capital Markets data and reporting expectations. Be prepared to discuss how you've handled data transformation projects in the past, especially in regulated environments. This will show that you understand the nuances of the role.
✨Showcase Your Technical Skills
Since this role requires proficiency in SQL and Python, be ready to demonstrate your skills. You might be asked to solve a problem or write a query on the spot, so practice common scenarios beforehand. Highlight any experience with ETL/ELT pipelines and data quality frameworks as well.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to describe how you would handle specific situations, like identifying data sourcing gaps or conducting root-cause analysis. Use the STAR method (Situation, Task, Action, Result) to structure your answers clearly and effectively.
✨Understand the Remediation Process
Familiarise yourself with the ECB Remediation approach and how it applies to data transformation. Be ready to discuss how you would support the stand-up of remediation pods and ensure governance readiness. This shows you're not just technically skilled but also understand the operational side of things.
