Senior Data Design Analyst

Job Level: Vice President

Job Function: Data Design

Location:

Jersey City, NJ, US, 07311

Employment Type: Full Time

Requisition ID: 4028

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 $142,000.00 and $196,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 Objectives: Delivery

We are seeking a skilled and experienced Senior Data Design Analyst to join our team. The ideal candidate will play a key role in designing and optimizing data models for our data warehouse, ensuring data integrity, scalability, and performance. You will work closely with cross-functional teams, including data engineers, business analysts, and architects, to develop efficient data models that meet business and technical requirements.

Design, implement, and optimize data models for the data warehouse, ensuring alignment with business requirements.
Work extensively with **IBM IDA (InfoSphere Data Architect)** to create logical and physical data models.
Ensure that the data models are scalable, performant, and aligned with the organization’s data strategy.
Collaborate with data engineers to implement and maintain data models in **Azure** and **Databricks** environments.
Translate business requirements into conceptual, logical, and physical data models, ensuring data quality and consistency across systems.
Participate in data architecture and design discussions to ensure data modeling best practices are followed.
Develop and maintain documentation of data models, data flow diagrams, and database design specifications.
Work with stakeholders to ensure the data models support analytics, reporting, and data integration needs.
Perform impact analysis of changes to existing models and collaborate with teams to assess the effects on downstream systems.
Continuously improve and optimize data models to enhance performance and data accessibility.

Qualifications and Skills

Bachelor’s degree in Computer Science, Information Systems, or a related field.
Proven experience as a **Data Modeler** working in data warehouse environments.
Strong expertise with **IBM IDA (InfoSphere Data Architect)** or similar data modeling tools.
Solid understanding of **Azure** and **Databricks** architecture, and experience working in cloud-based data environments.
Proficiency in relational and dimensional data modeling techniques, including star and snowflake schemas.
Hands-on experience with SQL and database design, with knowledge of data lakes, data warehouses, and ETL processes.
Strong analytical and problem-solving skills, with attention to detail.
Ability to communicate complex technical concepts to both technical and non-technical stakeholders.
Familiarity with data governance, metadata management, and data quality practices.

**Preferred Qualifications:**

Experience with **Azure Synapse**, **Azure Data Factory**, and **Databricks Delta Lake**.
Knowledge of big data technologies and principles of data lakehouse architectures.
Experience in agile methodologies and working in a fast-paced, collaborative environment.

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.