Fiscal Year

2024

Case Number

A-23059-06563

Case Status

Certified-Expired

Received Date

2023-02-28

Decision Date

2024-03-28

Refile

N

Original File Date

2024-01-01 01:03:50

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

North American Dental Group

Employer Name Slug

north-american-dental-group

Employer Address 1

11 S Mill Street

Employer Address 2

Suite 200

Employer City

New Castle

Employer City Slug

new-castle

Employer State

PENNSYLVANIA

Employer State Slug

pennsylvania

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

16101

Employer Phone

724-698-2641

Employer Number of Employees

730

Employer Year Commenced Business

2008

NAICS Code

561110

FW Ownership Interest

N

Employer Contact Name

Kim Sloan

Employer Contact Address 1

11 S Mill Street

Employer Contact Address 2

Suite 200

Employer Contact City

New Castle

Employer Contact State/Province

PENNSYLVANIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

16101

Employer Contact Phone

724-698-2641

Employer Contact Email

sloank@nadentalgroup.com

Agent Attorney Name

Erin P Brown

Agent Attorney Firm Name

Robert Brown LLC

Agent Attorney Phone

(216) 861-4414

Agent Attorney Address 1

1468 WEST 9TH STREET

Agent Attorney Address 2

Ste. 705

Agent Attorney City

CLEVELAND

Agent Attorney State/Province

OHIO

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

44113

Agent Attorney Email

ebrown@rbrownllc.com

PW Track Number

P10022069966047

PW SOC Code

15-1243.00

PW SOC Title

Database Architects

PW Skill Level

Level IV

PW Wage

126402.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-09-13

PW Expiration Date

2023-06-30

Wage Offer From

126402.00

Wage Offer To

0.00

Average Salary

126402.00

Wage Unit of Pay

Year

Worksite Address 1

125 Enterprise Drive

Worksite Address 2

Suite 200

Worksite City

Pittsburgh

Worksite City Slug

pittsburgh

Worksite State

PENNSYLVANIA

Worksite Postal Code

15275

Job Title

Sr. Business Intelligence Architect

Job Title Slug

sr-business-intelligence-architect

Minimum Education

None

Major Field of Study

Required Training

N

Required Experience

Y

Required Experience Months

120

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

10 years of experience in Microsoft BI Stack tools SQL Server Integration, Analysis, Reporting Services SSIS, SSAS, and SSRS, MS PowerBI and SQL programming; 5 years of experience in data warehouse architecture and data administration and certification as a Microsoft Solutions expert.

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-09-26

SWA Job Order End Date

2022-10-31

Sunday Edition Newspaper

Y

First Newspaper Name

Pittsburgh Post Gazette

First Advertisement Start Date

2022-09-25

Second Newspaper Ad Name

Pittsburgh Post Gazette

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-10-02

Employer Website From Date

2023-01-04

Employer Website To Date

2023-01-16

Professional Organization Ad From Date

2024-01-01 01:03:50

Professional Organization Advertisement To Date

2024-01-01 01:03:50

Job Search Website From Date

2024-01-01 01:03:50

Job Search Website To Date

2024-01-01 01:03:50

Employee Referral Program From Date

2024-01-01 01:03:50

Employee Referral Program To Date

2024-01-01 01:03:50

Local Ethnic Paper From Date

2022-09-30

Local Ethnic Paper To Date

2022-09-30

Radio/TV Ad From Date

2022-09-29

Radio/TV Ad To Date

2022-09-29

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

Bachelor's

Foreign Worker Information: Major

ENGINEERING

Foreign Worker Years of Education Completed

2004

Foreign Worker Institution of Education

ANDHRA UNIVERSITY

Foreign Worker Education Institution Address 1

JUNCTION, ANDHRA UNIVERSITY SOUTH CAMPUS

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

VISAKHAPATNAM

Foreign Worker Education Institution State/Province

PRADESH

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

530003

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Erin P Brown

Preparer Title

Attorney

Preparer Email

ebrown@rbrownllc.com

Employer Information Declaration Name

Kimberly Sloan

Employer Information Declaration Title

Director, Human Resources