Sr. Data Modeler (National Work from Home)

Company: FlagStar Bank
Location: Troy
Posted on: January 12, 2021

Job Description:

Flagstar Bank is seeking an energetic and self-motivated Sr. Data Modeler to join the Enterprise Data Management & Analytics team. In this role, the Sr. Data Modeler will work closely with peer data-centric technical architects and developers to lead the logical design and physical implementation of large-scale data solutions that enable business innovation and operations efficiencies. The Flagstar Bank Data Warehouse is an enterprise data warehouse that centralizes Flagstar's business information from multiple sources and applications, and enables enterprise analytics for use across the organization. The Sr. Data Modeler is responsible for the conceptual, logical and physical data model of the Flagstar Enterprise Data Warehouse. This includes data analysis and profiling to provide direction, standards, and implementation of data management solutions to enable efficient data ingestion, curation, and analytics. 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.* Data research and analysis in support of creating, advising and reviewing enterprise data models and data dictionary.* Advising and reviewing ETL design and development efforts created by ETL delivery teams.* Work closely with the delivery teams to ensure data being ingested and curated is accurate, clean, efficient, and complete.* Evaluate and understand delivery requirements to effectively prioritize work activities to meet targeted timelines.* Works closely with Line of Business (LoB) delivery, Data Governance, and EDMA project delivery teams throughout the complete System Development Life Cycle (SDLC).* 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 required in Computer Science plus a minimum of 7 years' experience (as listed below) - OR - 10 years of equivalent experience* Minimum of 7 years' applied experience as a Data Modeler / Data Architect in a Data-warehouse environment* Minimum of 7 years' applied experience with conceptual, logical and physical design of Atomic (3rd normal form) and Data marts (Dimensional Star schema modeling)* Minimum of 10 years applied on experience with Oracle RDBMS* Minimum of 5 years applied experience with data profiling, performance tuning of Oracle database & data marts* Minimum of 10 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 databases, data marts, and DataStage ETL jobs.* Certification on DataStage is preferred* Certification on Oracle RDBMS is preferredInternal Use Only: Band E

Keywords: FlagStar Bank, Troy , Sr. Data Modeler (National Work from Home), Other , Troy, Michigan