Fiscal Year

2023

Case Number

A-22117-47095

Case Status

Certified

Received Date

2022-06-09

Decision Date

2023-03-06

Refile

N

Original File Date

2023-01-01 08:03:07

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

SLALOM, LLC

Employer Name Slug

slalom-llc

Employer Address 1

821 2ND AVENUE

Employer Address 2

STE. 1900

Employer City

SEATTLE

Employer City Slug

seattle

Employer State

WASHINGTON

Employer State Slug

washington

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

98104

Employer Phone

(206) 438-5700

Employer Number of Employees

10720

Employer Year Commenced Business

1993

NAICS Code

541611

FW Ownership Interest

N

Employer Contact Name

Brandi Cypher

Employer Contact Address 1

821 2nd Avenue

Employer Contact Address 2

Ste. 1900

Employer Contact City

Seattle

Employer Contact State/Province

WASHINGTON

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

98104

Employer Contact Phone

(206) 832-3808

Employer Contact Email

brandic@slalom.com

Agent Attorney Name

Karla Jean Bacayan

Agent Attorney Firm Name

Corporate Immigration Partners, LLP

Agent Attorney Phone

(415) 771-7500

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

slalom@cipllp.com

PW Track Number

P10021188448515

PW SOC Code

15-1199

PW SOC Title

Business Intelligence Analysts

PW Skill Level

Level III

PW Wage

99008.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2022-02-17

PW Expiration Date

2022-06-30

Wage Offer From

127000.00

Wage Offer To

139700.00

Average Salary

133350.00

Wage Unit of Pay

Year

Worksite Address 1

821 2nd Ave

Worksite Address 2

Worksite City

Seattle

Worksite City Slug

seattle

Worksite State

WASHINGTON

Worksite Postal Code

98104

Job Title

Business Intelligence Consultant

Job Title Slug

business-intelligence-consultant

Minimum Education

Master's

Major Field of Study

See H.14.

Required Training

N

Required Experience

Y

Required Experience Months

36

Accept Alternative Field of Study

Y

Accept Alternative Major Field of Study

See H.14.

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

36

Accept Alternative Job Title

See H.14.

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Minimum Requirementsbr Masters degree in Computer Engineering, Engineering Management, Management Information Systems, or related field and 3 years of experience in the job offered or in a data analystrelated occupation.br br Must be available to work on projects at various, unanticipated sites within commuting distance of Slaloms Seattle, Washington office.br .br Special Requirementsbr br Position requires at least 3 years of experience in each of the following skillsbr br 1. Experience with using various ETL methods and tools such as Visual Studio Integration Services, Power Query, SQL etc.to move, integrate, and cleanse data from available data sources.br 2. Experience with designing and implementing data integrations and data migration elements of a data platform by leveraging various integration technologies such as Boomi, Salesforce Data Loader etc.br 3. Experience using BI tools such as Excel, Power BI, Tableau etc. to identify data patterns and trends through report and dashboard building.br 4. Experience with defining data visualizations to support client reporting and dashboard needs in order to design and build starsnowflakeother schema data models.br 5. Experience translating business requirements into a data solutions to plan, design, develop, and analyze business requirements for complex data problems.br 6. Experience using tools such as Jira, Asana etc. in support of client delivery work to write user stories and acceptance criteria to populate agile backlogsbr 7. Experience using analytics tools and test scripts to assess and validate if a solution has fulfilled requirements as well as the stated business benefits of the project.br 8. Experience using tools such as Power BI or python to examine available data from an existing information source and collect statistics or informative summaries about that data.br 9. Experience with Azure, AWS, Salesforce etc. to analyze and develop cloud data platforms.

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-03-02

SWA Job Order End Date

2022-04-04

Sunday Edition Newspaper

Y

First Newspaper Name

The Seattle Times

First Advertisement Start Date

2022-03-13

Second Newspaper Ad Name

The Seattle Times

Second Advertisement Type

Newspaper

Second Ad Start Date

2022-03-20

Employer Website From Date

2023-01-01 08:03:07

Employer Website To Date

2023-01-01 08:03:07

Professional Organization Ad From Date

2022-03-10

Professional Organization Advertisement To Date

2022-03-19

Job Search Website From Date

2022-03-09

Job Search Website To Date

2022-03-23

Employee Referral Program From Date

2023-01-01 08:03:07

Employee Referral Program To Date

2023-01-01 08:03:07

Local Ethnic Paper From Date

2022-03-18

Local Ethnic Paper To Date

2022-03-24

Radio/TV Ad From Date

2023-01-01 08:03:07

Radio/TV Ad To Date

2023-01-01 08:03:07

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

ENGINEERING MANAGEMENT

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

NORTHEASTERN UNIVERSITY

Foreign Worker Education Institution Address 1

360 HUNTINGTON AVE

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

BOSTON

Foreign Worker Education Institution State/Province

MA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

2115

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Karla Jean Bacayan

Preparer Title

Supervising Attorney

Preparer Email

slalom@cipllp.com

Employer Information Declaration Name

Brandi Cypher

Employer Information Declaration Title

Immigration Analyst