Discover your dream Career
For Recruiters

Senior Data Modeler - Capital Markets

Sumitomo Mitsui Financial Group, Inc. New York, United States
Posted 19 hours ago Permanent $202k - $237k

Senior Data Modeler - Capital Markets

Sumitomo Mitsui Financial Group, Inc. New York, United States
Senior Data Modeler - Capital Markets
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 accommodations@smbcgroup.com.
Job ID  7694
More jobs From Sumitomo Mitsui Financial Group, Inc.
Senior AI/ML Data Engineer - Vice President
Sumitomo Mitsui Financial Group, Inc.
New York, United States
2 days ago Full time $145k - $196k
Cash Management Sales - Director
Sumitomo Mitsui Financial Group, Inc.
New York, United States
18 hours ago Full time $152k - $200k
Application Support - Capital Markets
Sumitomo Mitsui Financial Group, Inc.
Hoboken, United States
2 days ago Full time $95k - $156k
Total Rewards Project Manager - 12-24 Month Project
Sumitomo Mitsui Financial Group, Inc.
New York, United States
3 days ago Full time $114k - $170k
Associate, Credit Portfolio Management, TMT
Sumitomo Mitsui Financial Group, Inc.
New York, United States
3 days ago Full time $150k - $175k
Vice President, Business Manager
Sumitomo Mitsui Financial Group, Inc.
New York, United States
3 days ago Full time $170k - $175k
Performance and Promotion Specialist - 12-24 Month Project
Sumitomo Mitsui Financial Group, Inc.
New York, United States
7 days ago Full time $130k - $173k
Vice President, Market Risk Data & Product Management Team - Programming Language Expert
Sumitomo Mitsui Financial Group, Inc.
New York, United States
13 days ago Full time $155k - $195k
Vice President, Counterparty Credit Risk - Strategic Initiatives
Sumitomo Mitsui Financial Group, Inc.
New York, United States
13 days ago Full time $138k - $185k
Team Lead
Sumitomo Mitsui Financial Group, Inc.
Hoboken, United States
13 days ago Full time $190k - $196k

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
More Jobs Like This
Senior AI/ML Data Engineer - Vice President
Sumitomo Mitsui Financial Group, Inc.
New York, United States
Cash Management Sales - Director
Sumitomo Mitsui Financial Group, Inc.
New York, United States
Application Support - Capital Markets
Sumitomo Mitsui Financial Group, Inc.
Hoboken, United States