Fiscal Year

2024

Case Number

A-23065-08933

Case Status

Certified

Received Date

2023-04-03

Decision Date

2024-05-06

Refile

N

Original File Date

2024-01-01 01:17:34

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Flagstar Bank, NA

Employer Name Slug

flagstar-bank-na

Employer Address 1

100 Duffy Avenue

Employer Address 2

Employer City

Hicksville

Employer City Slug

hicksville

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

11801

Employer Phone

516 597-4721

Employer Number of Employees

7743

Employer Year Commenced Business

1859

NAICS Code

522120

FW Ownership Interest

N

Employer Contact Name

Kimberly Bostwick

Employer Contact Address 1

5151 Corporate Drive

Employer Contact Address 2

Employer Contact City

Troy

Employer Contact State/Province

MICHIGAN

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

48098

Employer Contact Phone

2483125605

Employer Contact Email

kim.bostwick@flagstar.com

Agent Attorney Name

Rona M Lum

Agent Attorney Firm Name

Law Office of Rona M. Lum

Agent Attorney Phone

2483401854

Agent Attorney Address 1

691 N. Squirrel Rd.

Agent Attorney Address 2

Ste. 185

Agent Attorney City

Auburn Hills

Agent Attorney State/Province

MICHIGAN

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

48326

Agent Attorney Email

rlum@corpimmigration.us

PW Track Number

P10022152231288

PW SOC Code

15-2051.00

PW SOC Title

Data Scientists

PW Skill Level

Level IV

PW Wage

105290.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-12-15

PW Expiration Date

2023-06-30

Wage Offer From

114394.00

Wage Offer To

0.00

Average Salary

114394.00

Wage Unit of Pay

Year

Worksite Address 1

5151 Corporate Drive

Worksite Address 2

Regional Branch Office and location of CIO and inhouse IT Department

Worksite City

Troy

Worksite City Slug

troy

Worksite State

MICHIGAN

Worksite Postal Code

48098

Job Title

BI Architect

Job Title Slug

bi-architect

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Information Systems or Technology

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

N

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

any ITrelated position that involved working with skill sets set forth in item H.14 below

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors degree in Computer Science, Information Systems or Technology or closely related field of study and 5 years of design and build experience using Cognos platforms, including framework modeling, Cognos Administrator, security design, data mart modeling, understanding of ETL, performance tuning, and dashboard and report design and development. 1 year of the 5 required years of experience must include relational and dimensional data modeling, Cognos Framework Manager, and advanced schedulers such as Tidal, installation, patching, failover, disaster recovery, and troubleshooting. IBM certification as a Designer or Developer in Cognos 1011 BI Metadata Models, Cognos 1011 BI Reports, and or Cognos Framework modeling 1011 is preferred.br br EXPLANATION OF RECENT CORPORATE MERGERbr Effective December 1, 2022, Flagstar Bank, FSB amended its charter and converted from a federal savings bank to a national bank. The Bank is now known as Flagstar Bank, NA the Bank. New York Community Bancorp, Inc. NYSE NYCBs acquisition of Flagstar Bancorp, Inc. received regulatory approval from the Office of the Comptroller of the Currency to convert Flagstar Bank, FSB to a national bank to be known as Flagstar Bank, N.A. and to merge New York Community Bank NYCB into Flagstar Bank, N.A. NYCB is now a division of Flagstar Bank, N.A.br The acquisition creates one of the largest regional banks in the country, operating 395 branches across a ninestate franchise, including strong footholds in the Northeast and Midwest and exposure to high growth markets in the Southwest and West Coast. Through the Flagstar Mortgage division, the Company will operate nationally through 81 retail home lending offices in 26 states and a wholesale network of approximately 3,000 thirtyparty mortgage originators.br The acquisition does not change the location of the Banks inhouse IT Department which will remain at the Regional Branch Office in Troy, Michigan. The Banks CIO is also headquartered in Troy, Michigan. The Banks Federal Employer Identification Number FEIN also remains the same.br br EXPLANATION OF BUSINESS NECESSITY FOR EXPERIENCE REQUIREMENTbr br Due to the technical nature of the services we provide and the myriad of regulatory requirements that our Bank must adhere to, Flagstar maintains its own inhouse IT department, which is responsible for designing software programs and maintaining our IT infrastructure specifically tailored to meet the needs of our Bank and to continually increase the efficiency of our services while protecting and maintaining the confidentiality of the financial and banking records of our customers.br br The position of BI Architect is an essential position within the Bank. The BI Architect is responsible for architecting the entire BI platform to align with the Banks Datawarehouse modernization and associated activities, including capacity planning, upgrades, administration, and security design, scheduling design, and cube design. The position is also responsible for the design and development of executive dashboards, data mart access design, and advanced analytics in accordance with industry best practices.br br To adequately perform the highly technical duties of this position, it is necessary that the BI Architect, possess, at a minimum, the formal education and experience requirements as set forth in Item H.14. A person who fills the proffered position within the Bank cannot properly carry out the duties and responsibilities of a BI Architect without the required formal education and experience in the stated skill sets.

Combination Occupation

N

Offered to Applicant Foreign Worker

Y

Foreign Worker Live on Premises

N

Foreign Worker Live in Domestic Service

N

Foreign Worker Live in Domestic Service Count

Professional Occupation

Y

Application for College/University Teacher

N

SWA Job Order Start Date

2022-11-01

SWA Job Order End Date

2022-12-01

Sunday Edition Newspaper

Y

First Newspaper Name

Detroit News and Free Press

First Advertisement Start Date

2022-10-30

Second Newspaper Ad Name

Detroit News and Free Press

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-11-06

Employer Website From Date

2022-10-30

Employer Website To Date

2022-12-06

Professional Organization Ad From Date

2024-01-01 01:17:34

Professional Organization Advertisement To Date

2024-01-01 01:17:34

Job Search Website From Date

2022-10-30

Job Search Website To Date

2022-11-29

Employee Referral Program From Date

2024-01-01 01:17:34

Employee Referral Program To Date

2024-01-01 01:17:34

Local Ethnic Paper From Date

2024-01-01 01:17:34

Local Ethnic Paper To Date

2024-01-01 01:17:34

Radio/TV Ad From Date

2024-01-01 01:17:34

Radio/TV Ad To Date

2024-01-01 01:17:34

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

INDIA

Foreign Worker Birth Country

INDIA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2010

Foreign Worker Institution of Education

UNIVERSITY OF ILLINOIS

Foreign Worker Education Institution Address 1

ONE UNIVERSITY PLAZA

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

SPRINGFIELD

Foreign Worker Education Institution State/Province

IL

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

62703

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Rona M Lum

Preparer Title

Attorney

Preparer Email

rlum@corpimmigration.us

Employer Information Declaration Name

Kimberly Bostwick

Employer Information Declaration Title

HR Executive Administrative Assistant