Citizens Business Bank

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

VP, Data Warehouse Manager

at Citizens Business Bank

Posted: 9/21/2019
Job Reference #: 1873
Keywords: manager

Job Description

Location:
Rancho Cucamonga, CA

Notice of Vacancy #:
1813

Department:
Operations Management-600

Fusion Grade:
19

Joining Citizens Business Bank means connecting with a team of dedicated associates that continually strive for new and innovative ways to meet and exceed the needs of our customers. As a top ranked bank, life at our company includes a working environment that thrives on collaboration, integrity, and mutual respect for one another. We encourage our associates to ask questions, learn, care deeply, and make an impact. Our dedication to customers and associates is at the core of our business culture and is represented by five core values: financial strength, superior people, customer focus, cost-effective operation, and having fun.

Data Warehouse Manager

Summary

Manage data warehouse team that designs, develops, builds, analyzes bank’s Microsoft SQL database platform  Oversee database modeling, design, relational database architecture, metadata, repository creation and configuration management. Manages, develops, enhances, and supports the bank’s data strategy for the enterprise wide data warehouse and divisional data design and reporting.  .                                               

Essential Duties and Responsibilities

  1. Manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and related data marts.

  2. Utilize Microsoft SSIS, SSRS, and PowerBI tools to build and support dashboards.

  3. Gather and analyze business requirements, Architect / Design Data Warehouse infrastructure and solutions.

  4. Create application architecture diagrams, process flow diagrams, and prototypes to effectively communicate design ideas.Support technical development in designing, testing and implementing application changes.

  5. Clearly and concisely documents business requirements, use cases, and functional specifications.  Support technical development in designing, testing and implementing application changes.

  6. Leads the build out of enterprise reporting and analytics capabilities, tools and functions.

  7. Responsible for contributing to and strategically managing the roadmaps for Business Intelligence and data transformation solutions for the team

  8. Lead / develop processes for auditing data warehouses and ensuring data quality.

  9. Complies with and stays abreast of all policies and procedures, federal and state laws applicable to the job.

  10. Provide, present and promote The Citizens Experience to all external and internal customers.

  11. Other duties as assigned

Supervisory Responsibilities  

Directly supervises 4-6 employees in the Data Warehouse. Carries out supervisory responsibilities in accordance with the organization's policies and applicable laws. Responsibilities include interviewing, hiring, and training employees; planning, assigning, and directing work; appraising performance; rewarding and disciplining employees; addressing complaints and resolving problems.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.  Ability to write reports, business correspondence, and procedure manuals.  Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Language Skills                                                     

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.  Ability to write reports, business correspondence, and procedure manuals.  Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Mathematical Skills

Ability to add, calculate figures and amounts such as discounts, interest, commissions, proportions and percentages.  Ability to apply concepts of basic algebra and geometry, and interpret bar graphs.

Reasoning Ability                                                  

Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

Computer Skills                                                     

  1. Microsoft SSIS, SSRS, and Power BI experience required.
  2. Solid experience with logical and physical database schema design.
  3. Strong problem-solving skills across both process and technical domains.
  4. Ability to communicate and translate technical strategy to non-technical business leaders and senior management.
  5. 7+ years working experience with Data Integration, ETL, Data Warehouse, BI, and Data Management
  6. Hands-on experience with both relational and dimensional databases
  7. Proficiency with enterprise PowerBI tools building dashboards and data architecture.
  8. Exposure to Cloud integration technologies is a plus.
     

Certificates, Licenses, Registrations

A plus:

  1. Microsoft Business Intelligence Tools (PowerBI)
  2. Business Analytics Training or Certification
  3. Database management certifications
  4. Microsoft SQL Server (2008, 2012, 2016)

Other Skills and Abilities                                                 

  1. Good oral and written communication skills evidenced by a background in preparing comprehensive documentation incorporating complex information.
  2. Strong manager who can work independently and drive the team to achieved stated goals.
  3. Ability and desire to work in a fast-paced environment.
  4. Proven ability to work in a team environment with minimal supervision/self- motivated and ability to work independently.                                              
  5. Strong organizational, leadership, decision making, mentorship and communication skills.
  6. Ability to plan and execute project work plans and revises as appropriate to meet changing needs and requirements.
  7. Strong problem-solving skills across both process and technical domains.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to sit. The employee is occasionally required to stand; walk; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl; talk or hear and taste or smell. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.

Citizens Business Bank is an Equal Opportunity, Affirmative Action Employer. Minorities, women, veterans, and individuals with disabilities are encouraged to apply. We provide equal opportunity in all employment matters without regard to race, color, religion, sex, gender, gender identity, gender expression, sexual orientation, marital status, national origin, ancestry, mental and physical disability, medical condition, age, genetic information, national origin, veteran status or any other status protected by federal, state, or local law, for all qualified applicants and Citizens Business Bank associates.