Sign In
 [New User? Sign Up]
Mobile Version

ETL Developer (Data & ETL Administration)

Bank of Hawaii

Oahu, HI
Job Code:
  • Financial Services
Bank of Hawaii
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

ETL Developer (Data & ETL Administration)-1700817

Bank of Hawaii
In 1897, Bank of Hawaii was the first chartered and incorporated bank in the Republic of Hawaii. We’ve been here from territorial days, growing and changing with Hawaii. Today, we are the largest independent bank in Hawaii – a result of knowing our business and community, and always staying ahead of change. At Bank of Hawaii, we think of ourselves as forward thinking pace setters. We are constantly finding creative ways to deliver leading edge financial services to our customers.  Now, we’re embracing change with our new 21st century banking.
It’s our IT team who helps us succeed in offering first class service in new and innovative ways.  As a member of the Information Technology community, you will be among the very best in your profession in an environment that places a high value on integrity, innovation and teamwork.  It motivates us to be decisive, work together to solve problems, and never settle for less than best.
Does this sound like you?
Are you ambitious?  Want to make a difference in how your company operates? Are you a change leader?  Do you thrive in an environment that leverages your abilities as a technology champion?  Are you a self-starter and a forward thinker?  If you love challenges, relish complexity, and have moxie, consider applying your unique talents with a Hawaii banking leader – Bank of Hawaii.  Here you can be at the forefront of whatever you do. Welcome to your tomorrow!
A day in your life as an ETL Developer
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.
We’ll give you these important responsibilities…
  • 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.
    Production Maintenance
  • 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.
    Systems Analysis
  • 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.
    Vendor Management 
  • 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.

…if you come to us with these qualifications…
  • Bachelor’s degree from an accredited institution in information systems, computer science, engineering, or related field or equivalent work experience
  • 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.
  • 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
  • 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
All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of any legally protected classification including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or protected veteran status.  Bank of Hawaii takes affirmative action in support of its policy to advance in employment legally recognized individuals including minorities, women, protected veterans and individuals with disabilities.
Job Function Information Technology
Primary Location Hawaii-Oahu
Schedule Full-time
Job Posting Sep 27, 2017, 12:53:20 PM
Unposting Date Ongoing
Powered By

Featured Jobs [ View All ]