Bank of Hope

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

BI & DW Manager

at Bank of Hope

Posted: 10/2/2019
Job Status: Full Time
Job Reference #: 43a20b9e-b3d1-4783-95ff-a8cc54690698
Keywords:

Job Description

BI & Data Warehouse Manager is responsible for the overall strategy, delivery and support of business intelligence solutions for the enterprise. The role is focused on conception, delivery, maintenance and ongoing innovation of the Bank’s data warehouse, reporting, dashboards and analytics.

 

Position Information

Job Title: BI & Data Warehouse Manager

Department: Information Technology

FLSA Status: Exempt

Reports to:

Full/Part Time Status: Full

Work Location: Gardena

Travel Requirement:

 

Education/Experience Requirements

Minimum Education Level: Bachelor’s Degree

Minimum Years of Experience: 10

Combination of Experience and Education can meet the job requirements: Yes

 

Language Requirement

English: Written:   Advanced Verbal: Advanced

Korean: Written: None Verbal:   None

 

Computer/Systems Knowledge Requirements

Microsoft Outlook: Advanced

Microsoft Word: Advanced

Microsoft Excel: Advanced

Microsoft PowerPoint: Advanced

 

Responsibilities & Duties

·         Responsible for all strategic, tactical, operational, and technical resource managerial responsibilities associated with data preparation (sourcing, acquisition, integration), data warehousing, reporting, information delivery, data exploration, and analytics.

·         Enable internal business partners to make better, faster, bolder and more customer-focused decisions; to distill insights from data; and to use data as a competitive advantage and lever to improve our customer journey.

·         Drive development of cloud-based enterprise data warehouse and reporting with data integrity and data quality controls.

·         Hire and develop a high-performing business intelligence team.

·         Coach, supervise and mentor team members.

 

Job Qualifications/Requirements

·         Degree in computer science, mathematics, operations, management, or a related field

·         10 years of experience in building/supporting data warehouse

·         Extensive experience in data modeling, both logical and physical

·         Extensive experience in building and maintaining data-intensive systems and data warehouses using advanced SQL or ELT/ETL tools (including SSIS, Talend, Pentaho), OLTP, OLAP, and MDM, dimensional data modeling

·         Experience in Cloud Data Warehouse technologies such as AZURE Data Warehouse, AWS RedShift, Snowflake.

·         Solid understanding modern data warehouse technologies.

·         Understanding of dimensional modeling using Kimball methodology

·         Understanding of the Data Warehouse Data Vault methodology

·         Solid T-SQL knowledge and SQL query development using MS SQL 2008 and 2012

·         Solid understanding of information security principles and best practices

·         Experience in banking or financial services

·         Experience with agile development

·         Experience in reporting and dashboarding tools such as SSRS, Tableau, Power BI etc.

·         Excellent written, verbal communication and presentation skills

·         Experience leading large complex BI projects and teams

·         Proven ability to establish and articulate a vision, set goals, develop and execute strategies, and track and measure results

·         Proven ability to build and motivate a team to achieve well communicated expectations

 

Physical Demands

Lifting/Carrying:

Under 10lbs: Occasional (1%-33% of the time)

Under 20 lbs: Occasional (1%-33% of time)

Pushing/Pulling:

Under 20 lbs: Occasional (1%-33% of time)

Twisting/Turning:

Reach over shoulder: Rarely (Less than 1 hour per week)

Reach over head: Rarely (Less than 1 hour per week)

Reach Outward: Rarely (Less than 1 hour per week)

Climb: Rarely (Less than 1 hour per week)

Crawl: Rarely (Less than 1 hour per week)                                                                                                                     

Kneel: Rarely (Less than 1 hour per week)

Squat: Rarely (Less than 1 hour per week)

Sit: Constant (Over 66% of time)

Walk-Normal Surfaces: Frequent (34%-66% of time)

Walk-Uneven Surfaces: Rarely (Less than 1 hour per week)

Stand: Frequent (34%-66% of time)

Bend: Frequent (34%-66% of time)

Other

Keyboard/Ten Key: Constant (Over 66% of time)

Fingering (fine dexterity): Constant (Over 66% of time)

Handling (grasping, holding): Constant (Over 66% of time)

Repetitive Motion – Hands: Occasional (1%-33% of time)

Repetitive Motion – Feet: Occasional (1%-33% of time)