Fiscal Year

2023

Case Number

A-22104-40619

Case Status

Certified

Received Date

2022-06-30

Decision Date

2023-02-22

Refile

N

Original File Date

2023-01-01 08:05:45

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

Vialto Partners LLP

Agent Attorney Phone

4169418383

Agent Attorney Address 1

18 York Street

Agent Attorney Address 2

Suite 2600

Agent Attorney City

Toronto

Agent Attorney State/Province

Ontario

Agent Attorney Country

CANADA

Agent Attorney Postal Code

M5J0B2

Agent Attorney Email

ca_wayfair_usimmigration@vialto.com

PW Track Number

P10021123280359

PW SOC Code

13-2099

PW SOC Title

Financial Quantitative Analysts

PW Skill Level

Level II

PW Wage

85363.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-01-12

PW Expiration Date

2022-06-30

Wage Offer From

105000.00

Wage Offer To

125000.00

Average Salary

115000.00

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

Analytics Manager

Job Title Slug

analytics-manager

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, Maths, Stats, Analytics, Ops Research or rel.

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

Any role in which qualifying experience is gained

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Requires a 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 experience operating with large datasets or conducting high impact data analysis.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 Driving high impact quantitative analysis by leveraging SQL, VBA, R, Java, Python, SPSS, SAS, Hadoop, Excel, Looker, MS Access, MS Excel, Tableau or similar tools;br Utilizing advanced Excel, including manipulating data sets, or performing regression functions for data analysis;br Leading development of Big Data Analytics solutions leveraging advanced data analysis techniques for large quantities of structured and unstructured data;br Advanced database skills using SQL, Vertica, MSSQL, Oracle, or MySQL environments;br Utilizing large enterprise systems to enable data sharing and ensure data accuracy;br Building and analyzing predictive models using historical data, ROI analysis, or back testing to predict service targets, issue resolution segments, or operating expenditure;br Creating and managing data visualization dashboards for business reporting;br Use SQL, Python, SAS or R to create analyses or tools that point to the most significant business growth opportunities;br Automating manual processes; andbr Developing internal and external customerfacing solution documents including knowledge base articles, blogs, whitepapers, orbr training documents.

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

SWA Job Order End Date

2022-03-22

Sunday Edition Newspaper

Y

First Newspaper Name

The Boston Globe

First Advertisement Start Date

2022-02-20

Second Newspaper Ad Name

The Boston Globe

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-02-27

Employer Website From Date

2023-01-01 08:05:45

Employer Website To Date

2023-01-01 08:05:45

Professional Organization Ad From Date

2023-01-01 08:05:45

Professional Organization Advertisement To Date

2023-01-01 08:05:45

Job Search Website From Date

2022-02-17

Job Search Website To Date

2022-03-02

Employee Referral Program From Date

2022-02-15

Employee Referral Program To Date

2022-03-07

Local Ethnic Paper From Date

2023-01-01 08:05:45

Local Ethnic Paper To Date

2023-01-01 08:05:45

Radio/TV Ad From Date

2023-01-01 08:05:45

Radio/TV Ad To Date

2023-01-01 08:05:45

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

DATA ANALYTICS AND MARKETING

Foreign Worker Years of Education Completed

2018

Foreign Worker Institution of Education

BRANDEIS UNIVERSITY

Foreign Worker Education Institution Address 1

415 SOUTH STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

WALTHAM

Foreign Worker Education Institution State/Province

MA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

2453

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@vialto.com

Employer Information Declaration Name

Erin McWilliams

Employer Information Declaration Title

Manager, US Immigration