ROLE

Data Product Manager at Capital Group

Lead the development and optimization of ETF data analytics infrastructure while managing a comprehensive suite of products worth $31 billion in AUM. Successfully integrated 9 distinct data sources while building robust ETL pipelines that enhanced market transparency and operational efficiency.

ETF Analytics Data Pipeline Management Python & SQL

867

Files Processed

24+

Internal Reports

Dashboards Created

Capital Group ETF Dashboard

Comprehensive insights into Capital Group's ETF product lineup and performance.

Capital Group's ETF Journey

Capital Group's entry into the ETF market represented a strategic expansion of its product lineup, combining the company's legacy of active management with the operational infrastructure required for ETF innovation.

Launch Timeline

Wave 1 - February 2022

Initial suite of six equity ETFs established Capital Group's ETF presence.

Wave 2 - October 2022

Expansion with fixed-income offerings including Multi-Sector ETF, Municipal Income ETF, and Short Duration ETF.

Wave 3 - September 2023

Added Dividend Growers ETF, International Equity ETF, Core Bond ETF, Core Balanced ETF, and Short Duration Municipal Income ETF.

Wave 4 - June 2024

Launch of Conservative Equity ETF, International Core Equity ETF, Global Equity ETF, New Geography Equity ETF, Short Duration High-Income ETF, and International Bond ETF.

ETF Growth

Over two years, Capital Group launched 21 ETFs, representing over $31 billion in sales.

Total ETF Products

21 New Product Line

Across equity and fixed income

Total Sales

$31B+ Growing

Since initial launch

Market Coverage

99.9% High Visibility

Trading activity captured

Data Latency

30s From 15min

Near real-time processing

ETF vs. Mutual Funds Comparison

Feature	ETFs	Mutual Funds
Trading	Intraday on exchanges	End-of-day at NAV
Pricing	Market price (may vary from NAV)	NAV calculated after market close
Transparency	Daily holdings disclosure (typically)	Quarterly holdings disclosure (typically)
Tax Efficiency	Generally more tax-efficient due to in-kind creation/redemption	Less tax-efficient due to cash transactions
Minimum Investment	One share	Varies (often $1,000+)
Data Infrastructure	Multiple third-party sources required	Centralized transfer agent data

ETF Product Portfolio

Capital Group's comprehensive suite of ETF offerings across equity and fixed income markets.

Wave 1 - February 2022

Equity

Core Equity ETF

CGUS

Launch

Feb 2022

A diversified portfolio of U.S. and international stocks with growth and income objectives.

$3.2B AUM

Equity

Dividend Value ETF

CGDV

Launch

Feb 2022

Focuses on companies with growing dividend payouts and stable earnings.

$4.8B AUM

Equity

Growth ETF

CGGR

Launch

Feb 2022

Focuses on companies with strong growth potential and innovative business models.

$2.9B AUM

Wave 2 - October 2022

Fixed Income

Municipal Income ETF

CGMU

Launch

Oct 2022

Tax-exempt income from high-quality municipal bonds.

$1.2B AUM

Fixed Income

Short Duration Income ETF

CGSD

Launch

Oct 2022

Lower-volatility fixed-income portfolio with shorter duration focus.

$1.18B AUM

Fixed Income

Multi-Sector Income ETF

CGMS

Launch

Oct 2022

Diversified fixed-income approach across multiple sectors for enhanced yield.

$1.96B AUM

Wave 3 - September 2023

Equity

Dividend Growers ETF

CGDG

Launch

Sep 2023

Focuses on companies with consistent dividend growth history.

$850M AUM

Equity

International Equity ETF

CGXU

Launch

Sep 2023

Diversified portfolio of international companies with growth potential.

$920M AUM

Fixed Income

Core Bond ETF

CGCB

Launch

Sep 2023

Core fixed income portfolio with broad market exposure.

$780M AUM

Balanced

Core Balanced ETF

CGBL

Launch

Sep 2023

Balanced allocation between stocks and bonds for moderate growth.

$690M AUM

Fixed Income

Short Duration Municipal Income ETF

CGSM

Launch

Sep 2023

Tax-exempt income from short-term municipal bonds.

$560M AUM

Wave 4 - June 2024

Equity

Conservative Equity ETF

Launch

Jun 2024

Lower-volatility equity portfolio focused on stable companies.

Equity

International Core Equity ETF

Launch

Jun 2024

Core international equity exposure across developed markets.

Equity

Global Equity ETF

Launch

Jun 2024

Comprehensive global equity exposure across all markets.

Equity

New Geography Equity ETF

Launch

Jun 2024

Focus on emerging markets and frontier economies.

Fixed Income

Short Duration High-Income ETF

Launch

Jun 2024

Short-term high-yield bonds for enhanced income.

Fixed Income

International Bond ETF

Launch

Jun 2024

Global fixed income exposure across international markets.

Primary Market Process

Understanding ETF creation and redemption mechanisms.

ETF Creation & Redemption Process

Creation Process

Authorized Participants (APs), often large financial institutions, work directly with the ETF issuer to create new ETF shares.

APs deliver a "creation basket," which consists of the securities underlying the ETF (or equivalent cash). In return, they receive an equivalent number of ETF shares at the net asset value (NAV).

Redemption Process

APs redeem ETF shares by returning them to the issuer. In exchange, they receive the underlying securities or cash at the NAV.

This mechanism ensures the ETF's supply matches market demand.

ETF Creation and Redemption Process Diagram

Interactive ETF Process

NAV Calculation

How NAV is Calculated

The Net Asset Value (NAV) represents the per-share value of the ETF and is calculated daily.


                                            NAV = (Total Assets - Total Liabilities) / Shares Outstanding

NAV vs. Market Price

ETFs can trade at a premium or discount to their NAV, though arbitrage mechanisms generally keep these differences small.

Secondary Market

How ETF shares are traded on exchanges between investors.

Secondary Market Trading

Retail and institutional investors buy and sell ETF shares in the secondary market through exchanges via brokers, similar to trading individual stocks.

Prices on the secondary market are determined by supply and demand, fluctuating throughout the trading day.

Unlike mutual funds, which settle at end-of-day net asset values (NAVs), ETFs require real-time price discovery mechanisms to maintain parity between market prices and underlying assets.

Arbitrage Mechanism

Role of APs and Market Makers

APs and market makers use arbitrage to ensure the ETF's market price aligns with the NAV.

If the ETF trades above its NAV, APs create shares to increase supply, lowering the price.
If it trades below, they redeem shares to decrease supply, raising the price.

This dual-market structure ensures liquidity, efficient pricing, and a seamless investment vehicle for a wide range of participants.

ETF Trading Volume by Venue

ETF trading activity occurs across multiple venues, requiring comprehensive data integration to achieve complete market transparency.

ETF Data Management

Comprehensive overview of ETF data infrastructure, challenges, and solutions.

Data Management Challenges

Fragmented Ecosystem

Data must be sourced from multiple providers, including exchanges, authorized participants, clearing houses, and fund accountants.

Intraday Trading

Unlike mutual funds, ETFs trade throughout the day, requiring real-time data processing capabilities.

Creation/Redemption Activity

Transactions between authorized participants and the fund require specialized tracking.

Market Price vs. NAV

Both metrics must be tracked and reconciled, with premium/discount analysis.

Volume Discovery

Secondary market trading happens across multiple venues, requiring consolidation.

No Transfer Agent

Unlike mutual funds, ETFs lack a centralized transfer agent for comprehensive data tracking.

Data Integration Architecture

Data Ingestion Layer

APIs and file-based integrations with multiple data providers.

Normalization Engine

Standardizes data formats from disparate sources.

Validation Framework

Multi-level checks ensuring data accuracy and completeness.

Master Data Management

Centralized repository of ETF reference data.

Analytics Layer

Provides insights and visualization capabilities.

Distribution Services

Delivers processed data to downstream consumers.

ETF Data Sources

Data Source	Frequency	Primary Use	Coverage
Broadridge	Monthly	Trade Matching, Asset reporting, Market Intel	95% of Capital Group ETFs
State Street (NAV)	Daily	Accounting, Asset reporting	100% of Capital Group ETF AUM
State Street (UCF)	Daily	Accounting, Market Demand Analysis	100% of CG ETF Shares Creation/Outstanding
Fidelity	Daily	Detailed transaction analysis	Fidelity Platform only

Case Study: Achieving 99.9% Market Transparency

Challenge

With the launch of Capital Group's first ETFs in February 2022, the firm needed comprehensive visibility into trading activity across all market venues. Unlike mutual funds, which trade once daily at NAV, ETFs trade continuously throughout the day across multiple exchanges and alternative trading systems (ATS).

Solution

Established direct feeds from major exchanges (NYSE, NASDAQ, CBOE)
Integrated with consolidated tape providers for comprehensive market coverage
Developed a custom reconciliation engine to identify and resolve data discrepancies
Built a real-time dashboard for monitoring trading activity across venues

Results

Achieved 99.9% visibility into all ETF trading activity across market venues
Reduced data latency from 15 minutes to near real-time (30 seconds)
Identified and addressed data gaps in dark pool and ATS reporting
Enabled comprehensive trading analytics for the investment team

Asset Allocation by Fund Type

Total ETF AUM

$14.89B

Number of ETFs