Fiscal Year

2023

Case Number

A-22210-96907

Case Status

Withdrawn

Received Date

2022-09-16

Decision Date

2022-11-21

Refile

N

Original File Date

2023-01-01 18:09:43

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

Compass Management Holdings, LLC.

Employer Name Slug

compass-management-holdings-llc

Employer Address 1

90 Fifth Avenue

Employer Address 2

3rd Floor

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

10011

Employer Phone

9292957172

Employer Number of Employees

750

Employer Year Commenced Business

2012

NAICS Code

511210

FW Ownership Interest

N

Employer Contact Name

Julie Ram

Employer Contact Address 1

90 Fifth Avenue, 3rd Floor

Employer Contact Address 2

3rd Floor

Employer Contact City

New York

Employer Contact State/Province

NEW YORK

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

10462

Employer Contact Phone

929-295-7172

Employer Contact Email

julie.ram@compass.com

Agent Attorney Name

David Duong

Agent Attorney Firm Name

Fragomen, Del Rey, Bernsen Loewy

Agent Attorney Phone

972-233-6646

Agent Attorney Address 1

5080 Spectrum Drive

Agent Attorney Address 2

Suite 850W

Agent Attorney City

Addison

Agent Attorney State/Province

TEXAS

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

75001

Agent Attorney Email

dduong@fragomen.com

PW Track Number

P10021238547345

PW SOC Code

15-1199

PW SOC Title

Database Warehousing Specialist

PW Skill Level

Level II

PW Wage

102107.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-05-09

PW Expiration Date

2022-08-07

Wage Offer From

103000.00

Wage Offer To

189400.00

Average Salary

146200.00

Wage Unit of Pay

Year

Worksite Address 1

1313 14th Street NW

Worksite Address 2

Worksite City

Washington

Worksite City Slug

washington

Worksite State

DISTRICT OF COLUMBIA

Worksite Postal Code

20035

Job Title

Senior Data Engineer I

Job Title Slug

senior-data-engineer-i

Minimum Education

Master's

Major Field of Study

Computer Science, Software Engineering, Data Analytics, or related field

Required Training

N

Required Experience

Y

Required Experience Months

24

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

24

Accept Alternative Job Title

Analyst, Software, Datasets, Engineering, or related field.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Employer will accept any suitable combination of education, training, or experience.br br Experience in H.6 or H.10 to involve 1 SQL; Python; DAX; Powershell and batch scripts; Automation; Data Modeling; ETL design; Technologies AWS based services; Snowflake; 2 building data models by considering the business needs and communicating with various teams stakeholders; 3 working on advanced SQL and Python scripts to perform various Extract, Transform and Load ETL operations while prioritizing data integrity and quality; and 4 working with cloudbased data warehousing solutions like Snowflake and expertise in orchestrating jobsprocesses without users experiencing issues.

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

2022-05-12

SWA Job Order End Date

2022-06-20

Sunday Edition Newspaper

Y

First Newspaper Name

The Washington Post

First Advertisement Start Date

2022-05-22

Second Newspaper Ad Name

The Washington Post

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-05-29

Employer Website From Date

2023-01-01 18:09:43

Employer Website To Date

2023-01-01 18:09:43

Professional Organization Ad From Date

2022-05-23

Professional Organization Advertisement To Date

2022-06-22

Job Search Website From Date

2022-05-22

Job Search Website To Date

2022-06-24

Employee Referral Program From Date

2023-01-01 18:09:43

Employee Referral Program To Date

2023-01-01 18:09:43

Local Ethnic Paper From Date

2022-05-25

Local Ethnic Paper To Date

2022-05-25

Radio/TV Ad From Date

2023-01-01 18:09:43

Radio/TV Ad To Date

2023-01-01 18:09:43

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

SOFTWARE ENGINEERING

Foreign Worker Years of Education Completed

2018

Foreign Worker Institution of Education

GEORGE MASON UNIVERSITY

Foreign Worker Education Institution Address 1

4400 UNIVERSITY DR

Foreign Worker Education Institution Address 2

FAIRFAX

Foreign Worker Education Institution City

VIRGINIA

Foreign Worker Education Institution State/Province

VA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

22030

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

David Duong

Preparer Title

Attorney

Preparer Email

dduong@fragomen.com

Employer Information Declaration Name

Julie Ram

Employer Information Declaration Title

PC Operations Specialist