Fiscal Year

2022

Case Number

A-21270-50469

Case Status

Certified

Received Date

2021-12-29

Decision Date

2022-08-22

Refile

N

Original File Date

2022-01-01 11:53:33

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

POLLEN, INC.

Employer Name Slug

pollen-inc

Employer Address 1

2020 WEST 89TH STREET

Employer Address 2

Employer City

LEAWOOD

Employer City Slug

leawood

Employer State

KANSAS

Employer State Slug

kansas

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

66206

Employer Phone

(877) 465-4045

Employer Number of Employees

400

Employer Year Commenced Business

2010

NAICS Code

518210

FW Ownership Interest

N

Employer Contact Name

Sanjay Gupta

Employer Contact Address 1

2020 West 89th Street

Employer Contact Address 2

Employer Contact City

Leawood

Employer Contact State/Province

KANSAS

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

66206

Employer Contact Phone

913-717-4067

Employer Contact Email

sanjay@c2fo.com

Agent Attorney Name

Gizie Hirsh

Agent Attorney Firm Name

Lathrop GPM LLP

Agent Attorney Phone

(816) 460-5848

Agent Attorney Address 1

2345 Grand Blvd.

Agent Attorney Address 2

Suite 2200

Agent Attorney City

Kansas City

Agent Attorney State/Province

MISSOURI

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

641082618

Agent Attorney Email

gizie.hirsh@lathropgpm.com

PW Track Number

P10021110239119

PW SOC Code

15-2041

PW SOC Title

Statisticians

PW Skill Level

Level I

PW Wage

66747.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-09-22

PW Expiration Date

2022-06-30

Wage Offer From

99466.00

Wage Offer To

0.00

Average Salary

99466.00

Wage Unit of Pay

Year

Worksite Address 1

2020 West 89th Street

Worksite Address 2

Worksite City

Leawood

Worksite City Slug

leawood

Worksite State

KANSAS

Worksite Postal Code

66206

Job Title

Senior Business Intelligence Analyst

Job Title Slug

senior-business-intelligence-analyst

Minimum Education

Bachelor's

Major Field of Study

Applied Mathematics

Required Training

N

Required Experience

Y

Required Experience Months

48

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Statistics or a closely related field

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

48

Accept Alternative Job Title

Other position related to Senior Business Intelligence Analyst

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Four years experience under H.6A and H.10A, above, must include the followingbr br i experience and demonstrated ability to perform advanced analyticsstatistical procedures with the purpose of quot;turning data into information.quot; Should be versed in statistical measures and how to perform them Correlation, Regression 1stnth order, Normalization, Forecasting and Clustering,br br ii experience with commercial and emerging BI ecosystems for example, Microsoft BI stack SQL Server ITSQL,br br iii experience working with warehousing methodologiesdesigns and processes ETL, Data Modeling,br br iv experience developing enterprise class selfservice BI solutions with tools such as SSRS, SSIS, Power B1, Tableau, Pyramid Analytics, Excel,br br v experience with advanced Excel reporting including Pivotlables, PivotCharts, Power Query and Power Pivot data modeling, andbr br vi experience in automating reporting to provide business with on demand access to data.br br Position also requires the followingbr br demonstrated ability to write complex SQL to query large data platforms such as Amazon Athena, SQL server, Amazon Redshift, to obtain data necessary for analysis;br br demonstrated understanding of source data components and how they integrate with each other, which might be both relational and dimensional; andbr br demonstrated ability to perform high quality technical documentation and presentations.br br Local travel every quarter may be required.br br Telecommuting allowed work from anywhere in the U.S.br br Any suitable combination of education, training or 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

2021-07-15

SWA Job Order End Date

2021-08-15

Sunday Edition Newspaper

Y

First Newspaper Name

The Kansas City Star

First Advertisement Start Date

2021-07-11

Second Newspaper Ad Name

The Kansas City Star

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-07-18

Employer Website From Date

2021-07-08

Employer Website To Date

2021-08-09

Professional Organization Ad From Date

2022-01-01 11:53:33

Professional Organization Advertisement To Date

2022-01-01 11:53:33

Job Search Website From Date

2021-07-02

Job Search Website To Date

2021-08-03

Employee Referral Program From Date

2022-01-01 11:53:33

Employee Referral Program To Date

2022-01-01 11:53:33

Local Ethnic Paper From Date

2022-01-01 11:53:33

Local Ethnic Paper To Date

2022-01-01 11:53:33

Radio/TV Ad From Date

2022-01-01 11:53:33

Radio/TV Ad To Date

2022-01-01 11:53:33

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

CHINA

Foreign Worker Birth Country

CHINA

Class of Admission

H-1B

Foreign Worker Education

Master's

Foreign Worker Information: Major

APPLIED MATHEMATICS

Foreign Worker Years of Education Completed

2014

Foreign Worker Institution of Education

THE UNIVERSITY OF HOUSTON

Foreign Worker Education Institution Address 1

4800 CALHOUN RD.

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

HOUSTON

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

77004

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Gizie D Hirsh

Preparer Title

Attorney for Employer

Preparer Email

gizie.hirsh@lathropgpm.com

Employer Information Declaration Name

Sanjay Gupta

Employer Information Declaration Title

President and Chief Operating Officer