Fiscal Year

2024

Case Number

A-22280-35263

Case Status

Certified-Expired

Received Date

2022-12-08

Decision Date

2023-12-18

Refile

N

Original File Date

2024-01-01 00:25:46

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

GUY CARPENTER AND COMPANY, LLC

Employer Name Slug

guy-carpenter-and-company-llc

Employer Address 1

1166 AVENUE OF THE AMERICAS

Employer Address 2

Employer City

NEW YORK

Employer City Slug

new-york

Employer State

NEW YORK

Employer State Slug

new-york

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

10036

Employer Phone

212-345-5000

Employer Number of Employees

1200

Employer Year Commenced Business

1922

NAICS Code

524130

FW Ownership Interest

N

Employer Contact Name

Pamela Keppel

Employer Contact Address 1

121 River Street

Employer Contact Address 2

Employer Contact City

Hoboken

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

7030

Employer Contact Phone

201-284-4970

Employer Contact Email

Pamela.Keppel@mmc.com

Agent Attorney Name

Hyla K Rosenberg

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

212-688-8555

Agent Attorney Address 1

1400 Broadway

Agent Attorney Address 2

Agent Attorney City

New York

Agent Attorney State/Province

NEW YORK

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

10018

Agent Attorney Email

ebrettschneider@fragomen.com

PW Track Number

P10022003804786

PW SOC Code

15-2041

PW SOC Title

Statisticians

PW Skill Level

Level I

PW Wage

71947.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-06-27

PW Expiration Date

2022-09-25

Wage Offer From

120000.00

Wage Offer To

160000.00

Average Salary

140000.00

Wage Unit of Pay

Year

Worksite Address 1

1166 Avenue of the Americas

Worksite Address 2

Worksite City

New York

Worksite City Slug

new-york

Worksite State

NEW YORK

Worksite Postal Code

10036

Job Title

Data Engineer

Job Title Slug

data-engineer

Minimum Education

Bachelor's

Major Field of Study

Applied Urban Science & Informatics, Data Science, Actuarial Science,Computer Engineering or related

Required Training

N

Required Experience

Y

Required Experience Months

36

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

36

Accept Alternative Job Title

Statistician, Data Engineer Fellow, Graduate Engineer, Assistant Resident Engineer, or related

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Must have a Bachelors degree or foreign equivalent in Applied Urban Science and Informatics, Data Science, Actuarial Science, Computer Engineering, or a related field plus three 3 years of progressively responsible experience in the position offered, or as a Statistician, Data Engineer Fellow, Graduate Engineer, Assistant Resident Engineer, or a related position. In meeting the degree requirement, employer will accept a Masters degree in one of the enumerated fields or a related field in lieu of a Bachelors degree. Employer will accept pre or post Masters degree experience.br br Must have three 3 years of experience with all of the followingbr Integrating data from semistructured and unstructured sources;br Communicating technical concepts to nontechnical audience;br Consuming data from a variety of sources including relational databases, APIs, NetApp and other cloud storage services, and FTPs, and formats including Excel, CSV, XML, parquet, and unstructured;br Working with data management;br Working with numerical and statistical models, including regression modeling;br Using programming skills to build data pipelines and dynamic systems;br Developing data ETL Extract, Transform, Load design, implementation, and maintenance; andbr Working with data APIs.br br Must also have two 2 years of experiencebr Working with Python.

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-08-08

SWA Job Order End Date

2022-09-12

Sunday Edition Newspaper

Y

First Newspaper Name

The New York Times

First Advertisement Start Date

2022-08-21

Second Newspaper Ad Name

The New York Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-08-28

Employer Website From Date

2022-07-28

Employer Website To Date

2022-10-24

Professional Organization Ad From Date

2024-01-01 00:25:46

Professional Organization Advertisement To Date

2024-01-01 00:25:46

Job Search Website From Date

2022-08-22

Job Search Website To Date

2022-09-02

Employee Referral Program From Date

2024-01-01 00:25:46

Employee Referral Program To Date

2024-01-01 00:25:46

Local Ethnic Paper From Date

2022-08-26

Local Ethnic Paper To Date

2022-08-26

Radio/TV Ad From Date

2024-01-01 00:25:46

Radio/TV Ad To Date

2024-01-01 00:25:46

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

COSTA RICA

Foreign Worker Birth Country

COSTA RICA

Class of Admission

Not in USA

Foreign Worker Education

Master's

Foreign Worker Information: Major

APPLIED URBAN SCIENCE AND INFORMATICS

Foreign Worker Years of Education Completed

2019

Foreign Worker Institution of Education

NEW YORK UNIVERSITY

Foreign Worker Education Institution Address 1

383 LAFAYETTE STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

NEW YORK

Foreign Worker Education Institution State/Province

NY

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

10003

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Hyla K Rosenberg

Preparer Title

Partner

Preparer Email

ebrettschneider@fragomen.com

Employer Information Declaration Name

Pamela Keppel

Employer Information Declaration Title

Global Mobility Leader