Data Engineer - Capital Markets

SMBC Group is a top-tier global financial group headquartered in Tokyo with a 400-year history, offering a diverse range of financial services including banking, leasing, securities, credit cards, and consumer finance. The Group operates over 130 offices and employs 80,000 people across nearly 40 countries. In the Americas, SMBC Group provides commercial and investment banking services to corporate, institutional, and municipal clients, connecting them to local markets and a global network.

About the role

We are seeking a Senior Databricks Engineer with deep AWS expertise to build, optimize, and maintain our enterprise data Lakehouse infrastructure. In this role, you will design high-performance data pipelines, implement regulatory and real-time reporting along with advanced analytics environments, and ensure seamless integration between Databricks and core AWS services to support real-time financial trading data consumption.

Responsibilities

• Design and implement robust data pipelines using the Databricks Medallion Architecture (Bronze, Silver, Gold layers) to process structured and unstructured data.
• Develop, scale, and orchestrate complex data workflows utilizing Databricks Jobs and Delta Live Tables (DLT).
• Standardize and automate the deployment of Databricks assets, workspace configurations, and code pipelines across Dev, QA, and Production environments.
• Ensure seamless data cataloging, storage, and movement across the AWS ecosystem, specifically integrating Databricks with Amazon S3, AWS Glue, and AWS IAM for secure access control.
• Tune Spark clusters, optimize Delta Lake storage (e.g., Z-Ordering, partitioning), and manage compute costs within the AWS environment.
• Implement fine-grained data access controls, data lineage, and auditing using Unity Catalog or native cloud security controls.
• Partner with Data Scientists, Risk Managers, and downstream analytics teams to deliver clean, business-ready data views for reporting and AI modeling.

Requirements

• 4+ years of hands-on experience in architectural design and development within the Databricks platform, alongside 3+ years working in an AWS cloud environment.
• Proven proficiency in automated deployments using Databricks Asset Bundles (DABs), Terraform (specifically the Databricks and AWS providers), and standard Git pipelines (e.g., GitHub Actions, GitLab CI/CD, or AWS CodePipeline).
• Advanced programming skills in Python (PySpark) and SQL for complex data manipulation and transformation.
• Strong understanding of Apache Spark internals, Delta Lake mechanics, and streaming data concepts (e.g., interacting with Amazon MSK or Kafka data streams).
• Proven experience building production-grade ETL/ELT pipelines, handling data schema validation, and cleansing raw capture feeds.
• Databricks Certified Data Engineer Professional or AWS Certified Data Engineer – Professional certification is highly advantageous.

Additional Requirements

• Employees participate in a hybrid workforce model, requiring residence within a reasonable commuting distance of their office location.
• Hybrid work may not be permitted for certain roles, including FINRA-registered positions requiring full-time in-office attendance.
• Reasonable accommodations for applicants with disabilities are available during the application process.

Pay

The anticipated salary range for this role is between $97,000.00 and $156,000.00. The specific salary offered will be based on individual qualifications, experience, and geographic market conditions. The role may also be eligible for an annual discretionary incentive award.

Benefits

In addition to cash compensation, SMBC offers a competitive portfolio of benefits to its employees.