Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:GUIDEONE INSURANCE
Employer Address_Line 1:1111 ASHWORTH RD
Employer Address_Line 2:
Employer City :WEST DES MOINES
State:
Employer State/ Province:IOWA
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:50265
Employer Phone No.:5152675298
Employer Phone Extent No.:
Total Number of Employees:666
Employer Year of Commenced :
NAICS Code:524126
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Nicole Lee
Employer Contact Address Line1:1111 Ashworth Rd
Employer Contact Address Line2:
Employer Contact City:West Des Moines
Employer Contact State/ Provice:IOWA
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:50265
Employer Contact Phone:5152675298
Employer Contact Email:nlee@guideone.com
Attorney
Agent/ Attorney Name:Lori T Chesser
Agent/ Attorney Firm Name:Dentons Davis Brown PC
Agent/ Attorney Phone:5152882500
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:Dentons Davis Brown PC
Agent/ Attorney Address Line 2:215 10th Street, Suite 1300
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
Position Info
Prevailing Wage Track Number:P10020191704181
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :DATA WAREHOUSING SPECIALISTS
Prevailing Wage Skill Level:Level IV
Prevailing Wage:89149
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-02-09
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:89149
Wage Offer To:138100
Wage Offer Unit of Pay:Year
Workstie Address Line 1:1111 ASHWORTH ROAD
Worksite Address Line 2:
Worksite City :WEST DES MOINES
Worksite State:IOWA
Worksite Postal Code:50265
Job Title:DATA WAREHOUSE DEVELOPER
Minimum Education:Bachelor's
Other Degree/ Diploma:
Major Field of Study:COMPUTER SCIENCE, COMPUTER INFORMATION SYSTEMS*
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :N
Required Expreience Months :
Accept Alternate Field of Study:N
Accept Alternate Major:
Alternate Combination of Education/ Experience:N
Required Alternate Level of Education :
Other Alternate Level of Education:
Acceptable Years of Experience:
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:Y
Acceptable Alternate Occupation Month:60
Accept Alternate Job Title:DATA WAREHOUSE DEVELOPER, PROGRAMMER ANALYST OR SIMILAR DUTIES UNDER A DIFFERENT JOB TITLE
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:EXPERIENCE TO INCLUDE 5 YEARS WITH SSIS; ETL SSIS; SSAS; SSRS; DESIGNING PHYSICAL DATABASES; STAR SCHEMA; SNOWFLAKE SCHEMA; SQL SERVER; DEVELOPING SQL SCRIPTS, PACKAGES, AND PROCEDURES.br br SECTION F.2 AND 3 151199, COMPUTER OCCUPATIONS, ALL OTHER WITH SPECIFIC SOC CODETITLE 151199.07, DATA WAREHOUSING SPECIALISTSbr br SECTION H.4.B. COMPUTER SCIENCE, COMPUTER INFORMATION SYSTEMS, OR ANY SCIENCE OR ENGINEERING FIELD, INCLUDING PHARMACY.
Combination Occupation :N
Offered to Applied Foreign Worker:Y
ForeignWorker Live on Premises :N
Live in Domestic Service Worker:N
Employment Contract :
Professional Occupation :Y
College/ University Teacher:N
Competitive Process:
Basic Recruitment Process :
Teacher Select Date:
Teacher Publish Journal Name:
Additional Recruitment Information:
Job Oder Start Date:2021-06-04
Job Oder End Date:2021-07-06
Sunday Edition Newspaper:Y
First Newspaper Name:DES MOINES REGISTER
First Advertisement Start Date:2021-06-13
Second Newspaper Name:DES MOINES REGISTER
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-06-20
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:2021-06-09
Employer Website to Date:2021-06-23
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:2021-06-10
Job Search Website to Date:2021-06-24
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:
Employee Referral Program to Date:
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:2021-06-17
Local Ethnic Newspaper to Date:2021-06-17
Radio/TV Ad from Date:
Radio/TV Ad to Date:
Employer Received the Payment:N
Payment Details:
Bargaining Representative Notified:N/A
Posted Notice at Worksite:Y
Layoff in Past Six Months:N
US Worker Considered:
Country of Citizenship:INDIA
Foreign Worker Birth Country:INDIA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Bachelor's
Foreign Worker Education Other:
Foreign Worker Major:PHARMACY
Year of Compelted Education:2009
Foreign Worker Istitution of Eduation:RAJIV GANDHI UNIVERSITY OF HEALTH
Foreign Worker Education Instution Address Line 1:4TH T BLOCK EAST
Foreign Worker Education Institution Address Line 2:PATTABHIRAMA NAGAR, JAYANAGAR
