Domain Tracks/FinTech & Ledger Engineering
Aegis Global Payments Lakehouse50 ChallengesDouble-Entry & OLAP

FinTech & Ledger Engineering Track

Step into the role of a Quantitative Financial Systems Architect at Aegis Global Payments. Master double-entry balance sheets, multi-currency gateway settlements, real-time card fraud velocity models, BNPL loan DPD aging curves, and Basel III regulatory risk metrics on high-concurrency DuckDB OLAP.

Track Progress0 / 50
0% Complete50 remaining
Career Milestones & Badges0 / 5 Unlocked
🔒
Phase 1 (10Q)

Treasury Apprentice

10 to unlock
🔒
Phase 2 (20Q)

Settlements Specialist

20 to unlock
🔒
Phase 3 (30Q)

Financial Crime Analyst

30 to unlock
🔒
Phase 4 (40Q)

Credit Risk Quant

40 to unlock
🔒
Phase 5 (50Q)

Principal Financial Architect

50 to unlock
Phase 1Role: Junior Treasury & General Ledger Analyst

Double-Entry Accounting & Balances

Master general ledger chart of accounts, multi-currency balance auditing, zero-sum trial balance parity audits, and regulatory high-value transaction alerts using SELECT, GROUP BY, and double-entry rules.

0 / 10 Solved
0% Phase Progress
0%
#01

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#02

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#03

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#04

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#05

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#06

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#07

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#08

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#09

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#10

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
Phase 2Role: Settlements, Clearing & Processor Analyst

Gateway Settlement & Fee Reconciliations

Reconcile interchange-plus fee margins, gross-to-net merchant payouts, FX rate conversions, webhook drift anti-joins, and rolling reserve holdbacks.

0 / 10 Solved
0% Phase Progress
0%
#01

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#02

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#03

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#04

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#05

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#06

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#07

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#08

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#09

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#10

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
Phase 3Role: Fraud Analytics & Financial Crime Data Scientist

Card Fraud, Velocity & Chargebacks

Detect rapid card testing bots, impossible travel velocities, consecutive decline bursts, Visa/Mastercard ECMP dispute ratios, and card-to-user entity clusters.

0 / 10 Solved
0% Phase Progress
0%
#01

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#02

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#03

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#04

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#05

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#06

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#07

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#08

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#09

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#10

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
Phase 4Role: Credit Risk Quantitative Analyst & Portfolio Manager

Credit Risk, Delinquency & BNPL Modeling

Model loan portfolio Days Past Due (DPD) aging buckets (30/60/90+), roll-rate transition matrices, BNPL vintage default curves, CECL expected credit loss provisions, and merchant capital advances.

0 / 10 Solved
0% Phase Progress
0%
#01

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#02

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#03

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#04

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#05

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#06

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#07

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#08

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#09

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#10

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
Phase 5Role: Principal Financial Systems Architect & Head of Treasury

Basel III, Regulatory Capital & Treasury Analytics

Architect Basel III Liquidity Coverage Ratio (LCR) simulations, CET1 capital adequacy against RWA, Net Stable Funding Ratio (NSFR), IRRBB interest rate shocks, and consolidated executive CFO dashboards.

0 / 10 Solved
0% Phase Progress
0%
#01

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#02

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#03

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#04

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#05

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#06

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#07

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#08

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#09

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →
#10

Master enterprise FinTech queries on the Aegis Lakehouse.

Not StartedPractice →