Fiscal Year

2021

Case Number

A-20258-99112

Case Status

Certified

Received Date

2020-09-21

Decision Date

2021-04-16

Refile

N

Original File Date

2021-01-01 09:14:10

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

CRH Americas Materials, Inc. fka Oldcastle Mater

Employer Name Slug

crh-americas-materials-inc-fka-oldcastle-mater

Employer Address 1

900 Ashwood Pkwy Suite, 600

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

30338

Employer Phone

770-522-5600

Employer Number of Employees

24100

Employer Year Commenced Business

1978

NAICS Code

2373

FW Ownership Interest

N

Employer Contact Name

Ellie Kim

Employer Contact Address 1

900 Ashwood Pkwy Suite, 600

Employer Contact Address 2

Employer Contact City

Atlanta

Employer Contact State/Province

GEORGIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

30338

Employer Contact Phone

770-392-5484

Employer Contact Email

ellie.kim@na.crh.com

Agent Attorney Name

Hector Galeano

Agent Attorney Firm Name

Littler Mendelson, P.C.

Agent Attorney Phone

3054007500

Agent Attorney Address 1

333 S.E. 2nd Avenue

Agent Attorney Address 2

Suite 2700

Agent Attorney City

Miami

Agent Attorney State/Province

FLORIDA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

33131

Agent Attorney Email

HGaleano@littler.com

PW Track Number

P10019340185127

PW SOC Code

15-1199

PW SOC Title

151199.08 Business Intelligence Analysts

PW Skill Level

Level IV

PW Wage

111966.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-03-24

PW Expiration Date

2020-06-30

Wage Offer From

111966.00

Wage Offer To

0.00

Average Salary

111966.00

Wage Unit of Pay

Year

Worksite Address 1

900 ASHWOOD PARKWAY

Worksite Address 2

SUITE 700

Worksite City

ATLANTA

Worksite City Slug

atlanta

Worksite State

GEORGIA

Worksite Postal Code

30338

Job Title

BUSINESS INTELLIGENCE PROJECT MANAGER

Job Title Slug

business-intelligence-project-manager

Minimum Education

Bachelor's

Major Field of Study

Information Systems, Computer Systems or related

Required Training

N

Required Experience

Y

Required Experience Months

60

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

60

Accept Alternative Job Title

Analyst, Consultant or Project Manager role

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Min. Requirements Bachelors degree or higher in Computer Science, Information Systems, Information Science, Data Science or related field, or foreign equivalent, plus five 5 years of experience in analytical, consulting or project management role. SPECIFIC SKILLS OR OTHER REQUIREMENTS Five 5 years of experience with the following is required Architecture and handson development of Data Warehouses, Data Marts, RDMS and OLAP; Database concepts and Oracle SQL, code repositories, andor analytic functions; SQL and PLSQL; Working with ETL Tools, such as Informatica; Data Quality with handson experience on Informatica Master Data Management tool; Multiple data visualization tools such as SAP, Qlik; Data mining, data transformation, data manipulation with tools andor technologies, Universe Designer, SQL; Performance tuning of complex SQL codes andor visual dashboards; Requirement management, requirement gathering, Use Case diagram, requirement tracking of data related projects; AgileLean development methodologies and managing projects in an Agile environment with experience in different SDLC methodologies; Delivery of projects within budget and specified timeframes while ensuring customer satisfaction, including defining scope and time of any project, assessing risks and making contingency plans, testing Life Cycle to ensure proper quality, evaluating the value before, during and after a project, and resource management; One 1 year of experience or equivalent graduate level coursework with the following is required Statistical models like Linear Regression, Logistical Regression, Nave Bayes, Decision Tree, Apriori, andor NLP; Programming languages like R, Python andor SAS; and, Enterprise Architecture frameworks such as TOGAF, Zachman andor FEA.

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

2020-07-02

SWA Job Order End Date

2020-08-06

Sunday Edition Newspaper

Y

First Newspaper Name

THE ATLANTA JOURNALCONSTITUTION

First Advertisement Start Date

2020-07-05

Second Newspaper Ad Name

THE ATLANTA JOURNALCONSTITUTION

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-07-12

Employer Website From Date

2020-06-17

Employer Website To Date

2020-06-23

Professional Organization Ad From Date

2021-01-01 09:14:10

Professional Organization Advertisement To Date

2021-01-01 09:14:10

Job Search Website From Date

2020-07-05

Job Search Website To Date

2020-08-03

Employee Referral Program From Date

2021-01-01 09:14:10

Employee Referral Program To Date

2021-01-01 09:14:10

Local Ethnic Paper From Date

2020-07-10

Local Ethnic Paper To Date

2020-07-16

Radio/TV Ad From Date

2021-01-01 09:14:10

Radio/TV Ad To Date

2021-01-01 09:14:10

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

INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2016

Foreign Worker Institution of Education

GEORGIA STATE UNIVERSITY

Foreign Worker Education Institution Address 1

33 GILMER STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

ATLANTA

Foreign Worker Education Institution State/Province

GA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

30303

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Hector Galeano

Preparer Title

Attorney at Law

Preparer Email

HGaleano@littler.com

Employer Information Declaration Name

Ellie Kim

Employer Information Declaration Title

HR Manager