Market Data Principal Consultant

About the team:

Capco’s Data Team helps our clients transform every aspect of their business. We are highly skilled at formulating data strategy, defining business and technology initiatives across the data management lifecycle, and aligning multi-year strategic roadmaps with client’s business goals. As digital technologies advance and regulations tighten, today’s consumers – and, therefore, today’s businesses – are becoming more aware of the importance of good quality data. We work to establish holistic ways to effectively manage data through the modern data supply chain and facilitate consumption through analytics, modelling, AI, machine learning, dashboarding, and reporting.

 

About the Job:

We are seeking an experienced and technically proficient Market Data Analyst to support the buildout of a strategic Market Data Hub. This role requires translating complex business requirements into functional specifications and collaborating closely with engineering teams to deliver scalable data solutions. The ideal candidate will have strong market data domain knowledge and hands-on technical skills—particularly in Python and Snowflake—to support data analysis, validation, and integration efforts.

What You’ll Get to Do: 

• Gather, analyze, and document market data requirements from business stakeholders across trading, risk, operations, and compliance.
• Translate business needs into clear, detailed functional and technical specifications for engineering teams.
• Analyze data from vendor feeds (e.g., Bloomberg, Refinitiv, ICE, SIX, S&P, exchanges) to define ingestion logic and transformation rules.
• Collaborate with data engineers and architects to support design and build of market data ingestion and distribution workflows.
• Support onboarding of new data domains, including pricing, reference data, corporate actions, and real-time/intraday feeds.
• Define and validate business rules for data cleansing, deduplication, and normalization.
• Maintain data dictionaries, business glossaries, and lineage documentation.
• Participate in and support UAT, working closely with QA and business users.

 What you’ll bring with You:

• 5+ years of experience as a Market Data Analyst or Business Analyst in financial services.
• Strong understanding of financial instruments: equities, fixed income, FX, derivatives.
• Deep knowledge of market data vendors and feeds: Bloomberg (BDP, BVAL), Refinitiv, ICE, SIX, exchange feeds, etc.
• Demonstrated experience producing high-quality functional specifications and data mapping documents.
• Proven ability to bridge the gap between business requirements and technical implementation.
• Python – for data analysis, transformation scripting, and validation logic.
• Snowflake – writing complex SQL queries, working with structured/semi-structured data, and supporting data workflows.
• SQL – advanced querying for data exploration and profiling.
• Familiarity with data formats and protocols: CSV, XML, JSON, FIX, FpML.
• Experience with API-based data access (e.g., Bloomberg API, Refinitiv Data Platform APIs).
• Use of collaboration tools such as JIRA, Confluence, and version control systems like Git.
• Experience with cloud platforms (AWS, Azure, or GCP) and working knowledge of cloud-native data services is a plus.
• Understanding of data quality, lineage, and governance tools is beneficial (e.g., Collibra, Alation)

Preferred Qualifications:

• Experience building or supporting a Market Data Hub, golden source, or enterprise reference data platform.
• Prior involvement in large-scale data architecture or data product initiatives.
• Bachelor’s or Master’s degree in Finance, Economics, Computer Science, Information Systems, or a related field.

Why Capco?

A career at Capco is a chance to help reshape the competitive landscape in financial services.  We launch new banks, transform existing ones, and help our clients navigate complex change.  As consultants, we work on the front-end business design all the way through to technology implementation.

We are the largest Financial Services focused consultancy in the world, serving everyone from global banks to emerging FinTechs, from strategy through digital transformation, design, business consulting, data and analytics, cyber, cloud, technology architecture, and engineering.

Capco is a young and growing firm. We maintain an entrepreneurial spirit and growth mindset and have minimal bureaucracy. We have no internal silos that get in the way of your career opportunities or ability to focus on our clients and make a difference to the business.  We offer the oppo