Fintech Engineer

Purpose

When to Use

• Designing double-entry ledger systems or accounting databases
• Implementing high-precision financial calculations (avoiding floating-point errors)
• Building payment processing pipelines
• Ensuring PCI-DSS or SOX compliance
• Integrating with banking APIs (Plaid, Stripe, etc.)
• Handling currency conversions and multi-currency systems
• Implementing audit trails for financial transactions
• Designing reconciliation systems

Quick Start

• Building ledger or accounting systems
• Implementing financial calculations requiring precision
• Designing payment processing architectures
• Ensuring regulatory compliance (PCI, SOX, PSD2)
• Integrating banking or payment APIs

• General database design without financial context → use

  /database-administrator

• API integration without financial specifics → use

  /api-designer

• Generic security hardening → use

  /security-engineer

• ML-based fraud detection models → use

  /ml-engineer

Decision Framework

Financial Calculation Needed?
├── Yes: Currency/Money
│   └── Use decimal types (never float)
│   └── Store amounts in smallest unit (cents)
├── Yes: Interest/Rates
│   └── Use arbitrary precision libraries
│   └── Document rounding rules explicitly
└── Ledger Design?
    ├── Simple: Single-entry (tracking only)
    └── Auditable: Double-entry (debits = credits)

Core Workflows

1. Double-Entry Ledger Implementation

1. Define chart of accounts (assets, liabilities, equity, revenue, expenses)
2. Create journal entry table with debit/credit columns
3. Implement balance validation (sum of debits = sum of credits)
4. Add audit trail with immutable transaction logs
5. Build reconciliation queries

2. Payment Processing Pipeline

1. Validate payment request and idempotency key
2. Create pending transaction record
3. Call payment processor with retry logic
4. Handle webhook for async confirmation
5. Update ledger entries atomically
6. Generate receipt and audit log

3. Precision Calculation Setup

1. Choose appropriate numeric type (DECIMAL, NUMERIC, BigDecimal)
2. Define scale (decimal places) based on currency
3. Implement rounding rules per jurisdiction
4. Create calculation helper functions
5. Add validation for overflow/underflow

Best Practices

• Store monetary values as integers in smallest unit (cents, paise)
• Use DECIMAL/NUMERIC database types, never FLOAT
• Implement idempotency for all financial operations
• Maintain immutable audit logs for every transaction
• Use database transactions for multi-table updates
• Document rounding rules and apply consistently

Anti-Patterns