Fiscal Year

2021

Case Number

A-20317-20497

Case Status

Certified

Received Date

2020-11-24

Decision Date

2021-05-27

Refile

N

Original File Date

2021-01-01 09:29:40

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

WESTERN UNION LLC

Employer Name Slug

western-union-llc

Employer Address 1

7001 E. BELLEVIEW AVENUE

Employer Address 2

GLOBAL MOBILITY DEPT HQ13

Employer City

DENVER

Employer City Slug

denver

Employer State

COLORADO

Employer State Slug

colorado

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

80237

Employer Phone

720-332-5318

Employer Number of Employees

2355

Employer Year Commenced Business

1851

NAICS Code

522320

FW Ownership Interest

N

Employer Contact Name

Christine A Duke

Employer Contact Address 1

7001 E. Belleview Avenue

Employer Contact Address 2

Global Mobility Dept HQ13

Employer Contact City

Denver

Employer Contact State/Province

COLORADO

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

80237

Employer Contact Phone

720-332-0284

Employer Contact Email

chris.duke@westernunion.com

Agent Attorney Name

Samantha Wolfe

Agent Attorney Firm Name

Ogletree Deakins

Agent Attorney Phone

303-764-6831

Agent Attorney Address 1

2000 South Colorado Blvd

Agent Attorney Address 2

Tower 3, Suite 900

Agent Attorney City

Denver

Agent Attorney State/Province

COLORADO

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

80222

Agent Attorney Email

samantha.wolfe@ogletree.com

PW Track Number

P10020094458768

PW SOC Code

15-1199

PW SOC Title

Data Warehousing Specialists

PW Skill Level

Level II

PW Wage

90418.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-07-16

PW Expiration Date

2021-06-30

Wage Offer From

90418.00

Wage Offer To

120721.00

Average Salary

105569.50

Wage Unit of Pay

Year

Worksite Address 1

7979 East Tufts Ave

Worksite Address 2

Worksite City

Denver

Worksite City Slug

denver

Worksite State

COLORADO

Worksite Postal Code

80237

Job Title

Data Engineer (Sr. Analyst, Decision Sciences)

Job Title Slug

data-engineer-sr-analyst-decision-sciences

Minimum Education

Bachelor's

Major Field of Study

Computer Science

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Information Systems, or related field

Accept Alternative Combination

Y

Accept Alternative Combination Education

Master's

Accept Alternative Combination Education Years

2

Accept Foreign Education

Y

Accept Alternative Occupation

Y

Accept Alternative Occupation Months

36

Accept Alternative Job Title

Data Analyst, Associate Projects, or related occupation

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

POSITION REQUIRES PROGRESSIVE POSTBACHELORS EXPERIENCE 3 YEARS WITH BACHELORS OR 2 YEARS WITH MASTERS, WHICH MUST INCLUDE SOME EXPERIENCE IN EACH OF THE FOLLOWING SKILLS QUERYING DATABASES ANSWERING COMPLEX DATA QUESTIONS WITH CLEAN, OPTIMIZED QUERIES, USING JOINS, AGGREGATIONS, AND SUBQUERIES ON SQL SERVER AND ORACLE 11G12C; DATABASE DESIGN AND AUTOMATION DESIGN TABLES, VIEWS, SCHEMAS, STORED PROCEDURES AND MANAGE DATABASE UPDATES USING DATABASE LANGUAGES TSQL OR PLSQL; BIG DATACLOUD PLATFORMS MANAGE QUERIES AND ETL JOBS ON BILLIONS OF DATA POINTS IN BIGDATA ENVIRONMENTS SUCH AS HADOOP E.G. HIVE AND SNOWFLAKE; DESIGN, DEVELOP AND EXECUTE ETL JOBS APPLY IBM INFOSPHERE DATASTAGE, TALEND, PENTAHO OR MATILLION TO MANAGE LARGE ETL PIPELINES OVER MILLIONS OF RECORDS AND HUNDREDS OF FIELDS FROM ANY DATA SOURCE; PROGRAMMING LANGUAGES AND DATA INTERFACE WITH DATABASES, MANIPULATE DATASETS, AND CREATE DATA VISUALIZATIONS USING LANGUAGES PYTHON, R, OR JAVA; AND DATA VISUALIZATION CREATE INTERACTIVE DATA VISUALIZATIONS AND DASHBOARDS USING DEDICATED ENTERPRISELEVEL TOOLS LIKE TABLEAU, POWER BI, AND MICROSTRATEGY.

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

2020-08-21

SWA Job Order End Date

2020-09-23

Sunday Edition Newspaper

Y

First Newspaper Name

Denver Post

First Advertisement Start Date

2020-08-23

Second Newspaper Ad Name

Denver Post

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-08-30

Employer Website From Date

2020-08-21

Employer Website To Date

2020-09-08

Professional Organization Ad From Date

2021-01-01 09:29:40

Professional Organization Advertisement To Date

2021-01-01 09:29:40

Job Search Website From Date

2021-01-01 09:29:40

Job Search Website To Date

2021-01-01 09:29:40

Employee Referral Program From Date

2020-08-21

Employee Referral Program To Date

2020-09-08

Local Ethnic Paper From Date

2021-01-01 09:29:40

Local Ethnic Paper To Date

2021-01-01 09:29:40

Radio/TV Ad From Date

2021-01-01 09:29:40

Radio/TV Ad To Date

2021-01-01 09:29:40

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

INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

UNIVERSITY OF COLORADO

Foreign Worker Education Institution Address 1

UNIVERSITY OF COLORADO

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BOULDER

Foreign Worker Education Institution State/Province

CO

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

80309

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Samantha Wolfe

Preparer Title

Attorney

Preparer Email

samantha.wolfe@ogletree.com

Employer Information Declaration Name

Kellie Nichols

Employer Information Declaration Title

Senior Analyst, Global Mobility