All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22003-92927
Fiscal year: 2022
Fiscal Year
2022
Case Number
A-22003-92927
Case Status
Certified
Received Date
2022-01-07
Decision Date
2022-08-31
Refile
N
Original File Date
2022-01-01 06:34:59
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
MERCER US INC.
Employer Name Slug
mercer-us-inc
Employer Address 1
121 RIVER STREET
Employer Address 2
Employer City
HOBOKEN
Employer City Slug
hoboken
Employer State
NEW JERSEY
Employer State Slug
new-jersey
Employer Country
UNITED STATES OF AMERICA
Employer Postal Code
7030
Employer Phone
201-284-6561
Employer Number of Employees
24000
Employer Year Commenced Business
2004
NAICS Code
541612
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
2126888555
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
P10021133311508
PW SOC Code
15-2041
PW SOC Title
Statisticians
PW Skill Level
Level II
PW Wage
92019.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2021-10-26
PW Expiration Date
2022-06-30
Wage Offer From
108500.00
Wage Offer To
120060.00
Average Salary
114280.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
Workforce Strategy and Analytics Consultant
Job Title Slug
workforce-strategy-and-analytics-consultant
Minimum Education
Master's
Major Field of Study
Economics, Statistics, or a related field
Required Training
N
Required Experience
N
Required Experience Months
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
N
Accept Alternative Occupation Months
Accept Alternative Job Title
Job Opportunity Requirements Normal
Y
Foreign Language Required
N
Specific Skills
Must have Masters degree or foreign equivalent in Economics, Statistics or a related field.Graduate coursework must include Cleaning, transforming data and conducting exploratory analysis in R using programming packages including baser, ggplot2, and dplyr; Developing, testing and evaluating complex predictive statistical models in R using generalized linear models, shrinkage and selection methods, and diagnostics for multivariate egressions; Performing multivariate statistical inference in R, including confidence intervals and hypothesis testing; Building, optimizing and interpreting results from machine learning algorithms in R, such as clustering and classification algorithms, resampling and crossvalidation techniques; Obtaining, cleaning and maintaining large Excel datasets with complex logic structure, and conducting exploratory data analysis in Excel using tools such as charting, filtering, referencing, data conversion, data validation and conditional formatting; Using advanced Excel functions including INDEX, MATCH, VLOOKUP, INDIRECT, and advanced tools such as pivot tables, arrays and VBA programming to perform data transformations on large datasets; Managing data analytics projects in a team environment, adhering to strict project deadlines and evolving priorities, delivering project results and answering technical questions in front of a large, technical audience; Drafting technical reports that outline a statistical methodology and clearly articulate datadriven findings; and Presenting datadriven findings using data visualization tools such as PowerPoint and RShiny dashboards to technical audience.
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-10-08
SWA Job Order End Date
2021-11-12
Sunday Edition Newspaper
Y
First Newspaper Name
The New York Times
First Advertisement Start Date
2021-10-17
Second Newspaper Ad Name
The New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2021-10-24
Employer Website From Date
2021-10-08
Employer Website To Date
2021-12-15
Professional Organization Ad From Date
2022-01-01 06:34:59
Professional Organization Advertisement To Date
2022-01-01 06:34:59
Job Search Website From Date
2021-10-18
Job Search Website To Date
2021-10-26
Employee Referral Program From Date
2022-01-01 06:34:59
Employee Referral Program To Date
2022-01-01 06:34:59
Local Ethnic Paper From Date
2021-10-20
Local Ethnic Paper To Date
2021-10-20
Radio/TV Ad From Date
2022-01-01 06:34:59
Radio/TV Ad To Date
2022-01-01 06:34:59
Employer Received Payment
N
Posted Notice at Worksite
Y
Layoff in Past Six Months
N
Country of Citizenship
FRANCE
Foreign Worker Birth Country
FRANCE
Class of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker Information: Major
STATISTICS
Foreign Worker Years of Education Completed
2019
Foreign Worker Institution of Education
COLUMBIA UNIVERSITY IN THE CITY OF NEW YORK
Foreign Worker Education Institution Address 1
1140 AMSTERDAM AVENUE
Foreign Worker Education Institution Address 2
205 KENT HALL, MAIL CODE 9202
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/A
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
Annette Baer
Employer Information Declaration Title
Senior Global Mobility Manager, Americas