Fiscal Year

2021

Case Number

A-20204-79471

Case Status

Certified

Received Date

2020-11-06

Decision Date

2021-05-20

Refile

N

Original File Date

2021-01-01 09:25:34

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

OPEN ROAD INTEGRATED MEDIA

Employer Name Slug

open-road-integrated-media

Employer Address 1

180 MAIDEN LANE

Employer Address 2

SUITE 8A

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

10038

Employer Phone

2126910900

Employer Number of Employees

54

Employer Year Commenced Business

2011

NAICS Code

5111

FW Ownership Interest

N

Employer Contact Name

Edith Appiah-Kumi

Employer Contact Address 1

180 Maiden Lane

Employer Contact Address 2

Suite 8A

Employer Contact City

New York

Employer Contact State/Province

NEW YORK

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

10038

Employer Contact Phone

2126910900

Employer Contact Email

ekumi@openroadmedia.com

Agent Attorney Name

TROY D PALMER

Agent Attorney Firm Name

BARST MUKAMAL KLEINER LLP

Agent Attorney Phone

212-686-3838

Agent Attorney Address 1

2 PARK AVENUE

Agent Attorney Address 2

19TH FLOOR

Agent Attorney City

NEW YORK

Agent Attorney State/Province

NEW YORK

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

10016

Agent Attorney Email

laborfilings@bmkllp.com

PW Track Number

P10020029283967

PW SOC Code

15-2041

PW SOC Title

STATISTICIANS

PW Skill Level

Level III

PW Wage

109824.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-04-22

PW Expiration Date

2020-07-21

Wage Offer From

130000.00

Wage Offer To

0.00

Average Salary

130000.00

Wage Unit of Pay

Year

Worksite Address 1

180 MAIDEN LANE

Worksite Address 2

SUITE 8A

Worksite City

NEW YORK

Worksite City Slug

new-york

Worksite State

NEW YORK

Worksite Postal Code

10038

Job Title

BUSINESS ANALYTICS DIRECTOR

Job Title Slug

business-analytics-director

Minimum Education

Bachelor's

Major Field of Study

BUSINESS, STATISTICS, MATHEMATICS, OR A RELATED FIELD

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

Y

Accept Alternative Combination Education

Master's

Accept Alternative Combination Education Years

3

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

36

Accept Alternative Job Title

BUSINESS MGMT EXP INCL ONE YEAR OF DATA ANALYTICS EXP TWO YEARS OF BUSINESS PLANNING EXP H.14

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Primaary educationalexperiential requirements Bachelors degree in business, statistics, mathematics, or a related field and five years of business management experience, including one year of data analytics experience and two years of business planning experience.br br Alternative educationalexperiential requirements Masters degree in business, statistics, mathematics, or a related field and three years of business management experience, including one year of data analytics experience and two years of business planning experience.br br Skill requirementsbr Demonstrated knowledge of multivariate statistical and machine learning modeling techniques.br Advanced SQL skills for data extraction, manipulation, and insights analysis.br Demonstrated ability to interpret business needs and experience developing strategic, KPIbased analytics.br Experience in operations analysis including business and product requirement analysis.br Proficiency with Google Analytics, Tableau, and Sailthru.br Extensive experience attracting, managing, coaching, and retaining highperforming team members.br Excellent writing and verbal capability to present ideas to others.br Proficient in both Python and R as well as various analytics and modeling modulespackages eg. numpy, pandas, scikitlearn, nltk.br Proficient in Django framework.br Working experience of ETL orchestration tool Airflowbr Knowledge of fine tuning relational databases e.g MySQL, Redshift for high performance.br Knowledge of NonSQL databases e.g. Mongo.br Knowledge of Spark, AWS products S3, EC2, Lambda, and Google Tag Manager.br br Any suitable combination of education, experience, or training is acceptable.

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-05-12

SWA Job Order End Date

2020-06-15

Sunday Edition Newspaper

Y

First Newspaper Name

THE NEW YORK TIMES

First Advertisement Start Date

2020-07-12

Second Newspaper Ad Name

THE NEW YORK TIMES

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-07-19

Employer Website From Date

2020-05-12

Employer Website To Date

2020-08-26

Professional Organization Ad From Date

2021-01-01 09:25:34

Professional Organization Advertisement To Date

2021-01-01 09:25:34

Job Search Website From Date

2020-07-12

Job Search Website To Date

2020-07-26

Employee Referral Program From Date

2021-01-01 09:25:34

Employee Referral Program To Date

2021-01-01 09:25:34

Local Ethnic Paper From Date

2020-07-14

Local Ethnic Paper To Date

2020-07-14

Radio/TV Ad From Date

2021-01-01 09:25:34

Radio/TV Ad To Date

2021-01-01 09:25:34

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

BUSINESS ADMINISTRATION

Foreign Worker Years of Education Completed

2015

Foreign Worker Institution of Education

GEORGETOWN UNIVERSITY

Foreign Worker Education Institution Address 1

3700 O ST. NW

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

WASHINGTON

Foreign Worker Education Institution State/Province

DC

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

20057

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

TROY D PALMER

Preparer Title

ATTORNEY

Preparer Email

tpalmer@bmkllp.com

Employer Information Declaration Name

DANIEL SHEMESH

Employer Information Declaration Title

CHIEF FINANCIAL OFFICER