Associate ETL Developer

Position Function:

The ETL Developer designs, develops and maintains the process of extracting data from source systems and load them into the enterprise data warehouse. This position requires a good understanding of applications systems used at the Bank and strong data modelling knowledge. The ETL developer performs data analysis, requirement gathering, design, development, testing and debugging of ETL codes.

Works independently or as a team on data related initiatives of considerable complexity and scope. Able to simultaneously work on multiple tasks and objectives and when necessary, work on weekends and evenings in order to meet tight deadlines. Fully understands the EDW standard methodologies, architecture, technology and security needs to develop and maintain the EDW system.

Performs all duties and interacts with internal and external customers in a manner that is expressly aligned with the Company's Core Values of approaching all actions with a Voyaging Spirit and being Positively Ohana . Exhibits core competencies that result in consistent delivery of positive Customer Interactions, Empowerment and Ownership and demonstrates key professional and performance skills such as Active Listening, effective Oral and Written Communication, Action and Solution Oriented and Thoroughness.

Primary Accountabilities:

Design and Development

Work with business users and EDW team members to analyze source system data and their criticality to the enterprise information needs

Conduct detailed analysis and validation to ensure business requirements are met

Develop data mapping documents to accurately capture source data format and define transformation rules when necessary

Work with EDW Architect to ensure new or updated data sources are logically integrated to the EDW data model

Develop, enhance, debug, test and maintain ETL jobs and sequencers

Develop system test plan for ETL jobs and sequencers

Maintain comprehensive design documentation and issue tracking

Assess source system version changes and their impact on EDW and update the ETL jobs and sequencer accordingly

Production Support

Perform data validation during test and production phases

Maintain proper change control across production and non-production environments

Support peers and stakeholders as subject matter expert by providing documentation, training and problem solving as needed

Monitor and remediate system and application performance as needed

Provide ad hoc data analysis and reporting services as needed

Data Governance

Identify, monitor and remediate data quality issues as part of enterprise data governance

Work with EDW Architect on development of data lineage, business glossary and other tasks relating to metadata management

Other Duties

Maintain technical and business competency through continuing education and self-improvement

Provide backup support for other EDW staff while away on business or out of the office

Any other duties as assigned by management

Minimum Qualifications:

Education:

Bachelor's Degree in in computer science preferred

Experience:

4+ years of experience in database design, development, reporting, control and administration, application programming, systems analysis, technical project management or equivalent required

4+ years of experience in banking preferred.

Physical Requirements & Working Conditions:

Must be able to perform light physical work and to move or lift items including but not limited to boxes, files and papers up to 20 pounds unless otherwise as indicated.

Must be able to operate and proficiently use standard office equipment, including phone, copier, personal computer and/or other work related mechanical or electronic devices and applications.

Must be able to clearly communicate verbally and in writing with all internal and external customers. Must also be able to hear sufficiently to engage in daily discussions and interactions.

Must be able to read and understand bank-related documents.

Must be able to work in a conventional office setting, involving sitting at a desk or workstation for long periods of time. Must also be able to adapt to different work environments as needed to perform the job.