At a Glance
- Tasks: Support data transformation for top-tier banking clients and ensure data quality.
- Company: Join Boundaryless, a global consulting firm with a diverse team and innovative projects.
- Benefits: Permanent position in London with competitive salary and opportunities for growth.
- Why this job: Make an impact in financial services while working with cutting-edge data technologies.
- Qualifications: 5+ years in data analytics, strong SQL and Python skills required.
- Other info: Collaborative environment with a focus on diversity and inclusion.
The predicted salary is between 36000 - 60000 £ per year.
Boundaryless is a boutique consulting firm, providing clients with deep expertise in advanced analytics & data forensics, agentic automation, and Artificial Intelligence solutions. We operate around the world, with offices in 7 countries: United Kingdom, France, The Netherlands, Switzerland, India, Sri Lanka, and the USA. Boundaryless is an equal opportunity employer. Our team is a living example of diversity, with 13 nationalities and 50% female employees.
Due to the growing demand from financial services organizations for automation services supporting data transformation and agentic process automation, we have open positions for Business Analysts who understand operational and regulatory reporting processes in (investment) banking. Capital Markets knowledge and Finance experience are key components for this role.
The Technical Data Analyst will support a data transformation and controls program for a top-tier banking client. Responsibilities include:
- Translating business requirements into technical specifications.
- Analyzing, validating, and reconciling large-scale datasets used for operational and regulatory reporting.
- Working across IT teams to define data requirements, quality rules, and controls for critical data elements.
- Facilitating the UK issue remediation process by hosting and facilitating conference calls amongst SMEs required to drive items to closure.
- Tracking, adjudication, and reporting of Data Quality issues.
- Working with team members on topics including data profiling, lineage validation, source-to-target mapping, and root-cause analysis for data issues.
- Producing clear documentation and evidence to support UAT sign-off, audit reviews, and control attestations.
- Ensuring traceability from data requirement → transformation logic → quality checks → reporting outputs → audit evidence.
The role supports one of our top-tier banking clients in London (Canary Wharf) and requires a minimum of three days on-site presence. This is a permanent position based in the UK. We will only consider applicants who are eligible to work in the UK. For this role, we do NOT offer visa sponsorship.
Experience Requirements & Qualifications
- Minimum 5 years of relevant experience in data analytics, data quality, reporting controls, or data transformation programs (preferably in financial services).
- Proficiency in SQL (advanced querying, performance tuning, reconciliation logic).
- Strong proficiency in Python for data analysis and automation (pandas, data validation frameworks, scripting).
- Experience supporting or validating ETL/ELT pipelines and data quality frameworks (rules, thresholds, exception handling).
- Working knowledge of Autosys & Apache Airflow (monitoring schedules, reruns, failure triage).
- Experience with CI/CD tools (Git, Harness, UrbanCode Deploy (UCD), Red Hat OpenShift).
- Familiarity with AWS S3 for large-scale data storage and dataset movement patterns.
- Experience supporting Tableau dashboards (data validation, extract refresh checks, reconciliation to source).
Nice-to-Have
- Experience with tools including PySpark, Spark SQL, Hive, Impala, HDFS, Parquet, and Oracle databases.
- Experience in regulated or enterprise data environments (investment banking, risk, finance, compliance).
- Exposure to data governance concepts: critical data elements (CDEs), lineage, data quality dimensions, audit frameworks.
- Experience working in Agile/Scrum delivery models.
- Knowledge of monitoring/alerting tools for data pipelines and batch operations.
- Familiarity with regulatory reporting domains or control frameworks (data controls, attestations, audit readiness).
- Familiarity with Visio, as well as DCRM tools to manage, document and monitor data quality issues.
Main tasks and responsibilities
- Conducting discovery sessions to understand reporting objectives, key datasets, and edge cases.
- Performing data profiling and producing findings on completeness, accuracy, consistency, and timeliness.
- Designing and executing reconciliation checks (source vs target, pre vs post transformation, report vs underlying data).
- Supporting creation of data requirements artifacts (data dictionaries, source-to-target mapping support, business rules, quality rules).
- Defining and maintaining data quality checks, exception logs, and analysis on recurring defects.
- Leading/Supporting UAT activities for reporting and controls; validating outcomes and documenting evidence.
- Producing audit-ready documentation: test packs, control evidence, runbooks, and explainable results.
- Partnering with engineers to troubleshoot data issues and ensure analytical intent is preserved in implementation.
- Tracking and communicating risks, dependencies, and changes impacting reporting and control outcomes.
If you feel you fit this profile, please apply via email. Please send your CV as well as an overview of automation projects you have delivered.
Experienced “Techno-Functional” Business Analyst (Data Transformation, CapitalMarkets) in Ilford employer: Boundaryless Ltd
Contact Detail:
Boundaryless Ltd Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Experienced “Techno-Functional” Business Analyst (Data Transformation, CapitalMarkets) in Ilford
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at Boundaryless or similar firms. A friendly chat can sometimes lead to job opportunities that aren't even advertised yet.
✨Tip Number 2
Prepare for interviews by brushing up on your technical skills. Since this role requires proficiency in SQL and Python, make sure you can showcase your expertise with real examples from your past projects.
✨Tip Number 3
Don’t just wait for job openings to pop up! Keep an eye on our website and apply directly when you see something that fits. It shows initiative and can give you a leg up over other candidates.
✨Tip Number 4
Be ready to discuss your experience with data quality frameworks and ETL processes. Prepare some stories that highlight your problem-solving skills and how you've tackled data issues in the past.
We think you need these skills to ace Experienced “Techno-Functional” Business Analyst (Data Transformation, CapitalMarkets) in Ilford
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to highlight your experience in data analytics and capital markets. We want to see how your skills align with the role, so don’t be shy about showcasing relevant projects and achievements!
Showcase Your Technical Skills: Since this role requires proficiency in SQL and Python, make sure to include specific examples of how you've used these tools in your previous roles. We love seeing concrete evidence of your technical prowess!
Be Clear and Concise: When writing your application, clarity is key! Use straightforward language and avoid jargon where possible. We appreciate a well-structured application that gets straight to the point.
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 Ltd
✨Know Your Data Inside Out
Make sure you brush up on your data analytics skills, especially SQL and Python. Be ready to discuss specific projects where you've used these tools, particularly in financial services. Highlight your experience with data quality frameworks and ETL processes, as this will show you're well-versed in the technical aspects of the role.
✨Understand the Business Context
Familiarise yourself with the banking sector, especially Capital Markets. Research Boundaryless and their clients to understand their needs and challenges. This will help you articulate how your skills can directly benefit their operations and demonstrate that you’re not just a techie but also a business-savvy analyst.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems or analyse data scenarios. Practice articulating your thought process clearly, especially around data profiling, reconciliation checks, and UAT activities. Use the STAR method (Situation, Task, Action, Result) to structure your responses effectively.
✨Showcase Your Collaboration Skills
Since the role involves working across IT teams and facilitating discussions, be prepared to share examples of how you've successfully collaborated with others. Highlight any experience you have in Agile/Scrum environments, as this will resonate well with their team dynamics and show you can adapt to their workflow.