Fiscal Year

2022

Case Number

A-21187-12585

Case Status

Certified-Expired

Received Date

2021-09-02

Decision Date

2022-02-28

Refile

N

Original File Date

2022-01-01 11:00:07

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

THE JOHNS HOPKINS UNIVERSITY

Employer Name Slug

the-johns-hopkins-university

Employer Address 1

3400 N. CHARLES STREET

Employer Address 2

Employer City

BALTIMORE

Employer City Slug

baltimore

Employer State

MARYLAND

Employer State Slug

maryland

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

21218

Employer Phone

667-208-7001

Employer Number of Employees

35000

Employer Year Commenced Business

1876

NAICS Code

611310

FW Ownership Interest

N

Employer Contact Name

JENNIFER L KERILLA

Employer Contact Address 1

3910 Keswick Road

Employer Contact Address 2

Employer Contact City

BALTIMORE

Employer Contact State/Province

MARYLAND

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

21211

Employer Contact Phone

667-208-7001

Employer Contact Email

jkerill1@jhmi.edu

Agent Attorney Name

Sufen Zhang

Agent Attorney Firm Name

Miles Stockbridge P.C.

Agent Attorney Phone

4103853608

Agent Attorney Address 1

100 Light Street

Agent Attorney Address 2

Agent Attorney City

Baltimore

Agent Attorney State/Province

MARYLAND

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

21202

Agent Attorney Email

szhang@milesstockbridge.com

PW Track Number

P10021032045525

PW SOC Code

15-1199

PW SOC Title

Business Intelligence Analysts

PW Skill Level

Level III

PW Wage

73507.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-07-14

PW Expiration Date

2022-06-30

Wage Offer From

73507.00

Wage Offer To

81435.00

Average Salary

77471.00

Wage Unit of Pay

Year

Worksite Address 1

601 North Wolfe Street

Worksite Address 2

Worksite City

Baltimore

Worksite City Slug

baltimore

Worksite State

MARYLAND

Worksite Postal Code

21287

Job Title

Sr. Business Intelligence Analyst

Job Title Slug

sr-business-intelligence-analyst

Minimum Education

Bachelor's

Major Field of Study

See H.14

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Master's

Accept Alternative Combination Education Years

2

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

48

Accept Alternative Job Title

See H.14

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors degree or foreign equivalent in Operations Management, Industrial Engineering, Management Science Engineering, Information Technology, or a related field, and four 4 years of related experience, which must include the followingbr br Two 2 years of experience with data analytics;br Two 2 years of experience with Tableau Desktop;br Two 2 years of experience with Microsoft SQL Server Database Programming; andbr Two 2 years of experience with SQL Server Integration Services SSIS.br br All experience may be concurrent.br br In lieu of a Bachelors degree and four 4 years of related experience, employer will accept a Masters degree or foreign equivalent in Operations Management, Industrial Engineering, Management Science Engineering, Information Technology, or a related field, and two 2 years of related experience, which must include the followingbr br Two 2 years of experience with data analytics;br Two 2 years of experience with Tableau Desktop;br Two 2 years of experience with Microsoft SQL Server Database Programming; andbr Two 2 years of experience with SQL Server Integration Services SSIS.br br All experience may be concurrent.br br Position also requires preemployment background check. May require vaccinations and preemployment medical.

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

2021-05-13

SWA Job Order End Date

2021-06-14

Sunday Edition Newspaper

Y

First Newspaper Name

The Baltimore Sun

First Advertisement Start Date

2021-05-16

Second Newspaper Ad Name

The Baltimore Sun

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-05-23

Employer Website From Date

2021-05-13

Employer Website To Date

2021-06-15

Professional Organization Ad From Date

2022-01-01 11:00:07

Professional Organization Advertisement To Date

2022-01-01 11:00:07

Job Search Website From Date

2021-05-13

Job Search Website To Date

2021-06-15

Employee Referral Program From Date

2022-01-01 11:00:07

Employee Referral Program To Date

2022-01-01 11:00:07

Local Ethnic Paper From Date

2021-05-19

Local Ethnic Paper To Date

2021-05-19

Radio/TV Ad From Date

2022-01-01 11:00:07

Radio/TV Ad To Date

2022-01-01 11:00:07

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

NIGERIA

Foreign Worker Birth Country

NIGERIA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

MANAGEMENT SCIENCE ENGINEERING

Foreign Worker Years of Education Completed

2014

Foreign Worker Institution of Education

COLUMBIA UNIVERSITY

Foreign Worker Education Institution Address 1

615 W. 131ST STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

NEW YORK

Foreign Worker Education Institution State/Province

NY

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

10027

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Sufen Zhang

Preparer Title

Principal

Preparer Email

szhang@milesstockbridge.com

Employer Information Declaration Name

Jennifer L Kerilla

Employer Information Declaration Title

Director, Office of International Services