Fiscal Year

2022

Case Number

A-21202-20213

Case Status

Certified-Expired

Received Date

2021-08-31

Decision Date

2022-02-01

Refile

N

Original File Date

2022-01-01 10:51:50

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

MUNICH AMERICAN REASSURANCE COMPANY

Employer Name Slug

munich-american-reassurance-company

Employer Address 1

56 PERIMETER CENTER EAST

Employer Address 2

Employer City

ATLANTA

Employer City Slug

atlanta

Employer State

GEORGIA

Employer State Slug

georgia

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

30346

Employer Phone

6785145609

Employer Number of Employees

250

Employer Year Commenced Business

1959

NAICS Code

524130

FW Ownership Interest

N

Employer Contact Name

Kirsten Vargo

Employer Contact Address 1

56 Perimeter Center East

Employer Contact Address 2

Employer Contact City

Atlanta

Employer Contact State/Province

GEORGIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

30346

Employer Contact Phone

6785145609

Employer Contact Email

kvargo@marclife.com

Agent Attorney Name

Jason E Burritt

Agent Attorney Firm Name

Seyfarth Shaw LLP

Agent Attorney Phone

(202) 828-3596

Agent Attorney Address 1

975 F Street, N.W

Agent Attorney Address 2

Agent Attorney City

Washington

Agent Attorney State/Province

DISTRICT OF COLUMBIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

20004

Agent Attorney Email

jburritt@seyfarth.com

PW Track Number

P10020203726114

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level I

PW Wage

44179.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-02-23

PW Expiration Date

2021-06-30

Wage Offer From

120000.14

Wage Offer To

0.00

Average Salary

120000.14

Wage Unit of Pay

Year

Worksite Address 1

437 Madison Avenue

Worksite Address 2

Worksite City

New York

Worksite City Slug

new-york

Worksite State

NEW YORK

Worksite Postal Code

10022

Job Title

Data Engineer

Job Title Slug

data-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science, Engineering, Mathematics, Statistics, Economics, or Quantitative Social Science

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

Y

Accept Alternative Combination Education

Master's

Accept Alternative Combination Education Years

0

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

24

Accept Alternative Job Title

supporting backend framework and performing data analysis see H14.

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Bachelors degree or foreign education equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or Quantitative Social Science plus two years of experience supporting backend framework and performing data analysis and scripting for ETL, ReactJS or .NET MVC for User Interface, MySQL and PostgreSQL language for database management system and computing environments with cloud service expertise Azure or AWS with big data technology Spark. Or, in the alternative, Masters degree or foreign education equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or Quantitative Social Science plus zero years of experience supporting backend framework and performing data analysis and scripting for ETL, ReactJS or .NET MVC for User Interface, MySQL and PostgreSQL language for database management system and computing environments with cloud service expertise Azure or AWS with big data technology Spark. Specific skillsother requirements Must also possess the following quantitative experience requirements not applicable to this section Demonstrated experience DE performing data modeling, data access, and data warehousing; DE storing data in a secure and scalable pattern suitable for reuse with MySQL and PostgreSQL relational database and database development technologies with Azure or AWS database services; DE building large scale data pipelines with PySpark for ETL and R or Python for statistical data analysis and Jupyter Notebook services, including papermill, kernel gateway, nbconvert for deploying notebooks as a service; DE using Azure cloud technology with Azure blob storage, Cosmos DB, Azure Functions, App Services for containers, Terraform or alternatively AWS cloud with S3, lambda, EC2, CloudFormation, ECS, Docker, SQS services, to set up secure and robust infrastructure in both application and database level; DE discovering new data sources and data integration into analytical datasets and formal data warehouses; DE performing software engineering using Python Django, Flask, SFTP, scikit learn, pandas, numpy, dask, and docker; and DE performing data manipulation and modelling within the insurance or reinsurance industry, and experience using Azure DevOps or Atlassian Agile Project Management and JIRA DevOps.

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-03-30

SWA Job Order End Date

2021-05-04

Sunday Edition Newspaper

Y

First Newspaper Name

The New York Times

First Advertisement Start Date

2021-04-04

Second Newspaper Ad Name

The New York Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-04-11

Employer Website From Date

2022-01-01 10:51:50

Employer Website To Date

2022-01-01 10:51:50

Professional Organization Ad From Date

2022-01-01 10:51:50

Professional Organization Advertisement To Date

2022-01-01 10:51:50

Job Search Website From Date

2021-04-05

Job Search Website To Date

2021-04-12

Employee Referral Program From Date

2022-01-01 10:51:50

Employee Referral Program To Date

2022-01-01 10:51:50

Local Ethnic Paper From Date

2021-04-07

Local Ethnic Paper To Date

2021-04-07

Radio/TV Ad From Date

2021-04-20

Radio/TV Ad To Date

2021-04-20

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

2016

Foreign Worker Institution of Education

UNIVERSITY OF MASSACHUSETTS DARTMOUTH

Foreign Worker Education Institution Address 1

285 OLD WESTPORT ROAD

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

NORTH DARTMOUTH

Foreign Worker Education Institution State/Province

MA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

2747

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Jason E Burritt

Preparer Title

Partner

Preparer Email

jburritt@seyfarth.com

Employer Information Declaration Name

Kirsten Vargo

Employer Information Declaration Title

HR Manager and Business Partner