Job Information
SMBC ETL Team Lead in Jersey City, New Jersey
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 Rail Services LLC, Manufacturers Bank, 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 $174,000.00 and $226,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
The ETL Team Lead is responsible for oversight and daily management of both cross-functional and internal projects that involve designing and building enterprise data assets (including data warehouses and data marts) for the bank as well as operational discipline for execution.
This individual will oversee the IT team responsible for Design & Development of Data Integration Services (ETL) supporting difference components of SMBC Data Warehouse. The Business stakeholders include the Information Control Department (Chief Data Officer), Finance Controllers and Risk Management as well as other internal customers. The preferred candidate will demonstrate passion and expertise for leading strategic initiatives to standardize data and enable business analytic capabilities (including but not limited to required Risk & Regulatory Reporting for the Bank) as well as day-to-day operational execution responsibilities. As a Senior level contributor, must demonstrate strong communication and relationship building competencies. Strong Program and project management skills also a key skill requirement. The position currently has 4 direct reports.
The ETL Team Lead reports to the Director of Data Management Design and Development within the Corporate Systems department.
Role Objectives
Reviews all system development project requests and coordinates related team activities; meets with business stakeholders and other technical teams to gather and analyze requirements.
Provides technical and thought leadership around the enterprise data warehouse, data architecture and integration, and can guide the team in terms of exploring new and emerging data stores.
Develop and implement tactical plans and strategic objectives for the data management department in an effective and innovative fashion.
Apply strong Program/ Project Management skills turn the strategic vision into an actional project and drive the project to conclusion.
Provides high level technical support to IT partners troubleshooting and providing fixes where required.
Provides written reports to management regarding project status, tasks, and issues/risks.
Participates in build related activity discussions, environment setup implementation schedule/changes promoted in the test environment.
Actively participates in planning sessions and meetings, interfaces regularly with senior level counter parts across multiple business units.
Maintains effective relationships with vendors and suppliers; resolves issues and maintains ongoing communication.
Participates in the planning, implementation, testing and documentation of Technology Recovery Plans to support continuity objectives as defined by business and service managers.
Partners with CDO/CDA to create plan and executes the strategic Data Roadmap for the Bank. This includes standards and governance requirements for managing the environment in a strategic and consistent fashion.
Looks for continuous improvement opportunities through automation and simplification of all current activities.
Ensures team member activities comply and are aligned with all strategic directives; provides guidance to more junior employees and serves as a team lead.
Provides managerial direction and oversight to a multi-disciplinary team.
Oversee and coordinate daily operations including day to day operation of the Centralized Data Warehouse
Arranges proper support, coverage and staffing plans for all implementation activities and organization commitments.
Direct data management department staffing needs (e.g., interviewing, hiring, new hire and ongoing training, annual evaluations, etc.)
Participate in budget planning, initiation and monitoring of expenses.
Assess and report progress in meeting data management department objectives.
Continuingly assess and improve the team structure within Data Management whilst ensuring it aligns with immediate tactical and long-term strategic goals.
Participates in Disaster Recovery (DR) exercises and ensures the DR environment is set up and configured properly.
Qualifications and Skills
Expert knowledge of enterprise data warehouse, data governance, data architecture and integration and emerging data stores and technologies.
Hands on management experience of complex systems and applications.
Adept at project management including prior experience with system implementations, programming, integration, conversion, and testing.
Functional experience with data warehouse and BI tools. Technologies include Oracle DBMS, IBM Infosphere (Data Stage, Quality Stage, Information Analyzer), IBM Information Governance Center, scripting languages, Data Modelling tools (ERWIN), Azure Cloud tools.
Direct experience with data governance tooling. Experience with Collibra or Informatica a plus.
High level customer service mindset with a commitment to supporting both internal and external stakeholders.
Detail oriented with excellent problem-solving abilities and abilities to perform under pressure in a challenging environment.
Forward thinker who seeks to improve business processes that deliver better services.
Excellent verbal and written communication skills with ability to articulate concepts and ideas to diverse audiences.
Excellent mentoring and management proficiency with demonstrated ability to delegate, influence and manage expectations as well as team performance.
Additional Requirements
D&I Commitment
Responsible for fostering a culture of diversity and inclusion, holding leaders accountable for creating an inclusive environment through awareness and practice of equity in recruiting, developing, and promoting diverse talent.
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.
We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law. SMBC provides reasonable accommodations for employees and applicants with disabilities consistent with applicable law. If you need a reasonable accommodation during the application process, please let us know at accommodations@smbcgroup.com.