Senior Data Modeler - Capital Markets

Senior Data Modeler - Capital Markets

Job Level: Director Job Function: Data Design Location: New York, NY, US Employment Type: Full Time

SMBC Group is a top-tier global financial group. Headquartered in Tokyo and with a 400-year history, SMBC Group offers a diverse range of financial services, including banking, leasing, securities, credit cards, and consumer finance. The Group has more than 130 offices and 80,000 employees worldwide in nearly 40 countries. Sumitomo Mitsui Financial Group, Inc. (SMFG) is the holding company of SMBC Group, which is one of the three largest banking groups in Japan. SMFG's shares trade on the Tokyo, Nagoya, and New York (NYSE: SMFG) stock exchanges. In the Americas, SMBC Group has a presence in the US, Canada, Mexico, Brazil, Chile, Colombia, and Peru. Backed by the capital strength of SMBC Group and the value of its relationships in Asia, the Group offers a range of commercial and investment banking services to its corporate, institutional, and municipal clients. It connects a diverse client base to local markets and the organization's extensive global network. The Group's operating companies in the Americas include Sumitomo Mitsui Banking Corp. (SMBC), SMBC Nikko Securities America, Inc., SMBC Capital Markets, Inc., SMBC MANUBANK, JRI America, Inc., SMBC Leasing and Finance, Inc., Banco Sumitomo Mitsui Brasileiro S.A., and Sumitomo Mitsui Finance and Leasing Co., Ltd.

The anticipated salary range for this role is between $202,000.00 and $237,000.00. The specific salary offered to an applicant will be based on their individual qualifications, experiences, and an analysis of the current compensation paid in their geography and the market for similar roles at the time of hire. The role may also be eligible for an annual discretionary incentive award. In addition to cash compensation, SMBC offers a competitive portfolio of benefits to its employees.

Role Description We are seeking a highly specialized Senior Capital Markets Data Modeler to spearhead the standardization, design, and governance of our global transaction data structures across Front, Middle, and Back-Office (FOMOBO) platforms. In this role, you will bridge the gap between complex quantitative trading concepts and real-time data engineering pipelines. Your primary mandate will be to translate complex trade lifecycles—spanning execution, valuations, and downstream clearing/settlements—into modern, event-driven data schemas. By leveraging standard financial messaging protocols alongside cutting-edge lakehouse tools, you will design the data backbone supporting high-velocity stream processing frameworks.

Role Objectives

• Design End-to-End Trading Data Models: Create and maintain conceptual, logical, and physical data models capturing end-to-end multi-asset trade lifecycles across Front Office (execution/pricing), Middle Office (risk/valuations), and Back Office (settlements/reconciliations).
• Implement Financial Standards (FpML & ISDA CDM): Serve as the Subject Matter Expert on FpML (Financial Product Markup Language) and the FINOS / ISDA Common Domain Model (CDM) to unify derivatives messaging and post-trade lifecycle state transitions across the enterprise.
• Architect Event-Driven Schema Frameworks: Design highly performant, version-controlled streaming schemas (JSON Schema, Avro, or Protobuf) optimized for continuous pub/sub and event-sourcing architectural flows.
• Optimize Databricks Lakehouse Structures: Partner with data engineers to materialize real-time event payloads into highly scalable Databricks Delta Lake tables using Medallion patterns (Bronze/Silver/Gold) optimized for time-series analytics and query performance.
• Integrate Trade Workflow Engines: Model data interactions for stateful, orchestration-driven Trade Workflow Engines, ensuring exact tracking of trade status updates, validation overrides, and audit trails.
• Enforce Data Lineage & Interoperability: Build comprehensive, automated data dictionaries and lineage mappings to ensure upstream trading desk schemas seamlessly reconcile with downstream regulatory reporting nodes.

Qualifications and Skills

• Domain Expertise: 7+ years of experience as a specialized Data Modeler in an Investment Bank, Tier-1 Capital Markets Broker-Dealer, or Clearing House spanning Front, Middle, and Back Office operations.

• Financial Modeling Protocols: Proven track record of direct, production-level implementation of ISDA CDM (Common Domain Model) and FpML frameworks for Over-The-Counter (OTC) derivatives, fixed income, or foreign exchange (FX) asset classes.

• Technological Tooling: o Minimum 3+ years designing data structures specifically optimized for processing on the Databricks Unified Data Analytics Platform. o Mastery of schema modeling tools (such as ERwin, InfoSphere Data Architect, Hackolade, or Idera ER/Studio).

• Distributed Streaming Patterns: Extensive knowledge of asynchronous message queue behaviors, schema evolution strategies (backward/forward compatibility), and stream-processing database normalization tradeoffs.

• Trade Lifecycle Literacy: In-depth understanding of trade state mechanics handled by execution and workflow engines, such as allocation rules, novations, compression exercises, and margin calculations.

Preferred Technical Additions • Working knowledge of SQL, Python, or Scala for testing, validating, and querying live Delta tables inside Databricks. • Prior involvement with industry bodies like FINOS, ISDA, or FIX Trading Community. • Familiarity with financial messaging formats like FIX Protocol or ISO 20022.

Additional Requirements SMBC's employees participate in a Hybrid workforce model that provides employees with an opportunity to work from home, as well as, from an SMBC office. SMBC requires that employees live within a reasonable commuting distance of their office location. Prospective candidates will learn more about their specific hybrid work schedule during their interview process. Hybrid work may not be permitted for certain roles, including, for example, certain FINRA-registered roles for which in-office attendance for the entire workweek is required. SMBC provides reasonable accommodations during candidacy for applicants with disabilities consistent with applicable federal, state, and local law. If you need a reasonable accommodation during the application process, please let us know at View email address on click.appcast.io.