Sr. Data Warehouse Architect

  • icrunchdata Network
  • Birmingham, MI, USA
  • May 22, 2020
Information Technology (IT)

Job Description

The Flagstar Bank data warehouse is a corporate data warehouse that houses the data from most of the sources used by the organization. The data in the data warehouse is governed for quality and approved by the business users. The senior data warehouse architect is responsible for architecting all the database and the ETL (Extraction Transformation Loading) solutions in the data warehouse. This includes providing strategy, leadership, direction, standards, and implementation of the solutions from the data modelers, ETL developers, and the rest of the team to maintain quality and accuracy of data. This person will be responsible for the logical and physical models of the data warehouse along with the ETL design and development. Managing, advising and reviewing the data models created by the data architects / modelers. Managing, advising and reviewing the ETL design and development created by the ETL development team. Works closely with the senior management in ensuring that the data being brought in and managed is accurate, clean, easily available, and complete. This essentially assists the business in ensuring that data warehouse processes are running at an optimum capacity at all times and the reports are accurate in terms of data. Understand requirements and prioritizes work activities of the team to meet the timelines. Works closely with the business teams, Data Governance team, project team, and the testing team during the complete system development life cycle. Ensure compliance with applicable federal, state and local laws and regulations. Complete all required compliance training. Maintain knowledge of and adhere to Flagstar's internal compliance policies and procedures. Take responsibility to keep up to date with changing regulations and policies. Job Requirements: Bachelor’s Degree in Computer Science or other related field is required Minimum of 10 years’ experience as a Data Modeler / Data Architect in a data warehouse environment Minimum of 10 years’ experience as an ETL architect and ETL developer in a data warehouse environment Minimum of 10 years’ hands on experience with Oracle RDBMS Minimum of 10 years’ hands on experience with DataStage ETL and InfoSphere suite of tools Minimum of 10 years’ experience with complete SDLC implementation of data warehouse projects Minimum of 10 years’ hands on experience with design of Atomic (third normal form) and Data Marts (dimensional star schema modeling) Minimum of 5 years’ experience with leading development teams Complete understanding of Business Intelligence reporting Exposure to BI reporting tools like Cognos Experience with Data Governance in a typical data warehouse to maintain quality and accuracy of data Hands on experience in performance tuning of Oracle database, data marts, and DataStage Hands on experience in QualityStage is preferred Hands on experience with Datastage / Infosphere administration preferred DataStage and Oracle RDBMS certification is preferred Internal Use Only: Band D Job Requirements:

Job ID

FLAGSTAR BANK