Fiscal Year

2023

Case Number

A-22049-13363

Case Status

Certified

Received Date

2022-03-28

Decision Date

2022-12-14

Refile

N

Original File Date

2023-01-01 18:01:57

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

WAYFAIR LLC

Employer Name Slug

wayfair-llc

Employer Address 1

100 HUNTINGTON AVENUE

Employer Address 2

4 COPLEY PLACE

Employer City

BOSTON

Employer City Slug

boston

Employer State

MASSACHUSETTS

Employer State Slug

massachusetts

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

2116

Employer Phone

617-502-7273

Employer Number of Employees

16200

Employer Year Commenced Business

2002

NAICS Code

454111

FW Ownership Interest

N

Employer Contact Name

Erin McWilliams

Employer Contact Address 1

100 Huntington Avenue

Employer Contact Address 2

4 Copley Place

Employer Contact City

Boston

Employer Contact State/Province

MASSACHUSETTS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

2116

Employer Contact Phone

617-532-6100

Employer Contact Email

usimmigration@wayfair.com

Agent Attorney Name

Marc I Walsh

Agent Attorney Firm Name

PwC Law LLP

Agent Attorney Phone

4169418383

Agent Attorney Address 1

18 York Street

Agent Attorney Address 2

Suite 2500

Agent Attorney City

Toronto

Agent Attorney State/Province

Ontario

Agent Attorney Country

CANADA

Agent Attorney Postal Code

M5J 0B2

Agent Attorney Email

ca_wayfair_usimmigration@pwc.com

PW Track Number

P10021123280354

PW SOC Code

15-2041

PW SOC Title

Statisticians

PW Skill Level

Level I

PW Wage

76315.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-10-19

PW Expiration Date

2022-06-30

Wage Offer From

76315.00

Wage Offer To

107000.00

Average Salary

91657.50

Wage Unit of Pay

Year

Worksite Address 1

100 Huntington Avenue

Worksite Address 2

4 Copley Place

Worksite City

Boston

Worksite City Slug

boston

Worksite State

MASSACHUSETTS

Worksite Postal Code

2116

Job Title

Analyst 2

Job Title Slug

analyst-2

Minimum Education

Master's

Major Field of Study

Engineering

Required Training

N

Required Experience

Y

Required Experience Months

12

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Comp. Sci., Info. Sys., Econ, Math, Stats, Anlytcs, Ops. Research, or a directly related field

Accept Alternative Combination

Y

Accept Alternative Combination Education

Bachelor's

Accept Alternative Combination Education Years

5

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

12

Accept Alternative Job Title

Analyst, Data Strategy Operations Analyst, or any role in which qualifying experience is gained

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Masters degree or foreign equivalent in Engineering, Computer Science, Information Systems, Economics, Mathematics, Statistics, Analytics, Operations Research, or a directly related field, plus one 1 year of experience in analytics, business intelligence, engineering with quantitative analysis, or data science.br br Will accept a Bachelors degree and five 5 years of described experience in lieu of a Masters degree and one 1 year of experience.br br Experience may be gained before, during, or after issuance of advanced degree.br br Experience must include one 1 year of experience in at least five 5 of the following experience may be gained concurrentlybr br Performing advanced data analytics with programming languages such as SQL, VBA, R, Java, or Python;br Experience creating virtual environments;br Statistical forecasting including building timeseries demand forecasting models;br Preparing data visualization including plots, graphs, or charts showing statistical distributions or experience with Google Data Studio, Looker, Tableau or PowerBI to create dashboards;br GIT for integration or version control;br Advanced Microsoft Excel or Google Sheets including use of pivot tables or macros or experience developing presentations using Visio, Google Slides, or PowerPoint;br Developing business cases and financial strategy for product development, including defining business goals, creating execution steps, or analyzing business return;br Evaluating predictive models including ROI analysis and back testing on historical data;br Scoping potential value and impact of projects and investments through data analysis;br Perform business and process gap analysis to identify improvement opportunities and create development plans;br Creating financial models to identify cost reduction or revenue improvement opportunities.

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

Sunday Edition Newspaper

Y

First Newspaper Name

The Boston Globe

First Advertisement Start Date

2021-12-19

Second Newspaper Ad Name

The Boston Globe

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-12-26

Employer Website From Date

2023-01-01 18:01:57

Employer Website To Date

2023-01-01 18:01:57

Professional Organization Ad From Date

2023-01-01 18:01:57

Professional Organization Advertisement To Date

2023-01-01 18:01:57

Job Search Website From Date

2021-12-17

Job Search Website To Date

2021-12-30

Employee Referral Program From Date

2021-12-16

Employee Referral Program To Date

2022-01-18

Local Ethnic Paper From Date

2023-01-01 18:01:57

Local Ethnic Paper To Date

2023-01-01 18:01:57

Radio/TV Ad From Date

2023-01-01 18:01:57

Radio/TV Ad To Date

2023-01-01 18:01:57

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

OPERATIONS RESEARCH

Foreign Worker Years of Education Completed

2020

Foreign Worker Institution of Education

COLUMBIA UNIVERSITY

Foreign Worker Education Institution Address 1

2960 BROADWAY

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

10027

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Marc I Walsh

Preparer Title

Attorney at Law

Preparer Email

ca_wayfair_usimmigration@pwc.com

Employer Information Declaration Name

Erin McWilliams

Employer Information Declaration Title

Manager, Immigration