119 certified Labor Condition Applications on file with the U.S. Department of Labor, FY2022–FY2026.
Since September 2025, DOL's Project Firewall opens H-1B investigations without waiting for a complaint. These checkpoints come from American Financial Group, Great American Insurance Company's own public LCA filings (FY2024–FY2026) — the same records an investigator pulls first.
Next end date: 2026-10-25. Employing an H-1B worker past the LCA end date without a new certified LCA is a strict-liability violation — the replacement LCA must be certified before the I-129 extension is filed.
Each worksite needs its own 10-business-day LCA notice and a PAF record of that posting; a move to a new area of intended employment needs a new LCA before the worker starts there.
Level I is the entry-level prevailing-wage tier and the band DOL's Project Firewall reviews first for misclassification (senior duties filed at an entry-level wage). The national share is 17%.
Median offered wage is 12% above the DOL prevailing wage across 74 recent certified LCAs. Paying at the floor is lawful, but it invites the question of whether the wage level itself is right.
Public DOL disclosure data can lag actual filings by a quarter. Descriptive only — not legal advice.
Yes — American Financial Group, Great American Insurance Company is an active H-1B sponsor, with 119 certified LCAs on file (FY2022–FY2026), including 3 in FY2026. The median certified salary is $123,018 (P25 $109,502, P75 $140,000). With a 37% transfer share, this employer actively accepts H-1B transfers. 100% of its certified filings meet or exceed the prevailing wage.
American Financial Group, Great American Insurance Company H-1B sponsorship at a glance, from public U.S. DOL LCA disclosure data (FY2022–FY2026).
Certified LCAs are a prerequisite to H-1B petitions, not visa approvals; one LCA can cover multiple workers. Descriptive only — not legal advice.
The shaded band is the middle half of certified salaries (P25–P75); the bar spans the lowest to highest certified salary.
Levels I–IV are DOL prevailing-wage experience tiers; 76% of filings are senior-level (III–IV).
| Fiscal year | Certified | Denied | Withdrawn | Total |
|---|---|---|---|---|
| FY2022 | 21 | 0 | 1 | 22 |
| FY2023 | 24 | 0 | 1 | 25 |
| FY2024 | 28 | 0 | 0 | 28 |
| FY2025 | 43 | 0 | 0 | 43 |
| FY2026 | 3 | 0 | 0 | 3 |
Case dispositions from the U.S. DOL OFLC disclosure files. Withdrawn are LCAs that were certified and later withdrawn by the employer; they still count toward Total.
| Job title | Salary | Level | Location | Filed | Status |
|---|---|---|---|---|---|
Senior Application Engineer I-200-25315-397956 | $119,542/yr | II | Stuart, FL | Nov 11, 2025 | Certified |
Senior Technical Analyst I-200-25308-371256 | $128,500/yr | III | Cincinnati, OH | Nov 04, 2025 | Certified |
Technical Analyst Manager I-200-25307-361280 | $171,148/yr | IV | Cincinnati, OH | Nov 03, 2025 | Certified |
Senior Application Engineer II I-200-25254-301758 | $125,000/yr | III | Fairfield Township, OH | Sep 11, 2025 | Certified |
Application Engineering Consultant I-200-25252-296827 | $164,975/yr | IV | Cincinnati, OH | Sep 09, 2025 | Certified |
Data Engineering Specialist I-200-25252-296989 | $146,340/yr | IV | Cincinnati, OH | Sep 09, 2025 | Certified |
Quality Assurance Engineering Specialist I-200-25245-280299 | $128,520/yr | IV | Cincinnati, OH | Sep 02, 2025 | Certified |
Business Analysis Specialist I-200-25238-268335 | $134,338/yr | III | Cincinnati, OH | Aug 26, 2025 | Certified |
Senior Data Engineer I-200-25212-212830 | $126,090/yr | II | Ashburn, VA | Jul 31, 2025 | Certified |
Database Administrator Manager I-200-25204-194420 | $175,534/yr | IV | Cincinnati, OH | Jul 23, 2025 | Certified |
Senior Data Engineer I-200-25202-188223 | $124,800/yr | I | Ashburn, VA | Jul 21, 2025 | Certified |
Senior Database Administrator I-200-25189-158612 | $143,325/yr | IV | Winter Garden, FL | Jul 08, 2025 | Certified |
Technical Analysis Specialist I-200-25183-148305 | $162,630/yr | IV | Edison, NJ | Jul 02, 2025 | Certified |
Senior Quality Assurance Analyst I-200-25168-102232 | $102,700/yr | III | Delaware, OH | Jun 17, 2025 | Certified |
Data Scientist I-200-25153-039624 | $122,003/yr | III | Shrewsbury, MA | Jun 02, 2025 | Certified |
Associate Business Analyst I-200-25148-025609 | $70,087/yr | II | Cincinnati, OH | May 28, 2025 | Certified |
Senior Data Developer I-200-25134-975668 | $135,626/yr | IV | Cincinnati, OH | May 14, 2025 | Certified |
Senior Data Scientist I-200-25122-930671 | $136,390/yr | III | Los Angeles, CA | May 02, 2025 | Certified |
Scrum Master Specialist I-200-25112-889327 | $162,261/yr | III | Cincinnati, OH | Apr 22, 2025 | Certified |
Data Engineer I-200-25112-889502 | $91,800/yr | II | Cincinnati, OH | Apr 22, 2025 | Certified |
Associate Technical Product Manager I-200-25112-889458 | $90,252/yr | II | Cincinnati, OH | Apr 22, 2025 | Certified |
Application Engineer I-200-25112-889667 | $104,030/yr | II | Cincinnati, OH | Apr 22, 2025 | Certified |
Senior Data Scientist I-200-25112-889557 | $148,618/yr | IV | Cincinnati, OH | Apr 22, 2025 | Certified |
Actuarial Analyst I-200-25112-889275 | $76,336/yr | I | Cincinnati, OH | Apr 22, 2025 | Certified |
Technical Analyst I-200-25112-889404 | $97,850/yr | III | Cincinnati, OH | Apr 22, 2025 | Certified |
Associate Product Analyst I-202-25108-880946 | $69,680/yr$33/hr as filed | I | Bellevue, WA | Apr 18, 2025 | Certified |
Senior Quality Assurance Analyst I-200-25106-869919 | $109,200/yr | II | Cincinnati, OH | Apr 16, 2025 | Certified |
Senior Quality Assurance Analyst I-200-25105-864568 | $100,000/yr | II | Cincinnati, OH | Apr 15, 2025 | Certified |
Senior Data Engineer I-200-25097-838493 | $114,134/yr | III | Cincinnati, OH | Apr 07, 2025 | Certified |
Strategic Partnership Analyst I-200-25090-814044 | $100,295/yr | II | Cincinnati, OH | Mar 31, 2025 | Certified |
Senior Quality Assurance Analyst I-200-25085-804318 | $109,200/yr | II | Cincinnati, OH | Mar 26, 2025 | Certified |
Senior Business Analyst II I-200-25085-804184 | $119,600/yr | III | Cincinnati, OH | Mar 26, 2025 | Certified |
Data Engineering Specialist I-200-25073-775764 | $150,000/yr | IV | Cincinnati, OH | Mar 14, 2025 | Certified |
Senior Business Analyst II I-200-25073-777636 | $117,832/yr | III | Cincinnati, OH | Mar 14, 2025 | Certified |
System/Network Engineering Specialist I-200-25048-699330 | $163,494/yr | IV | Fort Mill, SC | Feb 17, 2025 | Certified |
Application Engineering Consultant I-200-25029-650351 | $159,791/yr | IV | Cincinnati, OH | Jan 29, 2025 | Certified |
Data Engineering Specialist I-200-25023-638037 | $158,902/yr | IV | West Chester, OH | Jan 23, 2025 | Certified |
Senior Quality Assurance Engineer I-200-25023-638003 | $90,920/yr | III | Cincinnati, OH | Jan 23, 2025 | Certified |
Data Developer/Analyst Specialist I-200-25008-603263 | $162,438/yr | IV | Cincinnati, OH | Jan 08, 2025 | Certified |
Senior Application Analyst and Developer II I-200-24351-546257 | $109,212/yr | II | Cincinnati, OH | Dec 16, 2024 | Certified |
Data Developer/Analyst Specialist I-200-24319-475549 | $162,595/yr | IV | Cincinnati, OH | Nov 14, 2024 | Certified |
App Analysis and Development Specialist I-200-24312-459752 | $142,465/yr | IV | Cincinnati, OH | Nov 07, 2024 | Certified |
Senior Application Analyst and Developer I-200-24312-459775 | $118,553/yr | III | Cincinnati, OH | Nov 07, 2024 | Certified |
App Analysis and Development Specialist I-200-24296-424284 | $121,573/yr | III | Cincinnati, OH | Oct 22, 2024 | Certified |
App Analysis and Development Specialist I-200-24289-407049 | $138,762/yr | IV | Cincinnati, OH | Oct 15, 2024 | Certified |
Senior Database Administrator I-200-24284-399454 | $135,098/yr | IV | Cincinnati, OH | Oct 10, 2024 | Certified |
Senior Database Administrator I-200-24262-346445 | $135,098/yr | III | Cincinnati, OH | Sep 18, 2024 | Certified |
Data Developer/Analyst Consultant I-200-24228-270557 | $169,050/yr | IV | Cincinnati, OH | Aug 15, 2024 | Certified |
Senior Application Analyst and Developer II I-200-24225-260307 | $128,750/yr | III | Cincinnati, OH | Aug 12, 2024 | Certified |
Application Analyst and Developer I-200-24200-206414 | $90,000/yr | I | Cincinnati, OH | Jul 18, 2024 | Certified |
Senior Application Analyst and Developer II I-200-24194-192231 | $130,000/yr | III | Cincinnati, OH | Jul 12, 2024 | Certified |
App Analysis and Development Specialist I-200-24193-188875 | $130,258/yr | II | Cincinnati, OH | Jul 11, 2024 | Certified |
Quality Assurance Specialist I-200-24184-167542 | $124,032/yr | III | Cincinnati, OH | Jul 02, 2024 | Certified |
Technical Analyst I-200-24134-988635 | $96,900/yr | III | Cincinnati, OH | May 13, 2024 | Certified |
Business Process Analyst I-200-24134-988503 | $78,540/yr | II | Cincinnati, OH | May 13, 2024 | Certified |
Financial Products Underwriter I-200-24134-988695 | $78,000/yr | II | Cincinnati, OH | May 13, 2024 | Certified |
Data Developer/Analyst I-200-24131-982602 | $111,650/yr | III | Cincinnati, OH | May 10, 2024 | Certified |
Senior Application Analyst and Developer I-200-24131-981768 | $115,633/yr | III | Cincinnati, OH | May 10, 2024 | Certified |
Senior Business Analyst II I-200-24114-915278 | $105,609/yr | II | Cincinnati, OH | Apr 23, 2024 | Certified |
Senior Technical Analyst II I-200-24106-888215 | $126,580/yr | III | Cincinnati, OH | Apr 15, 2024 | Certified |
Senior Application Analyst and Developer I-200-24088-836650 | $125,000/yr | III | Cincinnati, OH | Mar 28, 2024 | Certified |
ClaimCenter Cloud Developer I-200-24066-775480 | $120,000/yr | III | Cincinnati, OH | Mar 06, 2024 | Certified |
Data Scientist I-200-24036-692637 | $115,000/yr | III | Windsor, CT | Feb 05, 2024 | Certified |
Data Developer Specialist I-200-24032-685632 | $150,000/yr | IV | Cincinnati, OH | Feb 01, 2024 | Certified |
Senior Application Analyst and Developer I-200-24012-636715 | $110,000/yr | III | Cincinnati, OH | Jan 12, 2024 | Certified |
Application Supervisor I-200-23354-581845 | $109,792/yr | I | Cincinnati, OH | Dec 20, 2023 | Certified |
Data Developer/Analyst Consultant I-200-23354-582101 | $160,000/yr | IV | Cincinnati, OH | Dec 20, 2023 | Certified |
Application Supervisor I-200-23324-514610 | $130,018/yr | IV | Cincinnati, OH | Nov 20, 2023 | Certified |
Senior Application Analyst and Developer II I-200-23300-460598 | $118,773/yr | III | Cincinnati, OH | Oct 27, 2023 | Certified |
Senior Application Analysis and Developer II I-200-23299-457763 | $132,000/yr | IV | Cincinnati, OH | Oct 26, 2023 | Certified |
Senior Application Architect I-200-23299-457945 | $187,509/yr | IV | Cincinnati, OH | Oct 26, 2023 | Certified |
Senior Technical Analyst II I-200-23299-458021 | $127,901/yr | IV | Cincinnati, OH | Oct 26, 2023 | Certified |
Senior Data Developer/Analyst I-200-23270-385091 | $145,000/yr | IV | Mckinney, TX | Sep 27, 2023 | Certified |
Data Engineer I-200-23270-384758 | $120,000/yr | III | Cincinnati, OH | Sep 27, 2023 | Certified |
Data Development Specialist I-200-23198-192729 | $145,000/yr | IV | Cincinnati, OH | Jul 17, 2023 | Certified |
Technical Analysis Specialist I-200-23156-077712 | $150,000/yr | IV | Edison, NJ | Jun 05, 2023 | Certified |
Data Development Director I-200-23153-073003 | $185,855/yr | IV | Cincinnati, OH | Jun 02, 2023 | Certified |
Application Analyst and Developer I-200-23142-042794 | $110,000/yr | III | Delray Beach, FL | May 22, 2023 | Certified |
Application Analyst and Developer I-200-23142-041966 | $110,000/yr | III | Cincinnati, OH | May 22, 2023 | Withdrawn |
Quality Assurance Engineering Specialist I-200-23138-033426 | $120,000/yr | IV | Cincinnati, OH | May 18, 2023 | Certified |
Senior Quality Assurance Analyst I-200-23138-034140 | $104,737/yr | III | Cincinnati, OH | May 18, 2023 | Certified |
App Analysis and Development Specialist I-200-23129-005049 | $120,000/yr | IV | Cincinnati, OH | May 09, 2023 | Certified |
Senior Application Analyst and Developer I-200-23122-983572 | $88,510/yr | II | Cincinnati, OH | May 02, 2023 | Certified |
App Analysis and Development Specialist I-200-23122-984495 | $121,573/yr | IV | Cincinnati, OH | May 02, 2023 | Certified |
Application Analyst and Developer I-200-23103-930819 | $99,750/yr | II | Cincinnati, OH | Apr 13, 2023 | Certified |
Senior Application Analyst and Developer I-200-23076-857884 | $125,000/yr | IV | Cincinnati, OH | Mar 17, 2023 | Certified |
Application Analysis and Development Consultant I-200-23019-712916 | $150,000/yr | III | Cincinnati, OH | Jan 19, 2023 | Certified |
Senior Quality Assurance Analyst I-200-22335-615419 | $95,000/yr | III | Delaware, OH | Dec 01, 2022 | Certified |
Senior Database Administrator I-200-22332-606901 | $130,000/yr | IV | Winter Garden, FL | Nov 28, 2022 | Certified |
Data Scientist I-200-22308-570238 | $115,000/yr | III | Cincinnati, OH | Nov 04, 2022 | Certified |
Data Scientist I-200-22299-552303 | $115,000/yr | III | Cincinnati, OH | Oct 26, 2022 | Certified |
Senior Application Analyst and Developer II I-200-22291-535103 | $130,000/yr | III | Cincinnati, OH | Oct 18, 2022 | Certified |
Quality Assurance Specialist I-200-22276-506455 | $115,000/yr | III | Cincinnati, OH | Oct 03, 2022 | Certified |
Business Analysis Specialist I-200-22259-476946 | $120,257/yr | IV | Cincinnati, OH | Sep 16, 2022 | Certified |
Application Analysis & Development Specialist I-200-22258-474394 | $127,018/yr | IV | Cincinnati, OH | Sep 15, 2022 | Certified |
Technical Analysis Specialist I-200-22256-469787 | $150,034/yr | IV | Cincinnati, OH | Sep 13, 2022 | Certified |
Technical Analysis Specialist I-200-22256-469757 | $150,034/yr | IV | Cincinnati, OH | Sep 13, 2022 | Certified |
Senior Quality Assurance Analyst I-200-22249-456653 | $100,000/yr | II | Louisville, KY | Sep 06, 2022 | Certified |
Senior Database Administrator I-200-22224-413333 | $118,039/yr | IV | Cincinnati, OH | Aug 12, 2022 | Certified |
Data Developer Specialist I-200-22199-357898 | $150,000/yr | III | Cincinnati, OH | Jul 18, 2022 | Certified |
Senior Quality Assurance Analyst I-200-22199-357841 | $86,000/yr | II | Cincinnati, OH | Jul 18, 2022 | Certified |
Database Administrator Supervisor I-200-22199-358091 | $149,384/yr | IV | Cincinnati, OH | Jul 18, 2022 | Certified |
Database Administration Supervisor I-200-22188-337875 | $149,384/yr | IV | Cincinnati, OH | Jul 07, 2022 | Withdrawn |
Data Developer Specialist I-200-22188-337937 | $150,000/yr | IV | Cincinnati, OH | Jul 07, 2022 | Certified |
Senior Data Developer I-200-22180-320012 | $140,000/yr | IV | Cincinnati, OH | Jun 29, 2022 | Certified |
Senior Data Developer I-200-22174-307982 | $140,000/yr | IV | Cincinnati, OH | Jun 23, 2022 | Certified |
Senior Application Analyst and Developer II I-200-22152-230455 | $103,606/yr | II | Cincinnati, OH | Jun 01, 2022 | Certified |
Senior Data Developer I-200-22133-170700 | $140,000/yr | IV | Cincinnati, OH | May 13, 2022 | Certified |
Data Developer/Analyst I-200-22108-079321 | $81,000/yr | I | Cincinnati, OH | Apr 18, 2022 | Certified |
Financial Analyst I-200-22105-075164 | $75,000/yr | II | Cincinnati, OH | Apr 15, 2022 | Certified |
Senior Business Analyst II I-200-22103-066942 | $110,000/yr | III | Cincinnati, OH | Apr 13, 2022 | Certified |
Quality Assurance Specialist I-200-22083-006958 | $110,000/yr | III | Cincinnati, OH | Mar 24, 2022 | Certified |
Systems/Network Administration Specialist I-200-22073-976333 | $136,500/yr | IV | Charlotte, NC | Mar 14, 2022 | Certified |
Senior Application Analyst and Developer I-200-22039-885110 | $96,174/yr | II | Cincinnati, OH | Feb 08, 2022 | Certified |
Senior Database Administrator I-200-22011-821655 | $118,000/yr | III | Cincinnati, OH | Jan 11, 2022 | Certified |
One row per LCA case (its latest version), from U.S. DOL OFLC disclosure data. Salaries are the offered wage, converted to a yearly figure. Certified LCAs are not visa approvals.
Worker positions by LCA filing purpose, summed across FY2022–FY2026 disclosure records.
Most active filing months: Apr and May — useful for timing transfer conversations.
Attestations from the employer's own LCA filings (Form ETA-9035), as disclosed by the U.S. DOL.
12 states · 17 cities
The same DOL data on this page is what every H-1B sponsor must track for each worker. ElevateStaffing.ai automates it end-to-end:
Get the private PAF / LCA gap check for your own filings — free, one business day — then let ElevateStaffing.ai keep every LCA, PAF, I-9 and I-983 deadline audit-ready.
Get my private gap check →