All Details of Green Card Application:
Explore Trends, Employment Opportunities, and Insights
Case Number: A-22272-31019
Fiscal year: 2024
Fiscal Year
2024
Case Number
A-22272-31019
Case Status
Certified-Expired
Received Date
2022-12-22
Decision Date
2023-11-30
Refile
N
Original File Date
2024-01-01 00:21:23
Previous SWA Case Number State
Schedule A Sheepherder
N
Employer Name
ZENITH MEDIA SERVICES, INC.
Employer Name Slug
zenith-media-services-inc
Employer Address 1
375 HUDSON STREET
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
10014
Employer Phone
2128595206
Employer Number of Employees
994
Employer Year Commenced Business
1995
NAICS Code
541830
FW Ownership Interest
N
Employer Contact Name
Sandra Labonte
Employer Contact Address 1
384 Northyards Blvd NW
Employer Contact Address 2
Suite 300
Employer Contact City
Atlanta
Employer Contact State/Province
GEORGIA Georgia
Employer Contact Country
UNITED STATES OF AMERICA
Employer Contact Postal Code
30313
Employer Contact Phone
6789164514
Employer Contact Email
sandra.labonte@publicismedia.com
Agent Attorney Name
Kane Vongsavanh
Agent Attorney Firm Name
Berry Appleman Leiden LLP
Agent Attorney Phone
4695052272
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@bal.com
PW Track Number
P10022019838797
PW SOC Code
13-1082.00
PW SOC Title
Project Management Specialists
PW Skill Level
Level II
PW Wage
92290.00
PW Unit of Pay
Year
PW Wage Source
OES
PW Determination Date
2022-07-13
PW Expiration Date
2023-06-30
Wage Offer From
120000.00
Wage Offer To
0.00
Average Salary
120000.00
Wage Unit of Pay
Year
Worksite Address 1
375 Hudson Street
Worksite Address 2
and various, unanticipated sites throughout the U.S.
Worksite City
New York
Worksite City Slug
new-york
Worksite State
NEW YORK
Worksite Postal Code
10014
Job Title
Manager of Data Engineering
Job Title Slug
manager-of-data-engineering
Minimum Education
Master's
Major Field of Study
See H.14
Required Training
N
Required Experience
Y
Required Experience Months
24
Accept Alternative Field of Study
Y
Accept Alternative Major Field of Study
See H.14
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
Related Occupation
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Employer will accept a Masters degree in Computer Science, Information Technology, or a related field followed by two years of experience in the job offered or two years of experience in a related occupation. Experience must include one year of experience in each of the following 1 ETL Experience using various tools SSIS and Data Factory; 2 Google cloud suite Google Big Query, Google cloud storage, Google Data flow; 3 SQL coding, tuning and query optimization, specifically within cloudbased data warehouses MS Azure and Amazon Redshift; 4 Python coding; 5 Working with large data sets for conducting quantitative analysis; 6 Understanding and translating stakeholder needs into creative solutions and delivering solutions; 7 Microsoft Azure cloud suite Function App, Logic Apps, Azure Database, Data Factory; 8 Apache Airflow; 9 Alteryx; 10 SQL Server Management Studio; 11 Salesforce Marketing Cloud 12 Performing code reviews and mentor junior engineers; 13 Microsoft Visual Studio; and 14 Amazon cloud suite Amazon Athena, Amazon Redshift, Amazon S3, EC2. Must be available to work on projects at various, unanticipated sites throughout the United States.
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-08-23
SWA Job Order End Date
2022-09-28
Sunday Edition Newspaper
Y
First Newspaper Name
New York Times
First Advertisement Start Date
2022-08-28
Second Newspaper Ad Name
New York Times
Second Advertisement Type
Newspaper
Second Ad Start Date
2022-09-04
Employer Website From Date
2024-01-01 00:21:23
Employer Website To Date
2024-01-01 00:21:23
Professional Organization Ad From Date
2024-01-01 00:21:23
Professional Organization Advertisement To Date
2024-01-01 00:21:23
Job Search Website From Date
2022-08-23
Job Search Website To Date
2022-09-07
Employee Referral Program From Date
2024-01-01 00:21:23
Employee Referral Program To Date
2024-01-01 00:21:23
Local Ethnic Paper From Date
2022-08-31
Local Ethnic Paper To Date
2022-08-31
Radio/TV Ad From Date
2022-09-03
Radio/TV Ad To Date
2022-09-04
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
COMPUTER SCIENCE
Foreign Worker Years of Education Completed
2017
Foreign Worker Institution of Education
GEORGIA STATE UNIVERSITY
Foreign Worker Education Institution Address 1
33 GILMER ST SE
Foreign Worker Education Institution Address 2
Foreign Worker Education Institution City
ATLANTA
Foreign Worker Education Institution State/Province
GA
Foreign Worker Education Institution Country
UNITED STATES OF AMERICA
Foreign Worker Education Institution Postal Code
30303
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
Senior Associate Immigration Attorney
Preparer Email
kvongsavanh@bal.com
Employer Information Declaration Name
Vasilios Panopoulos
Employer Information Declaration Title
Chief Financial Officer