Design the data foundation that connects trades, instruments, and markets.
The Role
We’re looking for an experienced Capital Markets Data SME to design and shape a scalable Transaction Data Warehouse and analytics platform that brings together transaction data, Security Master, Reference Data, and Market Data.
This is a senior, hands-on SME role with significant ownership across solution design, data modelling, enrichment, and analytics. You’ll help create a trusted data foundation that enables consolidated views of trades, securities, issuers, pricing, and market information across a range of business and analytical use cases.
Working closely with Trading, Operations, Analytics, Product, and Engineering teams, you’ll translate complex business and data requirements into scalable solutions, strengthen data quality and controls, and shape how high-volume financial data is organized, enriched, and consumed.
What You’ll Do
- Design and shape a scalable Transaction Data Warehouse supporting analytics, reporting, and downstream consumption across Capital Markets use cases.
- Integrate and enrich transaction and trade data with Security Master, Reference Data, and Market Data, including effective-dated and historical datasets.
- Define robust data models and relationships across transactions, instruments, securities, issuers, accounts, pricing, and market data, including instrument resolution using ISIN, CUSIP, SEDOL, FIGI, tickers, and internal identifiers.
- Design efficient ingestion, transformation, enrichment, and query patterns using QuestDB, columnar or time-series databases, and other technologies suited to high-volume financial datasets.
- Establish data-quality, reconciliation, validation, lineage, and exception-management controls while partnering with business and technology teams to deliver trusted, analytics-ready data solutions.
What We’re Looking For
- 7+ years of relevant experience within Capital Markets, trading data, financial data, or related data-focused roles, including hands-on experience with transaction or trade data and data warehouse architectures.
- In-depth understanding of Security Master and Reference Data, including instrument identifiers, security mappings, instrument resolution, and the enrichment of transactional datasets.
- Good understanding of Market Data, including pricing, historical and time-series data, and the use of market information within analytical data models.
- Advanced SQL, database, data-modelling, and data-analysis skills, with experience joining, reconciling, and analysing high-volume financial datasets.
- Experience with columnar or time-series database technologies and building analytics-ready data models; QuestDB experience is highly desirable but not essential.
Bonus Points For
- Python and data-engineering framework experience.
- Experience with cloud-based data platforms.
- Knowledge of market and reference-data providers such as Bloomberg, ICE, S&P, or LSEG.
- Experience with EDM or Security Master platforms such as GoldenSource, Markit EDM, or Bloomberg Enterprise Data.
- Exposure to real-time or near-real-time transaction analytics.
Why Join Capco
- Deliver high-impact technology solutions for Tier 1 financial institutions.
- Work in a collaborative, flat, and entrepreneurial consulting culture.
- Access continuous learning, training, and industry certifications.
- Be part of a team shaping the future of digital financial services.
- Help shape the future of digital transformation across FS & Energy.
Benefits
We offer a competitive, people-first benefits package designed to support every aspect of your life:
- Comprehensive Benefits Coverage – 100% company-paid health, life, and disability insurance effective from Day 1 of employment.
- Retirement Savings Program – Registered Retirement Savings Plan (RRSP) with the option of receiving a matching employer contribution.
- Virtual Health Care & Support – Company-paid virtual health care and Employee & Family Assistance Program (EFAP) available to employees and their dependents/partners.
- Family & Wellness Support – Parental Leave Top-Up, a New Parent Gift and fitness reimbursement to support health and well-being.
- Career Development – A Business Coach from Day 1, providing personalized one-on-one coaching to support career growth, accelerate development and help you achieve your professional goals at Capco.
Inclusion at Capco
We’re committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know – we’ll be happy to help. We value each person’s unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration – a mindset that shapes how we work with clients and each other every day.
Use of Artificial Intelligence in Talent Acquisition
At Capco, we use artificial intelligence (AI) tools to support and enhance several parts of talent acquisition. This includes using AI-enabled features within LinkedIn to help source potential candidates, speeding up routine recruitment communications such as emails and creating compelling and brand-aligned job postings that accurately reflect role requirements, and AI-scheduling applications to improve the efficiency of interview coordination.
AI is used as a support tool only. All hiring decisions are made by talent acquisition and hiring teams.
Why This Role Is Open
We are currently hiring for this role due to an existing or newly created vacancy within our organization. This position is open as part of our ongoing business needs, and we are actively reviewing applications to fill this role with a qualified candidate who can make an immediate impact.
Pay Transparency
The salary range for this position is listed below. Additionally, this position may also be eligible to receive an annual discretionary/variable bonus payment.
Capco is committed to providing fair and equitable compensation to our people. Our compensation policies and salary ranges are designed to allow our people to progress through the salary range as they demonstrate strong performance and develop in their role over time. The base pay offered to selected candidates will be within the salary range and the placement will vary based upon a variety of factors, including, but not limited to job-related knowledge, skills, experience and internal equity.
Skills Required
- 7+ years of relevant experience in capital markets, trading data, financial data, or related data-focused roles
- Hands-on experience with transaction or trade data and data warehouse architectures
- In-depth understanding of Security Master and Reference Data, including instrument identifiers, security mappings, instrument resolution, and transactional data enrichment
- Good understanding of Market Data, including pricing, historical data, and time-series data
- Advanced SQL, database, data modeling, and data analysis skills
- Experience joining, reconciling, and analyzing high-volume financial datasets
- Experience with columnar or time-series database technologies and analytics-ready data models
- QuestDB experience
- Python and data-engineering framework experience
- Experience with cloud-based data platforms
- Knowledge of Bloomberg, ICE, S&P, or LSEG market and reference-data providers
- Experience with GoldenSource, Markit EDM, or Bloomberg Enterprise Data platforms
- Exposure to real-time or near-real-time transaction analytics
What the Team is Saying
Capco Compensation & Benefits Highlights
-
Healthcare Strength — Health coverage is considered strong, with medical, dental, and vision commonly provided alongside mental-health resources and wellbeing programs. Multiple plan options and generally good coverage quality are highlighted.
-
Leave & Time Off Breadth — Vacation/PTO is a standout, with generous allotments and, in some cases, unlimited sick leave, plus programs intended to help employees recharge. Flexible work arrangements are also emphasized, supporting work-life balance.
-
Retirement Support — Retirement offerings include a 401(k) with company matching in the U.S., alongside life and disability insurance in many regions. These elements round out a solid financial benefits package.
Capco Insights
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent. TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients. DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success. DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions. ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
