Under the direction of the Manager, this position designs/develops, prototypes, tests, and documents existing and new ETL processes while supporting and maintaining existing ETL/Data integration jobs. Also, assists in business unitâ€™s compliance with applicable laws, regulations, regulatory requirements and Bank policies and procedures, including but not limited to those related to Fair Banking, Anti-Money Laundering laws and regulations, Bank Secrecy Act and USA PATRIOT Act.
Designs, develops, and tests technical solutions while ensuring they meet end user requirements.
Leads design, code and configuration reviews.
Investigates, analyzes, and understands data contents of source data systems.
Analyzes reviews and rewrites programs and systems to increase operating efficiency or to adapt program to new requirements either internally or through a contracted vendor.
Ensures system application, configuration, and/or program code produced individually, by vendors or staff members adheres to the Bankâ€™s standards and applicability to business requirements.
Provides logic, screen flows, and diagrams depicting data integration and flows from technical specifications.
Develops and maintains documentation of all technical development and subsequent revisions.
Reuses existing components in new designs and develops new code for reuse.
Maintains and enhances third-party software.
Leads the planning and execution of systems installations and upgrades, including security and program configuration and maintenance for ETL tools in production, development, test and disaster recovery environments.
Supports the production environment; logs and tracks problems; responds to questions and support requests and ensures the production environment meets established service levels.
Leads and ensures appropriate analysis of problems, initiates corrective actions through resolution, takes steps to improve production support, implements preventative measures and ensures status updates are provided to those impacted.
Facilitates meetings with technical staff to address issues.
Performs regular problem follow-up according to procedures and confirms resolution prior to closing the problem reports.
Maintains knowledge of products and services supported. Understands dependencies and timing issues between source systems and data warehouse operations.
Ensure system performance levels are monitored and develops the appropriate alerting and reporting processes as appropriate.
Implements program/system updates and enhancements, in accordance with corporate policies and Information Management and Systems Group (IMSG) standards and manages system updates to ensure that processes are in place such that similar updates are applied to the underlying infrastructure and associated interfaces.
Maintains documentation of IT procedures, system configuration standards, maintenance, and upgrades and follows risk management guidelines and procedures.
Ensures compliance with applicable BOH policies.
Leads systems and/or process analysis and design to meet functional and organizational requirements, individually and/or through assigned staff.
Provides input and recommends alternatives while costing, estimating, or validating solutions, individually and/or through assigned staff.
Incorporates Bank of Hawaii Information security policies and procedures into all system designs.
Incorporates the reuse of existing components within designs where feasible and efficient.
Aligns systems designs with Bank of Hawaiiâ€™s business and technical strategies.
Participates in continuous review to ensure that systems meet changing business and regulatory conditions.
Manages full systems life cycles which include hardware or software replacement and redesign.
Directs and performs testing activities and recommends business testing requirements.
Leads design and pre-implementation walkthroughs and ensures test results are documented and approvals are received prior to implementation.
Ensures development and validity of disaster recovery plans.
Defines interface requirements and methodology.
Develops test plans that incorporate Corporate Testing Standards and may guide junior staff in the use of industry standards.
Provides guidance on the development of appropriate testing activities for junior staff.
Educates users on systems and processes and acts as and IT consultant. Provides cross training with other team members to maintain effective back up.
Provides technical leadership, assistance, and review of work for junior and peer staff members and vendors along with appropriate staff mentoring and coaching to foster a strong team atmosphere.
May assist with the leadership of a team, including staffing, scheduling, performance management, and development.
Leads and participates in team events and projects.
Responsible for their own learning; takes the initiative to become educated and knowledgeable on topics that pertain to technology, banking industry, and their job.
Leads the development of Request for Information (RFIs), Request for Proposal (RFPs), and business cases. Leads and/or participates in evaluation of vendor proposals and performance, taking into account corporate strategy and IT architecture standards. Assesses vendor solution options, identifying risks, cost/benefits, and on-going support considerations.
Understands contractual agreements and holds vendors accountable to the terms of the agreement. Leads and/or participates in contractual negotiations and recommends appropriate changes based on corporate IT standards and support requirements.
Manages vendors in order to deliver agreed-upon service levels and delivery commitments related to systems performance. Directs vendors in configuring vendor delivered products and services in order to adhere to defined technical specifications, and works with vendors to identify opportunities for innovation, cost reduction, and improved functionality and efficiencies. Manages resolution of issues and concerns with vendor performance especially when there is impact to production and project deliverables.
Performs other job-related duties as assigned.
This position requires use of a personal computer and other standard office equipment (fax, copier, calculator, telephone).
Bachelorâ€™s degree from an accredited institution in information systems, computer science, engineering, or related field or equivalent work experience.
Level I requires
minimum 6 years of work experience in increasingly responsible IT positions; 3 or more years of experience using ETL tools such as IBM Data Stage.
Level II requires minimum of 8 years of work experience in increasingly responsible IT positions; 5 or more years of experience using ETL tools such as IBM Data Stage.
Level III requires minimum of 10 years of work experience in increasingly responsible IT positions; 7 or more years of experience using ETL tools such as IBM Data Stage.
Banking/financial industry or related field preferred.
Working knowledge of System Development Life Cycle (SDLC) or with Relational Database Management Systems (RDBMS)
Expertise with Structured Query Language (SQL)
Expertise with data warehousing (Star/Snowflake schema) or data vault concepts
Proven ETL/Data Integration experience using the following: IBM Data Stage, Shell scripting, Oracle PL/SQL, and Microsoft SSIS
Experience with ETL tool installation / upgrade and ETL job migration
Background with Financial Services data preferred.
Other Job Qualifications
Banking/financial industry or related field experience preferred. Ability to analyze business requirements and develop solutions with minimal oversight. Quick learner, and ability to multi-task, prioritize, and execute on assigned deliverables. Good oral and written communication, analytical, and problem-solving skills. Good interpersonal skills and collaborative style to include team-working ability. Able to work flexible hours including holidays, weekends and evenings as needed or assigned.
As a Bank of Hawaii employee, you ensure (or assist with ensuring) compliance with applicable laws, regulations, regulatory requirements and Bank policies and procedures, including but not limited to those related to Fair Banking, Anti-Money Laundering laws and regulations, Bank Secrecy Act and USA PATRIOT Act. Delivering exceptional customer experiences is at the heart of what we do at Bank of Hawaii. We listen, understand and deliver what our customers need to help them build a better tomorrow.
We are committed to fully complying in letter and in spirit with all Equal Opportunity Employment and Affirmative Action laws and regulations. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, including gender identity or expression, sexual orientation, national origin, citizenship, ancestry, age, marital status, genetic information, domestic or sexual violence victim status, disability, protected veteran status or any other status protected by federal, state or local law. We also foster a drug-free work environment.