Fiscal Year

2022

Case Number

A-21251-41479

Case Status

Certified-Expired

Received Date

2021-09-23

Decision Date

2022-04-01

Refile

N

Original File Date

2022-01-01 11:11:53

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

REDFIN CORPORATION

Employer Name Slug

redfin-corporation

Employer Address 1

1099 STEWART STREET

Employer Address 2

SUITE 600

Employer City

SEATTLE

Employer City Slug

seattle

Employer State

WASHINGTON

Employer State Slug

washington

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

98101

Employer Phone

877-973-3346

Employer Number of Employees

2200

Employer Year Commenced Business

2004

NAICS Code

5191

FW Ownership Interest

N

Employer Contact Name

Josephine Tat

Employer Contact Address 1

1099 Stewart Street

Employer Contact Address 2

Suite 600

Employer Contact City

Seattle

Employer Contact State/Province

WASHINGTON

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

98101

Employer Contact Phone

206.435.7279

Employer Contact Email

josephine.tat@redfin.com

Agent Attorney Name

Natalie Joy L AngPinlac

Agent Attorney Firm Name

Corporate Immigration Partners, LLP

Agent Attorney Phone

4157717500

Agent Attorney Address 1

465 California Street

Agent Attorney Address 2

Suite 700

Agent Attorney City

San Francisco

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

94104

Agent Attorney Email

redfin@cipllp.com

PW Track Number

P10020342939865

PW SOC Code

15-1199

PW SOC Title

Computer Occupations, All Other

PW Skill Level

Level IV

PW Wage

117125.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-05-20

PW Expiration Date

2021-08-18

Wage Offer From

130000.00

Wage Offer To

0.00

Average Salary

130000.00

Wage Unit of Pay

Year

Worksite Address 1

1099 Stewart Street

Worksite Address 2

Suite 600

Worksite City

Seattle

Worksite City Slug

seattle

Worksite State

WASHINGTON

Worksite Postal Code

98101

Job Title

Sr. BI Engineer

Job Title Slug

sr-bi-engineer

Minimum Education

Master's

Major Field of Study

Management Info. Systems, Comp. Eng., Data Science or in related field

Required Training

N

Required Experience

Y

Required Experience Months

48

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

Management Info. Systems, Comp. Eng., Data Science or in 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

In the job offered or in a computerrelated occupation

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

The position requires a Masters or foreign equivalent degree in Management Information Systems, Computer Engineering, Data Science or in related field and 4 years of experience in the job offered or in a computerrelated occupation.br br Special Requirements Position requires experience in each of the following skillsbr br 1. 4 years of experience in creating actionable reports using data visualization tools in Tableau;br 2. 4 years of experience in working with relational, dimensional and columnar database for accessing source system data to display in reporting tools;br 3. 1 year experience in administering Tableau Server including upgrading server software as well as implementation and maintenance of security;br 4. 1 year experience in working with an enterprise data warehouse application in Amazon Redshift, Teradata or Snowflake to extract data warehouse information to analyze and display in reporting tools;br 5. 4 years of experience in SQL experience, including working with real world, complex datasets and cleansing them to display accurate reporting information;br 6. 2 years of experience in building consolidated data models that support cross team analysis and provide a single source of truth for the busines, using both Tableau Shared Datasources and centralized database views; andbr 7. 2 years of experience in working with technical and nonbusiness stakeholders to gather requirements and design reporting solutions to provide insights.br br Employment and background checks may be required.

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-06

SWA Job Order End Date

2021-08-09

Sunday Edition Newspaper

Y

First Newspaper Name

The Seattle Times

First Advertisement Start Date

2021-07-11

Second Newspaper Ad Name

The Seattle Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2021-07-18

Employer Website From Date

2022-01-01 11:11:53

Employer Website To Date

2022-01-01 11:11:53

Professional Organization Ad From Date

2021-07-06

Professional Organization Advertisement To Date

2021-07-19

Job Search Website From Date

2021-07-06

Job Search Website To Date

2021-07-19

Employee Referral Program From Date

2022-01-01 11:11:53

Employee Referral Program To Date

2022-01-01 11:11:53

Local Ethnic Paper From Date

2021-07-16

Local Ethnic Paper To Date

2021-07-22

Radio/TV Ad From Date

2022-01-01 11:11:53

Radio/TV Ad To Date

2022-01-01 11:11:53

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

MANAGEMENT INFORMATION SYSTEMS

Foreign Worker Years of Education Completed

2015

Foreign Worker Institution of Education

TEXAS TECH UNIVERSITY

Foreign Worker Education Institution Address 1

2500 BROADWAY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

LUBBOCK

Foreign Worker Education Institution State/Province

TX

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

79409

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Natalie Joy L AngPinlac

Preparer Title

Partner

Preparer Email

redfin@cipllp.com

Employer Information Declaration Name

Josephine Tat

Employer Information Declaration Title

HR Coordinator