Fiscal Year

2022

Case Number

A-21173-05093

Case Status

Certified-Expired

Received Date

2021-07-04

Decision Date

2021-12-27

Refile

N

Original File Date

2022-01-01 10:40:48

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

West Penn Allegheny Health System, Inc.

Employer Name Slug

west-penn-allegheny-health-system-inc

Employer Address 1

30 Isabella Street, 2nd Floor

Employer Address 2

Legal Department

Employer City

Pittsburgh

Employer City Slug

pittsburgh

Employer State

PENNSYLVANIA

Employer State Slug

pennsylvania

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

15212

Employer Phone

4123302523

Employer Number of Employees

17000

Employer Year Commenced Business

1999

NAICS Code

62211

FW Ownership Interest

N

Employer Contact Name

Karen Irwin

Employer Contact Address 1

30 Isabella Street, 2nd Floor

Employer Contact Address 2

Legal Department

Employer Contact City

Pittsburgh

Employer Contact State/Province

PENNSYLVANIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

15212

Employer Contact Phone

4123302523

Employer Contact Email

karen.irwin@highmarkhealth.org

Agent Attorney Name

Alexander R Castrodale

Agent Attorney Firm Name

Dentons Cohen Grigsby, P.C.

Agent Attorney Phone

4122974712

Agent Attorney Address 1

625 LIBERTY AVENUE

Agent Attorney Address 2

5TH FLOOR

Agent Attorney City

PITTSBURGH

Agent Attorney State/Province

PENNSYLVANIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

15222

Agent Attorney Email

alex.castrodale@dentons.com

PW Track Number

P10020323917604

PW SOC Code

15-1199

PW SOC Title

Computer Occupations, All Other

PW Skill Level

Level II

PW Wage

61485.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-04-05

PW Expiration Date

2021-07-04

Wage Offer From

71611.00

Wage Offer To

0.00

Average Salary

71611.00

Wage Unit of Pay

Year

Worksite Address 1

501 Penn Avenue Place

Worksite Address 2

Worksite City

Pittsburgh

Worksite City Slug

pittsburgh

Worksite State

PENNSYLVANIA

Worksite Postal Code

15222

Job Title

Business Intelligence Developer – Data Warehousing

Job Title Slug

business-intelligence-developer-data-warehousing

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Information Technology, Information Management, Business Admin., or rltd fld.

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

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

Related position

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must also have Epic BI Data Model Certifications.br br Must also have any experience with or knowledge of i gathering business requirements from business operational owners and create requirement documents and mockups; ii developing ETL within Epic Warehouse structure; iii delivering standard and ad hoc data and report requests, analyzing data needs for both users and projects, investigating and analyzing data discrepancies, and assisting in migration and testing activities; iv SQL tuning to maximize query performance and efficiency; v troubleshooting general code and database structures; and vi independently conducting QA and presenting recommendations on a consistent basis.br br Must be able to work shifts between 630am and 700pm MF as well as 8am430pm SatSun.br br Experience can be concurrent.

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-03-24

SWA Job Order End Date

2021-05-10

Sunday Edition Newspaper

Y

First Newspaper Name

Pittsburgh Post Gazette

First Advertisement Start Date

2021-04-25

Second Newspaper Ad Name

Pittsburgh Post Gazette

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-05-02

Employer Website From Date

2021-03-23

Employer Website To Date

2021-06-15

Professional Organization Ad From Date

2022-01-01 10:40:48

Professional Organization Advertisement To Date

2022-01-01 10:40:48

Job Search Website From Date

2021-04-25

Job Search Website To Date

2021-05-25

Employee Referral Program From Date

2022-01-01 10:40:48

Employee Referral Program To Date

2022-01-01 10:40:48

Local Ethnic Paper From Date

2021-04-28

Local Ethnic Paper To Date

2021-05-04

Radio/TV Ad From Date

2022-01-01 10:40:48

Radio/TV Ad To Date

2022-01-01 10:40:48

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 ADMINISTRATION

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

CLEARY UNIVERSITY

Foreign Worker Education Institution Address 1

3750 CLEARY DRIVE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HOWELL

Foreign Worker Education Institution State/Province

MI

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

48843

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Alexander R Castrodale

Preparer Title

Attorney

Preparer Email

alex.castrodale@dentons.com

Employer Information Declaration Name

Preeti Paranjpe

Employer Information Declaration Title

TS Program Manager