Fiscal Year

2023

Case Number

A-22052-13904

Case Status

Certified

Received Date

2022-03-22

Decision Date

2022-12-16

Refile

N

Original File Date

2023-01-01 18:00:30

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

GEORGIAPACIFIC LLC GEORGIAPACIFIC CORPORATION

Employer Name Slug

georgiapacific-llc-georgiapacific-corporation

Employer Address 1

133 PEACHTREE STREET

Employer Address 2

Employer City

ATLANTA

Employer City Slug

atlanta

Employer State

GEORGIA

Employer State Slug

georgia

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

30303

Employer Phone

404-652-4475

Employer Number of Employees

1220

Employer Year Commenced Business

1927

NAICS Code

322121

FW Ownership Interest

N

Employer Contact Name

Shannon McClung

Employer Contact Address 1

133 Peachtree Street

Employer Contact Address 2

Employer Contact City

Atlanta

Employer Contact State/Province

GEORGIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

30303

Employer Contact Phone

404-652-4475

Employer Contact Email

shannon.mcclung@kochgs.com

Agent Attorney Name

Kelly ReskeEspineli

Agent Attorney Firm Name

EY Law LLP

Agent Attorney Phone

416 932 6069

Agent Attorney Address 1

100 Adelaide St. West

Agent Attorney Address 2

Floor 31

Agent Attorney City

Toronto

Agent Attorney State/Province

Ontario

Agent Attorney Country

CANADA

Agent Attorney Postal Code

M5H 0B3

Agent Attorney Email

uspccentral@ca.ey.com

PW Track Number

P10021111245393

PW SOC Code

15-1132

PW SOC Title

Software Developers, Applications

PW Skill Level

Level IV

PW Wage

122616.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-11-17

PW Expiration Date

2022-06-30

Wage Offer From

140000.00

Wage Offer To

0.00

Average Salary

140000.00

Wage Unit of Pay

Year

Worksite Address 1

133 Peachtree St. NE

Worksite Address 2

Worksite City

Atlanta

Worksite City Slug

atlanta

Worksite State

GEORGIA

Worksite Postal Code

30303

Job Title

Senior BI Architect

Job Title Slug

senior-bi-architect

Minimum Education

Bachelor's

Major Field of Study

Electronic Engineering, Computer Science, or a related IT field

Required Training

N

Required Experience

Y

Required Experience Months

84

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Electronic Engineering, Computer Science, or a related IT 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

84

Accept Alternative Job Title

Any closely related occupation

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Employer requires a Bachelors degree in Electronic Engineering, Computer Science, or a related IT field and seven 7 years of experience in the job offered, or as a Software Engineer, Senior Associate, BI Developer, or related position in Business Intelligence.br br Employer requiresbr br 7 years of experience using Microsoft Power BI or Microsoft SQL Server Analysis Services;br 5 years of experience with Relational Databases such as TSQL, Redshirt, PLpgSQL;br 5 years of experience building and modeling Tabular models in Power BI;br 5 years of experience with Power BI .rdl and pbix where the data source is a tabular model;br 5 years of experience in DAX;br 5 years of experience in SQL;br 3 years of experience using tools such as Tabular Editor;br 2 years of experience with Kimball methodology;br 2 years of experience in Database design;br 2 years of experience in deploying BI solutions via CICD;br 2 years of experience in building data warehouses describing enterprise supply chain and logistics, order to cash, financial planning, general ledger accounting and process manufacturing;br 2 years of programming experience in at least one of the following C#, Python, Java, or JavaScript; andbr 1 year of experience using Amazon Redshift.br br Up to 10 domestic travel required.br br 100 telecommuting permitted.

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

SWA Job Order End Date

2022-01-17

Sunday Edition Newspaper

Y

First Newspaper Name

THE ATLANTA JOURNALCONSTITUTION

First Advertisement Start Date

2021-12-26

Second Newspaper Ad Name

THE ATLANTA JOURNALCONSTITUTION

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-01-02

Employer Website From Date

2023-01-01 18:00:30

Employer Website To Date

2023-01-01 18:00:30

Professional Organization Ad From Date

2023-01-01 18:00:30

Professional Organization Advertisement To Date

2023-01-01 18:00:30

Job Search Website From Date

2021-12-26

Job Search Website To Date

2022-01-09

Employee Referral Program From Date

2023-01-01 18:00:30

Employee Referral Program To Date

2023-01-01 18:00:30

Local Ethnic Paper From Date

2022-01-07

Local Ethnic Paper To Date

2022-01-13

Radio/TV Ad From Date

2023-01-01 18:00:30

Radio/TV Ad To Date

2023-01-01 18:00:30

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

ELECTRICAL ENGINEERING

Foreign Worker Years of Education Completed

2011

Foreign Worker Institution of Education

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Foreign Worker Education Institution Address 1

ASHOK NAGAR, KUKATPALLY HOUSING BOARD COLONY, KUKATPALLY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HYDERABAD

Foreign Worker Education Institution State/Province

TELANGANA

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

500085

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Kelly ReskeEspineli

Preparer Title

Attorney

Preparer Email

uspccentral@ca.ey.com

Employer Information Declaration Name

Shannon Anne McClung

Employer Information Declaration Title

Immigration Specialist