Fiscal Year

2023

Case Number

A-22031-04973

Case Status

Certified

Received Date

2022-03-10

Decision Date

2022-11-29

Refile

N

Original File Date

2023-01-01 18:07:38

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

HYVEE, INC.

Employer Name Slug

hyvee-inc

Employer Address 1

5820 WESTOWN PARKWAY

Employer Address 2

Employer City

WEST DES MOINES

Employer City Slug

west-des-moines

Employer State

IOWA

Employer State Slug

iowa

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

50266

Employer Phone

515-267-2800

Employer Number of Employees

21355

Employer Year Commenced Business

1930

NAICS Code

445110

FW Ownership Interest

N

Employer Contact Name

Julie Jensen

Employer Contact Address 1

5820 Westown Parkway

Employer Contact Address 2

Employer Contact City

West Des Moines

Employer Contact State/Province

IOWA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

50266

Employer Contact Phone

515-453-2787

Employer Contact Email

jjensen@hy-vee.com

Agent Attorney Name

Lori T Chesser

Agent Attorney Firm Name

Dentons Davis Brown PC

Agent Attorney Phone

5152882500

Agent Attorney Address 1

215 10th Street, Suite 1300

Agent Attorney Address 2

Agent Attorney City

Des Moines

Agent Attorney State/Province

IOWA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

50309

Agent Attorney Email

Lori.Chesser@dentons.com

PW Track Number

P10021169412089

PW SOC Code

15-1199

PW SOC Title

COMPUTER OCCUPATIONS, ALL OTHER

PW Skill Level

Level IV

PW Wage

88691.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-11-24

PW Expiration Date

2022-06-30

Wage Offer From

115000.00

Wage Offer To

125000.00

Average Salary

120000.00

Wage Unit of Pay

Year

Worksite Address 1

3801 S. JAMES ST.

Worksite Address 2

STE. 400

Worksite City

GRIMES

Worksite City Slug

grimes

Worksite State

IOWA

Worksite Postal Code

50111

Job Title

DATA ENGINEER (ETL DEVELOPER)

Job Title Slug

data-engineer-etl-developer

Minimum Education

Bachelor's

Major Field of Study

COMPUTER SCIENCE, COMPUTER INFORMATION SYSTEMS, OR RELATED FIELD

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

DATA ENGINEER ETL DEVELOPER, DATA ANALYST

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

EXPERIENCE TO INCLUDE 5 YEARS WITH DATA INTEGRATION, DATA CLEANSING, OR DATA SECURITY; MANAGE, MAINTAIN, ANDOR SUPPORT DATA, DATA LOAD ANDOR DATABASE; DEVELOP LOGICAL AND PHYSICAL DATA MODELS; AND ETL. EXPERIENCE TO INCLUDE 3 YEARS WITH SQL SERVER, ORACLE, POSTGRESQL, OR NOSQL MONGO; AND DESIGN AND IMPLEMENT SNOWFLAKE, STAR, AND RELATIONAL DATA MODELS. EXPERIENCE TO INCLUDE 2 YEARS WITH AUTOMATE DATA COLLECTION PROCESS; AZURE, GOOGLE BIGQUERY, ANDOR SNOWFLAKE; AND BUILD TEST CASES.br br SECTIONF.3 ONET OCCUPATIONAL TITLE DATA WAREHOUSING SPECIALISTS 151199.07 WITHIN THE COMPUTER OCCUPATIONS, ALL OTHER 151199 CATEGORY.br br SECTION H.10.B. DATA ENGINEER ETL DEVELOPER, DATA ANALYST, PROGRAMMER ANALYST, OR SIMILAR DUTIES UNDER A DIFFERENT JOB TITLE.

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-12-13

SWA Job Order End Date

2022-01-21

Sunday Edition Newspaper

Y

First Newspaper Name

DES MOINES REGISTER

First Advertisement Start Date

2021-12-19

Second Newspaper Ad Name

DES MOINES REGISTER

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-12-26

Employer Website From Date

2021-12-08

Employer Website To Date

2022-01-24

Professional Organization Ad From Date

2023-01-01 18:07:38

Professional Organization Advertisement To Date

2023-01-01 18:07:38

Job Search Website From Date

2021-12-14

Job Search Website To Date

2021-12-28

Employee Referral Program From Date

2023-01-01 18:07:38

Employee Referral Program To Date

2023-01-01 18:07:38

Local Ethnic Paper From Date

2021-12-16

Local Ethnic Paper To Date

2021-12-16

Radio/TV Ad From Date

2023-01-01 18:07:38

Radio/TV Ad To Date

2023-01-01 18:07:38

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 INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2007

Foreign Worker Institution of Education

DOMINICAN UNIVERSITY

Foreign Worker Education Institution Address 1

7900 DIVISION ST

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

RIVER FOREST

Foreign Worker Education Institution State/Province

IL

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

60305

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

LORI T CHESSER

Preparer Title

ATTORNEY

Preparer Email

LORI.CHESSER@DENTONS.COM

Employer Information Declaration Name

KAREN BORISKEY

Employer Information Declaration Title

VP, HUMAN RESOURCESEMPLOYEE DEVELOPMENT