Data Modeler
Flagstar Bank FSB

Troy, Michigan

Posted in Banking

This job has expired.

Job Info

Job Summary
The Data Modeler is responsible for the conceptual, logical and physical data model of the Enterprise Data Warehouse architecture. This includes data analysis, profiling to provide direction, standards, and implementation of data management solutions to enable efficient data ingestion, curation, and analytics. This also requires to act as the data-warehouse DBA to deploy codes in the lower environments for the development and at the same time provide solutions to optimize queries by working with the architects.

The ideal candidate must demonstrate ability to work and lead with a sense of urgency in a fast-paced and data-centric environment, while interacting professionally with diverse groups inclusive of executives, managers, and vendors, while adjusting positively to quickly changing priorities and shifting goals.

Job Responsibilities:

  • Profiling, creating, advising and reviewing the data models and data dictionary.
  • Advising and reviewing the ETL design and development efforts created by the ETL development team.
  • Works closely with the team in ensuring that the data being brought in and managed is accurate, clean, efficient, 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 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. Work with the DBA's to deploy the database objects into production.
  • Ensures compliance with applicable federal, state and local laws and regulations. Completes all required compliance training. Maintains knowledge of and adhere to Flagstar's internal compliance policies and procedures. Takes responsibility to keep up to date with changing regulations and policies.

Job Requirements:
  • Bachelor's Degree in Computer Science required.
  • Minimum of 5+ years' applied experience as a Data Modeler / Data Architect in a Data-warehouse environment.
  • Minimum of 5+ years' applied experience with conceptual, logical and physical design of Atomic (3rd normal form) and Data marts (Dimensional Star schema modeling).
  • Minimum of 8+ years applied on experience with Oracle RDBMS..
  • Minimum of 3+ years applied experience with data profiling, performance tuning of Oracle database & data marts.
  • Minimum of 8+ years' experience with SDLC / Scaled Agile delivery frameworks for data warehouse projects - inclusive of standards development.
  • Complete understanding of Business Intelligence reporting.
  • Preferred: Exposure to BI reporting tools like Cognos & PowerBI.
  • Preferred: Exposure to cloud computing data warehouse platforms (AWS Redshift, Snowflake, etc.).
  • 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.
  • Certification on Datastage is preferred.
  • Certification on Oracle RDBMS is preferred.

For internal use only: Job Band E

This job has expired.

More Banking jobs

Commerce Bank
Columbia, Missouri
Posted about 4 hours ago

Commerce Bank
Dallas, Texas
Posted about 4 hours ago

Commerce Bank
Garden City, Kansas
Posted about 4 hours ago

Improve Job Search

Subscribe to job alerts and add your resume to our resume database for employers!

Sign up now