CERTIFIED H-1B FY 2024

Data Warehouse Developer

GuideOne Insurance Company · West Des Moines, Iowa

Case #I-200-24107-893699

A Data Warehouse Developer position at GuideOne Insurance Company in West Des Moines, Iowa was filed at $109k per year, offering 0% above the prevailing wage of $109k. The case was certified in 7 days during the FY FY2024 cycle. This position is for continued employment.

$109k
Annual Salary
up to $145k
$109k
Prevailing Wage
0.0%
Wage Premium
1
Positions

Filing Details

Case NumberI-200-24107-893699
Case StatusCertified
Visa ClassH-1B
Fiscal YearFY 2024
EmployerGuideOne Insurance Company
Employer LocationWest Des Moines, Iowa
Job TitleData Warehouse Developer
SOC Code15-124300 – Database Architects
WorksiteWest Des Moines, Iowa
Annual Wage$109k – $145k
Prevailing Wage$109k
Wage Premium0.0%
Positions1 (0 new, 1 continued)

Timeline

Apr 16, 2024
Received
Apr 23, 2024
Decision
Jul 21, 2024
Employment Start
Jul 20, 2027
Employment End

More Filings from GuideOne Insurance Company

Job TitleSalaryStatusDate
Software Developer $94k CERTIFIED Jan 13, 2023
Data Warehouse Specialist $67k CERTIFIED Apr 12, 2022
Enterprise Architect $117k CERTIFIED Jan 25, 2022
Actuarial Assistant I $64k CERTIFIED Jan 7, 2022
Software Engineer $106k CERTIFIED Dec 15, 2021

View all GuideOne Insurance Company filings →

Explore More

About This H-1B Filing

This Labor Condition Application (LCA) was filed by GuideOne Insurance Company for the position of Data Warehouse Developer in West Des Moines, Iowa. The offered annual salary is $109k, compared to the prevailing wage of $109k for this occupation and location. This represents a wage premium of 0.0% above the prevailing wage.

The LCA is the first step in the H-1B visa process. Employers must file an LCA with the Department of Labor certifying that they will pay the foreign worker at least the prevailing wage for the occupation in the area of intended employment. A certified LCA is required before the employer can file an H-1B petition with USCIS.

Case status: Certified. This means the Department of Labor has certified that the employer meets the wage and working condition requirements.

Understanding This LCA Filing

A Labor Condition Application (LCA) is a mandatory document that U.S. employers must file with the U.S. Department of Labor (DOL) before they can petition for a foreign worker under the H-1B, H-1B1, or E-3 visa categories. The LCA process was established under the Immigration and Nationality Act (INA) to protect both foreign and domestic workers by ensuring fair wages and working conditions.

Why Employers File LCAs

When a U.S. company identifies a foreign national to fill a specialty occupation position, they must first obtain DOL certification through the LCA process before filing the H-1B petition (Form I-129) with U.S. Citizenship and Immigration Services (USCIS). In this case, GuideOne Insurance Company filed LCA case number I-200-24107-893699 to sponsor a Data Warehouse Developer position at their worksite in West Des Moines, Iowa. By filing this LCA, the employer attests to four key conditions: (1) paying the higher of the actual wage or prevailing wage, (2) providing working conditions that will not adversely affect other similarly employed workers, (3) no strike or lockout at the worksite, and (4) providing notice of the filing to the bargaining representative or posting notice at the worksite.

What Wage Levels Mean

The DOL establishes four wage levels for each occupation and geographic area, representing the progression from entry-level to fully competent workers:

For this filing, the offered wage of $109k compares to the DOL prevailing wage of $109k for Database Architects positions in the West Des Moines, Iowa area. The positive wage premium of 0.0% indicates the employer is offering above the DOL-determined average for this occupation and location.

What is Prevailing Wage?

The prevailing wage is the average wage paid to similarly employed workers in a specific occupation in the area of intended employment. The DOL determines prevailing wages using data from the Occupational Employment and Wage Statistics (OEWS) survey conducted by the Bureau of Labor Statistics (BLS). Employers must pay H-1B workers the higher of the prevailing wage or the actual wage paid to other employees in similar positions at the company. This requirement is designed to prevent employers from using H-1B workers to undercut domestic wages.

How to Interpret This Data

What Certified Means for This Application

A "Certified" status means the DOL has reviewed GuideOne Insurance Company's attestations and determined that the LCA meets all regulatory requirements. The employer has demonstrated that the offered wage of $109k meets or exceeds the prevailing wage for Data Warehouse Developer positions in the West Des Moines, Iowa area. It is important to understand that LCA certification does not guarantee H-1B visa approval. The next step is for the employer to file Form I-129 with USCIS, which evaluates whether the position qualifies as a specialty occupation and whether the beneficiary has the required qualifications.

Processing Time

This LCA was received by the DOL on Apr 16, 2024 and a decision was rendered on Apr 23, 2024, a processing time of approximately 7 business days. The standard DOL processing time for LCA applications is 7 to 10 business days. This application was processed within the standard timeframe.

Comparing to Industry Standards

The offered salary of $109k for this Data Warehouse Developer position provides a data point for evaluating compensation trends in H-1B visa sponsorship. When reviewing H-1B salary data, consider that wages vary significantly based on geographic location, employer size, industry sector, and the worker's experience level. This position falls under SOC code 15-124300 (Database Architects), which standardizes how the Bureau of Labor Statistics classifies occupations across industries. Metropolitan areas like New York, San Francisco, and Seattle typically command higher salaries due to higher costs of living, while positions in smaller markets may offer lower nominal wages but comparable purchasing power.

Frequently Asked Questions

What is the salary for this Data Warehouse Developer position?

The offered annual salary for this Data Warehouse Developer position at GuideOne Insurance Company is $109k to $145k. The Department of Labor prevailing wage for this occupation and location is $109k. The offered wage represents a 0.0% premium over the prevailing wage.

Where is this Data Warehouse Developer job located?

This H-1B filing is for a position located in West Des Moines, Iowa. The employing company, GuideOne Insurance Company, is headquartered in West Des Moines, Iowa.

What visa type is this filing for?

This Labor Condition Application is filed under the H-1B visa classification. The H-1B visa is designed for specialty occupation workers who possess at least a bachelor's degree or equivalent in a specific field related to the job.

Who is the employer for this H-1B filing?

The employer for this filing is GuideOne Insurance Company, located in West Des Moines, Iowa. GuideOne Insurance Company filed this Labor Condition Application (case number I-200-24107-893699) for a Data Warehouse Developer position during fiscal year FY 2024. View all GuideOne Insurance Company H-1B filings.

What does LCA “Certified” mean?

Certified means the U.S. Department of Labor has approved this Labor Condition Application, confirming that GuideOne Insurance Company has attested to meeting all wage and working condition requirements. A certified LCA does not guarantee H-1B visa approval — the employer must still file a separate petition (Form I-129) with USCIS.

Related Guides