Fiscal Year

2021

Case Number

A-21019-43603

Case Status

Certified

Received Date

2021-02-11

Decision Date

2021-07-22

Refile

N

Original File Date

2021-01-01 09:52:18

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

SMARTBARGAINS, INC.

Employer Name Slug

smartbargains-inc

Employer Address 1

20 CHANNEL CENTER STREET

Employer Address 2

3RD FLOOR

Employer City

BOSTON

Employer City Slug

boston

Employer State

MASSACHUSETTS

Employer State Slug

massachusetts

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

2210

Employer Phone

(617) 790-3632

Employer Number of Employees

295

Employer Year Commenced Business

2000

NAICS Code

45411

FW Ownership Interest

N

Employer Contact Name

Cameran McKean

Employer Contact Address 1

20 Channel Center St.

Employer Contact Address 2

3rd Floor

Employer Contact City

Boston

Employer Contact State/Province

MASSACHUSETTS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

2210

Employer Contact Phone

(617) 790-3632

Employer Contact Email

cmckean@ruegiltgroupe.com

Agent Attorney Name

Sarah M Coleman

Agent Attorney Firm Name

Parker Gallini LLP

Agent Attorney Phone

7818108990

Agent Attorney Address 1

460 Totten Pond Road

Agent Attorney Address 2

Suite 350

Agent Attorney City

Waltham

Agent Attorney State/Province

MASSACHUSETTS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

2451

Agent Attorney Email

SColeman@parkergallini.com

PW Track Number

P10020129555967

PW SOC Code

15-2031

PW SOC Title

Operations Research Analysts

PW Skill Level

Level II

PW Wage

74381.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-09-21

PW Expiration Date

2021-06-30

Wage Offer From

115000.00

Wage Offer To

145000.00

Average Salary

130000.00

Wage Unit of Pay

Year

Worksite Address 1

20 Channel Center

Worksite Address 2

3rd Floor

Worksite City

Boston

Worksite City Slug

boston

Worksite State

MASSACHUSETTS

Worksite Postal Code

2210

Job Title

Principal Business Intelligence Engineer

Job Title Slug

principal-business-intelligence-engineer

Minimum Education

Bachelor's

Major Field of Study

Mathematics

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

a related quantitative 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

48

Accept Alternative Job Title

experience in a data analytics field

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Minimum Requirements Bachelors degree in Mathematics or a related quantitative field and 4 years of experience in a data analytics field.br br Must also have I Hands on experience creating data visualizations in Tableau; II Demonstrated understanding how to utilize Tableau features and performance tradeoffs including Level of Detail LOD calculations, blending and others; III Experience writing SQL queries to explore and review quality assurance of data; IV Strong understanding of the Amazon Web Services AWS stack around databases such as S3, Athena, or Redshift.; V Strong knowledge of data warehousing fundamentals; VI Experience with Extract, Transform and Load ETL ELT data including snowflake and oracle; VII Experience building a data pipeline in snowflake; VIII Python experience in a data environment; IX Coursework in Statistics, Computer Science, Linear Algebra, Econometrics and other quantitative principles; X Superior verbal and written communication skills including the ability to communicate effectively to users with different backgrounds and technical skills; XI Robust analytical skills including a track record demonstrating an ability to find a needle in a haystack and being a team player who thrives in a collaborative environment, with a deep focus on customer service.

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-11-25

SWA Job Order End Date

2020-12-28

Sunday Edition Newspaper

Y

First Newspaper Name

The Boston Globe

First Advertisement Start Date

2020-11-29

Second Newspaper Ad Name

The Boston Globe

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-12-06

Employer Website From Date

2020-11-25

Employer Website To Date

2020-12-11

Professional Organization Ad From Date

2021-01-01 09:52:18

Professional Organization Advertisement To Date

2021-01-01 09:52:18

Job Search Website From Date

2020-12-14

Job Search Website To Date

2020-12-21

Employee Referral Program From Date

2021-01-01 09:52:18

Employee Referral Program To Date

2021-01-01 09:52:18

Local Ethnic Paper From Date

2021-01-01 09:52:18

Local Ethnic Paper To Date

2021-01-01 09:52:18

Radio/TV Ad From Date

2021-01-01 09:52:18

Radio/TV Ad To Date

2021-01-01 09:52:18

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

ETHIOPIA

Foreign Worker Birth Country

ETHIOPIA

Class of Admission

H-1B

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

MATHEMATICS AND ECONOMICS

Foreign Worker Years of Education Completed

2014

Foreign Worker Institution of Education

AMHERST COLLEGE

Foreign Worker Education Institution Address 1

202 SEELEY MUDD BUILDING

Foreign Worker Education Institution Address 2

31 QUADRANGLE

Foreign Worker Education Institution City

AMHERST

Foreign Worker Education Institution State/Province

MA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

1002

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Sarah M Coleman

Preparer Title

Attorney

Preparer Email

SColeman@parkergallini.com

Employer Information Declaration Name

Cameran McKean

Employer Information Declaration Title

Human Resources Generalist