Subscribe:   RSS  RSS   Mail Alerts  Mail Alerts  

Data Warehouse Modeler

Job Category:
Technology Provider
Career Level:
Mid Career (2+ years of experience)
Job Type:
Full Time/Permanent
Company Name:
First Republic
San Fransisco

More information about this job:


First Republic is an ultra-high-touch bank that provides extraordinary client service. We believe that one-on-one interactions build lasting relationships. We move quickly to serve our clients’ needs so that their financial transactions are handled with ease and efficiency. Client trust and security are paramount in our line of business. Ultimately, our goal is unsurpassed client satisfaction which will lead to personal referrals – our number one source of new business. We recognize that our competitive advantage starts with our people and our culture. At First Republic, we work hard and move quickly as a very coordinated team. If you are looking for an opportunity to grow and contribute in a fun, fast-paced environment, First Republic is the place for you. We have exceptional people focused on providing extraordinary service.

The Data Warehouse Modeler is responsible for collection method, data cleansing, and normalization of enterprise data to support decision making and reporting. Coordinate data models, dictionaries, and other database documentation across multiple applications


  • Experience working in a Sr. Data Modeler or Data Architect capacity with hands on experience in SQL based Data Analysis, as well as extensive background in data modeling and data warehousing
  • Translate Business Requirements into a technical solution
  • Understand the data requirements for the project and drive the solution based on the information needs.
  • Adhere to Data Model and Data Architecture Best Practices
  • Assist in the design and development of Data Warehouse/Data Mart
  • Ability to identify and resolve any performance and/or data related issues
  • Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects
  • Mentorship of junior team members
  • Knowledge and prior work experience in Banking, Private Wealth Management or related financial services is a plus.
  • Strong skills and experience using Informatica PowerCenter, Master Data Management and Metadata Strategy including implementation, architecture and developing Standards and Methodology required.
  • Requires solid knowledge about ETL, data architecture, data modeling and Software Development Lifecycles.
  • Ability to explain complex data challenges to business users and work in cross-functional team environment.
  • Perform duties & responsibilities specific to department functions & activities.
  • Performs other duties & responsibilities as required or assigned by supervisor.
  • Responsibilities include the following:
    • Adhering to and complying with all applicable, federal and state laws, regulations and guidance, including those related to Anti-Money Laundering (i.e. Bank Secrecy Act, USA PATRIOT Act, etc.).
    • Adhering to Bank policies and procedures.
    • Completing required training.


  • 10+ years of experience working in a Sr. Data Modeler or Data Architect capacity with hands on experience in SQL Server or related databases, as well as extensive background in data modeling and data warehousing
  • Understanding of star/snowflake schemas, indexing, aggregate tables, dimension tables, constraints, keys, and fact tables required
  • Technical expertise regarding data models, database design development, data mining and segmentation techniques
  • Strong knowledge of and experience with ETL frameworks and reporting packages, databases, SQL programming.
  • Understand the data requirements for the project and drive the solution based on the information needs.
  • Ability to understand the implications & understand how the data will be used in upstream/downstream applications and accordingly guide the team on logical / physical models
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Adept at queries, identifying errors in data and presenting findings
  • Data warehousing expertise/tools: Data Marts/ Materialized Views/Star Schema, Erwin
  • Team player who provides extraordinary service
  • Furthers the Bank’s culture and values


Education and Experience:

  • Bachelor's degree in Computer Science, Information Technology or relevant field (or four additional years related work experience in lieu of degree).
  • Minimum of 10 years of related work experience with increasing responsibilities

 Physical Requirements:

  • Vision must be sufficient to read data reports, manuals and computer screens
  • Hearing must be sufficient to understand a conversation at a normal volume, including telephone calls and in person
  • Speech must be coherent to clearly convey or exchange information, including the giving and receiving of assignments and/or directions
  • Position involves sitting most of the time, but may involve walking or standing for brief periods of time
  • Must be able to travel in a limited capacity

Please be advised that First Republic Bank will not ask you to provide personal information, including driver's licenses, social security numbers, and passports during the interview process. If you receive a request of this type, please report it to