All Details of Green Card Application:

Explore Trends, Employment Opportunities, and Insights

Back to search

Case Number: A-23037-97935

Fiscal year: 2024

Fiscal Year

2024

Case Number

A-23037-97935

Case Status

Certified

Received Date

2023-03-06

Decision Date

2024-04-17

Refile

N

Original File Date

2024-01-01 01:06:02

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

CHILDRENS HOSPITAL LOS ANGELES

Employer Name Slug

childrens-hospital-los-angeles

Employer Address 1

4650 SUNSET BOULEVARD

Employer Address 2

MAILSTOP 48

Employer City

LOS ANGELES

Employer City Slug

los-angeles

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

90027

Employer Phone

323-669-5942

Employer Number of Employees

5735

Employer Year Commenced Business

1901

NAICS Code

622110

FW Ownership Interest

N

Employer Contact Name

John G Baciu

Employer Contact Address 1

4650 Sunset Boulevard

Employer Contact Address 2

Mailstop 48

Employer Contact City

Los Angeles

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

90027

Employer Contact Phone

323-669-5942

Employer Contact Email

jbaciu@chla.usc.edu

Agent Attorney Name

Kathleen L Grzegorek

Agent Attorney Firm Name

SGG Immigration LLP

Agent Attorney Phone

(213) 627-8997

Agent Attorney Address 1

707 Wilshire Boulevard

Agent Attorney Address 2

Ste. 3200

Agent Attorney City

Los Angeles

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

90017

Agent Attorney Email

Kathy@sggimmigration.com

PW Track Number

P10022125139704

PW SOC Code

15-2051.01

PW SOC Title

Business Intelligence Analysts

PW Skill Level

Level III

PW Wage

117478.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-11-22

PW Expiration Date

2023-06-30

Wage Offer From

117478.00

Wage Offer To

165568.00

Average Salary

141523.00

Wage Unit of Pay

Year

Worksite Address 1

4650 Sunset Blvd.

Worksite Address 2

Worksite City

Los Angeles

Worksite City Slug

los-angeles

Worksite State

CALIFORNIA

Worksite Postal Code

90027

Job Title

Sr. Business Intelligence Analyst

Job Title Slug

sr-business-intelligence-analyst

Minimum Education

Master's

Major Field of Study

Business Analytics

Required Training

N

Required Experience

Y

Required Experience Months

24

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Data 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

Data Warehouse Analyst, ETL Developer, Systems Engineer, or any related job

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Must have experience with the following Working with database servers Microsoft SQL Server, Oracle, kbsql, postgreSQL; Building ETL packages using SSIS, Informatica, Pentaho Kettle; Building and maintaining reporting tools using Tableau, PowerBI, SAP webireports; and Troubleshooting and automating existing manual processes.br br 100 Telecommute Available. Candidate must reside in California.

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-12-02

SWA Job Order End Date

2023-01-06

Sunday Edition Newspaper

Y

First Newspaper Name

Los Angeles Times

First Advertisement Start Date

2022-12-04

Second Newspaper Ad Name

Los Angeles Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-12-11

Employer Website From Date

2022-12-05

Employer Website To Date

2022-12-23

Professional Organization Ad From Date

2024-01-01 01:06:02

Professional Organization Advertisement To Date

2024-01-01 01:06:02

Job Search Website From Date

2022-12-02

Job Search Website To Date

2022-12-16

Employee Referral Program From Date

2024-01-01 01:06:02

Employee Referral Program To Date

2024-01-01 01:06:02

Local Ethnic Paper From Date

2022-12-09

Local Ethnic Paper To Date

2022-12-15

Radio/TV Ad From Date

2024-01-01 01:06:02

Radio/TV Ad To Date

2024-01-01 01:06:02

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

BUSINESS ANALYTICS

Foreign Worker Years of Education Completed

2018

Foreign Worker Institution of Education

THE UNIVERSITY OF UTAH

Foreign Worker Education Institution Address 1

201 PRESIDENTS CIRCLE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

SALT LAKE CITY

Foreign Worker Education Institution State/Province

UT

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

84112

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Kathleen L Grzegorek

Preparer Title

Attorney

Preparer Email

Kathy@sggimmigration.com

Employer Information Declaration Name

John G Baciu

Employer Information Declaration Title

Human Resources Immigration Advisor