SQL Developer

Job Level: Vice President

Job Function: Business Operations

Location:

Charlotte, NC, US, 28202

Employment Type: Full Time

Requisition ID: 6189

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 $137,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 Description

A highly skilled and detail-oriented Data Engineer / SQL Developer responsible for designing, developing, and maintaining robust data pipelines and SQL-based solutions that support business intelligence, analytics, and operational reporting.
The ideal candidate will have deep expertise in SQL development, data modeling, and ETL processes, with a strong understanding of data warehousing and cloud-based data platforms.

Role Objectives: Delivery

Collaborate with IT and business teams to plan and implement production deployments of software, reports, and configuration changes.
Provide high-quality systems support to operations and finance teams, ensuring efficient and accurate usage of internally developed tools and reports.
Assist the Leasing Finance back-office team with configuration changes to the core lease/loan accounting system.
Deliver projects on time and within budget, adhering to project plans and timelines.
Develop and maintain tools to improve data quality across Leasing Finance systems and ensure accuracy in downstream data feeds and processes.
Respond promptly to data quality issues and reporting requests from internal stakeholders.
Oversee support teams responding to day-to-day technical issues and manage the incident response to service outages.
Analyze impact of reported service issues and quickly develop remediation plans.
Implement deployment of application code changes and upgrades to both testing and production environments.
Create and manage reporting tools, log collection and maintenance scripts to ensure seamless operation of application, proactive issue identification and data extraction.

Role Objectives: Interpersonal

Partner with business team leads to gain insight into user needs and develop a plan to improve the utility of implemented applications.
Advise the development team of business unit needs and advise on the creation of a roadmap for new processes and features.
Engage with key application users to study key business processes, and advise on building procedures to best utilize application features.
Conduct periodic meetings of support staff to discuss incident patterns and identify new policies and procedures to improve utility or reliability of applications.
Excellent Verbal and written Communication Skills
String Analytical and problem-solving skills
Ability to manage multiple projects and priorities effectively
Collaborative mindset and ability to work in a team-oriented environment

Role Objectives: Expertise

Exhibit mastery with Querying and reporting tools, incident management and issue analysis to improve support procedures and methods.
Display comprehensive knowledge of back-end query tools, ETL and scripting languages to support monitoring and proactive issue identification.
Possess required knowledge of application development languages like python to enable real-time debugging of application issues and troubleshooting of code.
Show ability to provide counsel to business units in planning and implementation of business applications.

Qualifications and Skills

Technical Skills

Strong expertise in MS SQL Server: advanced querying, stored procedures, performance tuning, and data modeling.
Proficient in Python for data processing, automation, and scripting.
Solid understanding of ETL development, maintenance, and optimization.
Experience with Data Warehousing concepts, including Star Schema, Fact and Dimension tables.
Familiarity with data governance, data quality frameworks, and compliance best practices.
Experience with cloud-based data platforms such as Azure SQL Data Warehouse, Azure Data Factory
Knowledge of Azure Fundamentals and cloud-native data engineering practices.
Familiarity with version control systems (e.g., Git) and CI/CD pipelines using Azure DevOps is a plus.
Exposure to data visualization tools (e.g., Power BI, Tableau) is an advantage.

Additional Requirements

Preferred Qualifications

Bachelor’s or master’s degree in computer science, Data Engineering, Information Systems, or related field.
At least 7 years of experience in data analysis, SQL development
Microsoft certifications (e.g., Azure Data Engineer Associate, Azure Fundamentals) are a plus.

Domain Knowledge

- Experience in Lending and Leasing is required.

Business & Analytical Skills

Ability to gather, analyze, and translate business requirements into scalable data solutions.
Understanding of basic accounting principles and financial systems.
Strong experience in regulatory reporting within the finance domain.
Knowledge of database normalization, data integrity, and metadata management.

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.