Fiscal Year

2024

Case Number

A-23052-04248

Case Status

Certified

Received Date

2023-05-10

Decision Date

2024-06-03

Refile

N

Original File Date

2024-01-01 01:33:27

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

LAZARD FRERES CO. LLC.

Employer Name Slug

lazard-freres-co-llc

Employer Address 1

30 ROCKEFELLER PLAZA

Employer Address 2

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

10020

Employer Phone

212-632-6500

Employer Number of Employees

3180

Employer Year Commenced Business

1848

NAICS Code

52311

FW Ownership Interest

N

Employer Contact Name

Laura Trivelli

Employer Contact Address 1

30 Rockefeller Plaza

Employer Contact Address 2

49th Floor

Employer Contact City

New York

Employer Contact State/Province

NEW YORK

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

10020

Employer Contact Phone

212-632-6502

Employer Contact Email

laura.trivelli@lazard.com

Agent Attorney Name

Bahadir Ekiz

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy, LLP

Agent Attorney Phone

6469313257

Agent Attorney Address 1

1400 Broadway

Agent Attorney Address 2

9th Floor

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

bekiz@fragomen.com

PW Track Number

P10022158255059

PW SOC Code

15-1243.01

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

163758.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-12-21

PW Expiration Date

2023-06-30

Wage Offer From

165000.00

Wage Offer To

185000.00

Average Salary

175000.00

Wage Unit of Pay

Year

Worksite Address 1

600 5th Avenue

Worksite Address 2

Worksite City

New York

Worksite City Slug

new-york

Worksite State

NEW YORK

Worksite Postal Code

10020

Job Title

Vice President, Senior Data Engineer

Job Title Slug

vice-president-senior-data-engineer

Minimum Education

Master's

Major Field of Study

Computer Science, Information Systems, Information Technology or related.

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

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

Five 5 years of experience in data engineering in the financial services industry.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Masters degree or foreign equivalent in Computer Science, Information Systems, Information Technology or related and five 5 years of experience in data engineering in the financial services industry. Must have 5 years of experience in the following Designing and developing solutions using Datalakes and Datawarehouses such as Snowflake and AWS and selfreporting tools such as Alteryx, Sigma Computing and Tableau to catalog, process, and load data sources supporting ETLELT data pipelines; Using MS SQL Server, SSIS, SQL, Python, SSRS and TableauPowerBI and selfservice reporting tool like Sigma Computing; Collaborating with data architects and business analysts to define specifications and construct selfservice and standardized solutions for business users in the financial services industry; Identifying and developing applications to automate repeatable and manual business tasks to save hours, costs and improve productivity and efficiency; Identifying and executing agile and scrum practices while engineering data solutions to ensure high quality endproduct; Managing full life cycle of business automation projects.

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

2023-03-02

SWA Job Order End Date

2023-04-01

Sunday Edition Newspaper

Y

First Newspaper Name

The New York Times

First Advertisement Start Date

2023-03-05

Second Newspaper Ad Name

The New York Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2023-03-12

Employer Website From Date

2024-01-01 01:33:27

Employer Website To Date

2024-01-01 01:33:27

Professional Organization Ad From Date

2024-01-01 01:33:27

Professional Organization Advertisement To Date

2024-01-01 01:33:27

Job Search Website From Date

2023-03-05

Job Search Website To Date

2023-03-10

Employee Referral Program From Date

2023-03-07

Employee Referral Program To Date

2023-04-04

Local Ethnic Paper From Date

2023-03-06

Local Ethnic Paper To Date

2023-03-06

Radio/TV Ad From Date

2024-01-01 01:33:27

Radio/TV Ad To Date

2024-01-01 01:33:27

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

INDIA

Foreign Worker Birth Country

INDIA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

STEVENS INSTITUTE OF TECHNOLOGY

Foreign Worker Education Institution Address 1

1 CASTLE POINT TERRACE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HOBOKEN

Foreign Worker Education Institution State/Province

NJ

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

7030

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Bahadir Ekiz

Preparer Title

Associate

Preparer Email

bekiz@fragomen.com

Employer Information Declaration Name

Jacqueline M Dinella

Employer Information Declaration Title

Director, Human Resources