Fiscal Year

2020

Case Number

A-19238-49309

Case Status

Certified-Expired

Received Date

2019-08-26

Decision Date

2019-11-08

Refile

N

Original File Date

2020-01-01 07:53:26

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Community Behavioral Health

Employer Name Slug

community-behavioral-health

Employer Address 1

801 Market Street

Employer Address 2

7th floor

Employer City

Philadelphia

Employer City Slug

philadelphia

Employer State

PENNSYLVANIA

Employer State Slug

pennsylvania

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

19107

Employer Phone

215-413-3100

Employer Number of Employees

530

Employer Year Commenced Business

1997

NAICS Code

624190

FW Ownership Interest

N

Employer Contact Name

Robin Thomas

Employer Contact Address 1

801 Market Street

Employer Contact Address 2

7th Floor

Employer Contact City

Philadelphia

Employer Contact State/Province

PENNSYLVANIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

19107

Employer Contact Phone

215-413-7659

Employer Contact Email

Robin.Thomas@Phila.gov

Agent Attorney Name

Jack Doebley

Agent Attorney Firm Name

STEEL, DOEBLEY GLASSMAN, P.C.

Agent Attorney Phone

215-486-4176

Agent Attorney Address 1

1608 Walnut Street

Agent Attorney Address 2

Ste 1500

Agent Attorney City

Philadelphia

Agent Attorney State/Province

PENNSYLVANIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

19103-5410

Agent Attorney Email

jdoebley@sdglawgroup.com

PW Track Number

P10018169836367

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level I

PW Wage

57054.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2019-02-15

PW Expiration Date

2019-06-30

Wage Offer From

57054.00

Wage Offer To

78438.00

Average Salary

67746.00

Wage Unit of Pay

Year

Worksite Address 1

801 Market Street

Worksite Address 2

Flr. 7

Worksite City

Philadelphia

Worksite City Slug

philadelphia

Worksite State

PENNSYLVANIA

Worksite Postal Code

19107

Job Title

Senior Data Warehouse Engineer

Job Title Slug

senior-data-warehouse-engineer

Minimum Education

Bachelor's

Major Field of Study

Finance or Computers

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

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must have knowledge of MS SQL server platform, including management studio and business intelligence developer studio; SQL query creation and analysis and querydatabase tuning; data warehouse design methodology, including the Kimball method.

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

2019-05-29

SWA Job Order End Date

2019-07-01

Sunday Edition Newspaper

Y

First Newspaper Name

Philadelphia Inquirer

First Advertisement Start Date

2019-06-02

Second Newspaper Ad Name

Philadelphia Inquirer

Second Advertisement Type

Newspaper

Second Ad Start Date

2019-06-09

Employer Website From Date

2020-01-01 07:53:26

Employer Website To Date

2020-01-01 07:53:26

Professional Organization Ad From Date

2020-01-01 07:53:26

Professional Organization Advertisement To Date

2020-01-01 07:53:26

Job Search Website From Date

2019-06-04

Job Search Website To Date

2019-07-01

Employee Referral Program From Date

2020-01-01 07:53:26

Employee Referral Program To Date

2020-01-01 07:53:26

Local Ethnic Paper From Date

2019-06-07

Local Ethnic Paper To Date

2019-06-13

Radio/TV Ad From Date

2020-01-01 07:53:26

Radio/TV Ad To Date

2020-01-01 07:53:26

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

CHINA

Foreign Worker Birth Country

CHINA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

FINANCE

Foreign Worker Years of Education Completed

2013

Foreign Worker Institution of Education

DREXEL UNIVERSITY

Foreign Worker Education Institution Address 1

3141 CHESTNUT STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

PHILADELPHIA

Foreign Worker Education Institution State/Province

PA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

19104

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Jack Doebley

Preparer Title

Attorney

Preparer Email

jdoebley@sdglawgroup.com

Employer Information Declaration Name

Robin Thomas

Employer Information Declaration Title

Sr. Human Resources Manager