Fiscal Year

2021

Case Number

A-20248-96454

Case Status

Certified

Received Date

2020-09-21

Decision Date

2021-04-16

Refile

N

Original File Date

2021-01-01 09:14:07

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

COLUMBIA SPORTSWEAR COMPANY

Employer Name Slug

columbia-sportswear-company

Employer Address 1

14375 NW SCIENCE PARK DRIVE

Employer Address 2

Employer City

PORTLAND

Employer City Slug

portland

Employer State

OREGON

Employer State Slug

oregon

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

97229

Employer Phone

503-985-4839

Employer Number of Employees

1003

Employer Year Commenced Business

1938

NAICS Code

31599

FW Ownership Interest

N

Employer Contact Name

Jodi Alfano

Employer Contact Address 1

14375 NW Science Park Dr.

Employer Contact Address 2

Employer Contact City

Portland

Employer Contact State/Province

OREGON Oregon

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

97229

Employer Contact Phone

5039854839

Employer Contact Email

JAlfano@columbia.com

Agent Attorney Name

Melany I Savitt

Agent Attorney Firm Name

Tonkon Torp LLP

Agent Attorney Phone

5038022179

Agent Attorney Address 1

888 SW 5th Avenue

Agent Attorney Address 2

Suite 1600

Agent Attorney City

Portland

Agent Attorney State/Province

OREGON

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

97204

Agent Attorney Email

melany.savitt@tonkon.com

PW Track Number

P10020055346021

PW SOC Code

15-1121

PW SOC Title

Computer Systems Analysts

PW Skill Level

Level IV

PW Wage

105830.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2020-05-12

PW Expiration Date

2020-08-10

Wage Offer From

112270.00

Wage Offer To

0.00

Average Salary

112270.00

Wage Unit of Pay

Year

Worksite Address 1

14375 NW Science Park Drive

Worksite Address 2

Worksite City

Portland

Worksite City Slug

portland

Worksite State

OREGON

Worksite Postal Code

97229

Job Title

Business Intelligence (BI) Engineer

Job Title Slug

business-intelligence-bi-engineer

Minimum Education

Bachelor's

Major Field of Study

See H.14

Required Training

N

Required Experience

N

Required Experience Months

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

48

Accept Alternative Job Title

See H.4

Job Opportunity Requirements Normal

N

Foreign Language Required

N

Specific Skills

Certifications IBM Certified Designer Cognos 10 BI Reportsbr IBM Certified Developer Cognos 10 BI Metadata Modelsbr IBM Certified Developer Cognos 10 BI OLAP Modelsbr br 4 years experiencebr 1 working with the following Cognos BI tool suite Report Studio, Framework Manager, Query Studio, Analysis Studio, Event Studio, Cognos Workspace Business Insight, Cognos Workspace Advanced Business Insight Advanced, and Cognos for Microsoft Office Go Office;br 2 developing and performance tuning Cognos framework manager models, Dashboards, reports and security in a global organization;br 3 working with relational dimensional databases and data warehouse SQL Server and Teradata;br 4 developing and supporting metadata modeling using Kimball dimensional modeling methodology;br 5 writing SQL and TSQL;br 6 evaluating, debugging and performance tuning SQL;br 7 performing solution integration, quantitative performance measurement, and user acceptance testing for BI solutions;br 8 translating business and functional requirements into documented technical specifications including design documents and unit test plans;br 9 meeting project schedules and providing accurate estimates of effort required for development deliverables;br 10 working on application support documentation change requests as required by the application support teams for acceptance of changes into production;br 11 troubleshooting, triaging and resolving issues discovered during testing phases and using HPQC ALM defect management tool;br 3 years experiencebr 12 developing Cognos multidimensional models and reports;br br 2 years experiencebr 13 writing HTML and JavaScript;br 14 testing installation, configuration and upgrades of largescale BIEnterprise Reporting implementations;br 15 mentoring junior developers and training business users on BI selfservice tools.br br All experience, skills, and requirements may be gained concurrently. Employer will conduct background check prior to hire.br br br H.4B and H.7A MAJOR FIELD OF STUDY Computer Science, Computer Information Systems, Electronic Engineering, or a related fieldbr br br H.10B ALT. OCCUPATIONS BI Developer, BI Analyst, Report Developer, BI Engineer, Systems Engineer, Programmer Analyst, or similar positionbr br br H.12 BUSINESS NECESSITY DOCUMENTATION CAN BE PROVIDED TO ESTABLISH THAT THE JOB DUTIES AND REQUIREMENTS BEAR A REASONABLE RELATIONSHIP TO THE OCCUPATION IN THE CONTEXT OF THE EMPLOYERS BUSINESS AND ARE ESSENTIAL TO PERFORM THE JOB IN A REASONABLE MANNER.

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-07-16

SWA Job Order End Date

2020-08-19

Sunday Edition Newspaper

Y

First Newspaper Name

The Oregonian

First Advertisement Start Date

2020-07-12

Second Newspaper Ad Name

The Oregonian

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-07-19

Employer Website From Date

2020-07-06

Employer Website To Date

2020-09-18

Professional Organization Ad From Date

2021-01-01 09:14:07

Professional Organization Advertisement To Date

2021-01-01 09:14:07

Job Search Website From Date

2020-07-12

Job Search Website To Date

2020-07-25

Employee Referral Program From Date

2021-01-01 09:14:07

Employee Referral Program To Date

2021-01-01 09:14:07

Local Ethnic Paper From Date

2020-07-16

Local Ethnic Paper To Date

2020-07-22

Radio/TV Ad From Date

2021-01-01 09:14:07

Radio/TV Ad To Date

2021-01-01 09:14: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-4

Foreign Worker Education

Bachelor's

Foreign Worker Information: Major

ELECTRONICS AND INSTRUMENTATION ENGINEERING

Foreign Worker Years of Education Completed

2010

Foreign Worker Institution of Education

ANNA UNIVERSITY

Foreign Worker Education Institution Address 1

ANNA UNIVERSITY, GUINDY

Foreign Worker Education Institution Address 2

Foreign Worker Education Institution City

CHENNAI

Foreign Worker Education Institution State/Province

TAMIL NADU

Foreign Worker Education Institution Country

INDIA

Foreign Worker Education Institution Postal Code

600025

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Melany I Savitt

Preparer Title

Attorney

Preparer Email

melany.savitt@tonkon.com

Employer Information Declaration Name

Jodi Alfano

Employer Information Declaration Title

Senior Human Resources Business Partner