Fiscal Year

2021

Case Number

A-21077-64055

Case Status

Certified

Received Date

2021-04-26

Decision Date

2021-09-14

Refile

N

Original File Date

2021-01-01 10:09:59

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Johnson Johnson Consumer Inc.

Employer Name Slug

johnson-johnson-consumer-inc

Employer Address 1

199 Grandview Road

Employer Address 2

Employer City

Skillman

Employer City Slug

skillman

Employer State

NEW JERSEY

Employer State Slug

new-jersey

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

8558

Employer Phone

7325245931

Employer Number of Employees

132000

Employer Year Commenced Business

2001

NAICS Code

325412

FW Ownership Interest

N

Employer Contact Name

James Kim

Employer Contact Address 1

501 George Street

Employer Contact Address 2

Employer Contact City

New Brunswick

Employer Contact State/Province

NEW JERSEY

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

8933

Employer Contact Phone

7325245931

Employer Contact Email

jkim43@its.jnj.com

Agent Attorney Name

Kane Vongsavanh

Agent Attorney Firm Name

Berry Appleman Leiden LLP

Agent Attorney Phone

469-505-2272

Agent Attorney Address 1

8300 Greensboro Drive

Agent Attorney Address 2

Suite 550

Agent Attorney City

McLean

Agent Attorney State/Province

VIRGINIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

22102

Agent Attorney Email

kvongsavanh@balglobal.com

PW Track Number

P10020132560381

PW SOC Code

15-1121

PW SOC Title

Computer Systems Analysts

PW Skill Level

Level IV

PW Wage

135866.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-08-26

PW Expiration Date

2021-06-30

Wage Offer From

135866.00

Wage Offer To

145866.00

Average Salary

140866.00

Wage Unit of Pay

Year

Worksite Address 1

199 Grandview Road

Worksite Address 2

Worksite City

Skillman

Worksite City Slug

skillman

Worksite State

NEW JERSEY

Worksite Postal Code

8558

Job Title

Business Analyst - IT Lead

Job Title Slug

business-analyst-it-lead

Minimum Education

Bachelor's

Major Field of Study

Engineering, Computer Science, Business, or related field

Required Training

N

Required Experience

Y

Required Experience Months

60

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Engineering, Computer Science, Business, or related 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

60

Accept Alternative Job Title

related occupation

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Employer will accept Bachelors degree in Engineering, Computer Science, Business, or related field, followed by five years of progressive, postbaccalaureate work experience in job offered or five years of progressive, postbaccalaureate work experience in a related occupation. May telecommute from home on occasion. Position requiresbr 1 5 years of experience in IT space specializing in analytics, insights generation and data architecture;br 2 5 years of experience developing business requirements, communicating expectations to crossfunctional development teams, and, documenting data findings that can be easily understood;br 3 3 years of experience developing business intelligence solutions with Tableau;br 4 Commercial data sets, specifically digital data websites, social media, search, advertisement and syndicatedprimary data sets;br 5 SQL and Database skills;br 6 Integration technologies including data migration and packaged applications;br 7 Hadoopbased technologies, big data analytics, AWS technologies RDS, Redshift, and, S3, Google Cloud BigQuery, Visualization software Tableau and Analytics concepts landing zone and data lake;br 8 Data sourcing, data mapping, data profiling, data mining, and, documenting data definitions;br 9 Business requirements, communicate expectations to crossfunctional development teams, and, document data findings;br 10 Experience working in a matrix environment in a complex organization;br 11 Leading or being part of projects utilizing Agile methodology;br 12 IT and business data and analytics processes, including best practices of the industry for analytics in CPG companies;br 13 Delivering or playing a key part in IT Analytics projects;br 14 Experience with developing, maintaining, and using external APIs for various digital sourcesproviders; and,br 15 Ability to develop data architecture integrating diverse cross functional data sets for analysis and visualization in support of business analytics capabilities.

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

SWA Job Order End Date

2021-02-18

Sunday Edition Newspaper

Y

First Newspaper Name

Times Herald

First Advertisement Start Date

2021-02-07

Second Newspaper Ad Name

Times Herald

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-02-14

Employer Website From Date

2021-02-25

Employer Website To Date

2021-03-04

Professional Organization Ad From Date

2021-01-01 10:09:59

Professional Organization Advertisement To Date

2021-01-01 10:09:59

Job Search Website From Date

2021-02-02

Job Search Website To Date

2021-02-16

Employee Referral Program From Date

2021-01-01 10:09:59

Employee Referral Program To Date

2021-01-01 10:09:59

Local Ethnic Paper From Date

2021-02-12

Local Ethnic Paper To Date

2021-02-12

Radio/TV Ad From Date

2021-01-01 10:09:59

Radio/TV Ad To Date

2021-01-01 10:09:59

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

RUSSIA

Foreign Worker Birth Country

RUSSIA

Class of Admission

L-1

Foreign Worker Education

Master's

Foreign Worker Information: Major

APPLIED MATHEMATICS AND COMPUTER SCIENCE

Foreign Worker Years of Education Completed

2008

Foreign Worker Institution of Education

LOMONOSOV MOSCOW STATE UNIVERSITY

Foreign Worker Education Institution Address 1

ULITSA KOLMOGOROVA, 1

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

MOSCOW

Foreign Worker Education Institution State/Province

Foreign Worker Education Institution Country

RUSSIA

Foreign Worker Education Institution Postal Code

119991

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Kane Vongsavanh

Preparer Title

Associate Attorney

Preparer Email

kvongsavanh@balglobal.com

Employer Information Declaration Name

James Kim

Employer Information Declaration Title

Senior Manager, Global Immigration