Fiscal Year

2024

Case Number

A-23045-01621

Case Status

Certified

Received Date

2023-03-22

Decision Date

2024-04-15

Refile

N

Original File Date

2024-01-01 01:04:47

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

HRB PROFESSIONAL RESOURCES LLC

Employer Name Slug

hrb-professional-resources-llc

Employer Address 1

ONE HR BLOCK WAY

Employer Address 2

Employer City

KANSAS CITY

Employer City Slug

kansas-city

Employer State

MISSOURI

Employer State Slug

missouri

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

64105

Employer Phone

(816) 854-4338

Employer Number of Employees

2287

Employer Year Commenced Business

2014

NAICS Code

541213

FW Ownership Interest

N

Employer Contact Name

Stacia Hawkins

Employer Contact Address 1

One HR Block Way

Employer Contact Address 2

Employer Contact City

Kansas City

Employer Contact State/Province

MISSOURI

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

64105

Employer Contact Phone

(816) 854-5238

Employer Contact Email

stacia.hawkins@hrblock.com

Agent Attorney Name

Roberta F Farrell

Agent Attorney Firm Name

Roberta F. Farrell, LLC

Agent Attorney Phone

8165617788

Agent Attorney Address 1

2005 Swift Avenue

Agent Attorney Address 2

Agent Attorney City

North Kansas City

Agent Attorney State/Province

MISSOURI

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

64116

Agent Attorney Email

rfarrell@farrell-lawoffice.com

PW Track Number

P10022129151061

PW SOC Code

15-1243.01

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level IV

PW Wage

135512.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-11-29

PW Expiration Date

2023-06-30

Wage Offer From

135512.00

Wage Offer To

0.00

Average Salary

135512.00

Wage Unit of Pay

Year

Worksite Address 1

One HR Block Way

Worksite Address 2

Worksite City

Kansas City

Worksite City Slug

kansas-city

Worksite State

MISSOURI

Worksite Postal Code

64105

Job Title

Senior Software Engineer

Job Title Slug

senior-software-engineer

Minimum Education

Bachelor's

Major Field of Study

Computer Science, IT, Computer Information Systems, or related field.

Required Training

N

Required Experience

Y

Required Experience Months

60

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

3

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

60

Accept Alternative Job Title

Software Engineer, Software Developer, or related occupation.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Bachelors degree in Computer Science, Information Technology, Computer Information Systems, or a related field.br br Five years of IT experience to includebr br Data management, layered datawarehouse data lake hybrid architecture, Data Modeling, Data Quality, Data Lineage, Data Security and Privacy, Data Governance.br ETL framework.br Cloudbased data warehouse solution implementation migration from on prem to cloud based on Snowflake, SQL Server database and data processing solutions.br Optimized Indexing, ETL mappings to import and export data from relational and nonrelational sources.br Change management and deployment of database using Automated Build and Releases, Continuous Integration and Continuous Deployments using Azure DevOps.br Production Support to EDS and DataOps Team applications and databases. Azure Data Factory for all the DataOps teams.br br In lieu of a bachelors plus 5 years of experience, a masters plus 3 years of experience is acceptable.

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

2022-12-16

SWA Job Order End Date

2023-01-23

Sunday Edition Newspaper

Y

First Newspaper Name

Kansas City Star

First Advertisement Start Date

2022-12-18

Second Newspaper Ad Name

Kansas City Star

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-12-25

Employer Website From Date

2022-12-16

Employer Website To Date

2023-01-24

Professional Organization Ad From Date

2024-01-01 01:04:47

Professional Organization Advertisement To Date

2024-01-01 01:04:47

Job Search Website From Date

2022-12-18

Job Search Website To Date

2023-01-17

Employee Referral Program From Date

2024-01-01 01:04:47

Employee Referral Program To Date

2024-01-01 01:04:47

Local Ethnic Paper From Date

2024-01-01 01:04:47

Local Ethnic Paper To Date

2024-01-01 01:04:47

Radio/TV Ad From Date

2024-01-01 01:04:47

Radio/TV Ad To Date

2024-01-01 01:04:47

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 AND INFORMATION TECHNOLOGY

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

UNIVERSITY OF CENTRAL MISSOURI

Foreign Worker Education Institution Address 1

116 W SOUTH STREET

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

WARRENSBURG

Foreign Worker Education Institution State/Province

MO

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

64093

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Roberta F FARRELL

Preparer Title

Attorney

Preparer Email

rfarrell@farrell-lawoffice.com

Employer Information Declaration Name

Jennifer L PETERS

Employer Information Declaration Title

Senior Corporate Counsel