Fiscal Year

2021

Case Number

A-21060-56678

Case Status

Certified

Received Date

2021-03-29

Decision Date

2021-08-12

Refile

N

Original File Date

2021-01-01 09:59:05

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

ST JUDE CHILDRENS RESEARCH HOSPITAL

Employer Name Slug

st-jude-childrens-research-hospital

Employer Address 1

262 DANNY THOMAS PLACE

Employer Address 2

Employer City

MEMPHIS

Employer City Slug

memphis

Employer State

TENNESSEE

Employer State Slug

tennessee

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

38105

Employer Phone

(901) 595-4112

Employer Number of Employees

5500

Employer Year Commenced Business

1962

NAICS Code

622310

FW Ownership Interest

N

Employer Contact Name

Maggie Osborn

Employer Contact Address 1

262 Danny Thomas Place

Employer Contact Address 2

Mail Stop 507

Employer Contact City

Memphis

Employer Contact State/Province

TENNESSEE

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

38105

Employer Contact Phone

(901) 595-4112

Employer Contact Email

perm@stjude.org

Agent Attorney Name

Agent Attorney Firm Name

Agent Attorney Phone

Agent Attorney Address 1

Agent Attorney Address 2

Agent Attorney City

Agent Attorney State/Province

Agent Attorney Country

Agent Attorney Postal Code

Agent Attorney Email

PW Track Number

P10020253812188

PW SOC Code

15-1199

PW SOC Title

Database Architects

PW Skill Level

Level I

PW Wage

33197.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-03-24

PW Expiration Date

2021-06-30

Wage Offer From

73100.00

Wage Offer To

89440.00

Average Salary

81270.00

Wage Unit of Pay

Year

Worksite Address 1

262 Danny Thomas Place

Worksite Address 2

Worksite City

Memphis

Worksite City Slug

memphis

Worksite State

TENNESSEE

Worksite Postal Code

38105

Job Title

Database Analyst - Hematology

Job Title Slug

database-analyst-hematology

Minimum Education

Bachelor's

Major Field of Study

Health sciences, computer science or related field

Required Training

N

Required Experience

Y

Required Experience Months

24

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Health sciences, computer science or related field

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

Any occupation in which the required experience was gained

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors degree or foreign equivalent in health sciences, computer science or related field and 2 years of experience in database design involving database and software validation. Must also have experience in the following Building and managing data tables and queries using SQL Server management studio, Microsoft SQL server, Teradata, Oracle, R programming, Python, SAS, MS Office Suite, VBA, Tableau; Data warehousing, management, assessments, analysis, integrity, manipulation, visualization, modeling including creating conceptual models; SDLC, DDL, DML, DCL, ETL; Optimization of database performance by rewriting SQL queries, stored procedures and maintain indexes; Working with multiple distributed databases; Database backups, recovery strategy, and restoring; Creating scripts to migrate data from various databases to new hardwareSoftware and run jobs; Data import using Libname and Pass through facility; Developing SAS programs to support statistical programming activities; Creating new SAS programs using SASBASE and SASMacro for automation; Modifying existing SAS programs for Ad Hoc reporting in enterprise guide using Query Builder, SASSQL and SASMacro; Data quality check using Proc means and Proc Freq focusing on minimum and maximum missing values by introducing indicator variables; Building summary reports using Proc Summary, Proc Means, Proc Freq, Proc Tabulate, Proc report; Participating in short and longterm planning of database projects including data storage and analysis; Managing databases with MS Access 20162019 front end and SQL server back end using SQL Server management studio.

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

2020-10-15

SWA Job Order End Date

2020-11-13

Sunday Edition Newspaper

Y

First Newspaper Name

The Commercial Appeal

First Advertisement Start Date

2020-10-25

Second Newspaper Ad Name

The Commercial Appeal

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-11-01

Employer Website From Date

2020-11-10

Employer Website To Date

2020-11-13

Professional Organization Ad From Date

2021-01-01 09:59:05

Professional Organization Advertisement To Date

2021-01-01 09:59:05

Job Search Website From Date

2021-01-01 09:59:05

Job Search Website To Date

2021-01-01 09:59:05

Employee Referral Program From Date

2020-11-12

Employee Referral Program To Date

2020-11-13

Local Ethnic Paper From Date

2021-01-01 09:59:05

Local Ethnic Paper To Date

2021-01-01 09:59:05

Radio/TV Ad From Date

2021-01-01 09:59:05

Radio/TV Ad To Date

2021-01-01 09:59:05

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

INFORMATION SYSTEMS, A RELATED FIELD TO COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2016

Foreign Worker Institution of Education

CALIFORNIA STATE UNIVERSITY, FULLERTON

Foreign Worker Education Institution Address 1

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

FULLERTON

Foreign Worker Education Institution State/Province

CA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

92834

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

Y

Preparer Name

Preparer Title

Preparer Email

Employer Information Declaration Name

Maggie Osborn

Employer Information Declaration Title

Immigration Specialist