Fiscal Year

2022

Case Number

A-21036-49593

Case Status

Denied

Received Date

2021-04-16

Decision Date

2022-02-02

Refile

N

Original File Date

2022-01-01 10:52:25

Previous SWA Case Number State

Schedule A Sheepherder

N

Employer Name

DIRECTAVENUE, INC.

Employer Name Slug

directavenue-inc

Employer Address 1

5963 LA PLACE COURT

Employer Address 2

SUITE 300

Employer City

CARLSBAD

Employer City Slug

carlsbad

Employer State

CALIFORNIA

Employer State Slug

california

Employer Country

UNITED STATES OF AMERICA

Employer Postal Code

92008

Employer Phone

(760) 579-4200

Employer Number of Employees

34

Employer Year Commenced Business

2007

NAICS Code

541830

FW Ownership Interest

N

Employer Contact Name

Taylor Hindle

Employer Contact Address 1

5963 La Place Court

Employer Contact Address 2

Suite 300

Employer Contact City

Carlsbad

Employer Contact State/Province

CALIFORNIA

Employer Contact Country

UNITED STATES OF AMERICA

Employer Contact Postal Code

92008

Employer Contact Phone

(760) 579-4225

Employer Contact Email

taylor@directavenue.com

Agent Attorney Name

Fausta M Albi

Agent Attorney Firm Name

Larrabee Albi Coker LLP

Agent Attorney Phone

(858) 642-0420

Agent Attorney Address 1

P.O. Box 919016

Agent Attorney Address 2

Agent Attorney City

San Diego

Agent Attorney State/Province

CALIFORNIA

Agent Attorney Country

UNITED STATES OF AMERICA

Agent Attorney Postal Code

92191-9016

Agent Attorney Email

Fausta@larrabee.com

PW Track Number

P10020324919037

PW SOC Code

15-2031

PW SOC Title

Operations Research Analysts

PW Skill Level

Level I

PW Wage

62650.00

PW Unit of Pay

Year

PW Wage Source

OES

PW Determination Date

2021-04-05

PW Expiration Date

2021-07-04

Wage Offer From

62650.00

Wage Offer To

0.00

Average Salary

62650.00

Wage Unit of Pay

Year

Worksite Address 1

5963 La Place Court

Worksite Address 2

Suite 300

Worksite City

Carlsbad

Worksite City Slug

carlsbad

Worksite State

CALIFORNIA

Worksite Postal Code

92008

Job Title

Data Analyst

Job Title Slug

data-analyst

Minimum Education

Master's

Major Field of Study

Information Science, Data Analytics, or a related field.

Required Training

N

Required Experience

N

Required Experience Months

Accept Alternative Field of Study

N

Accept Alternative Major Field of Study

Accept Alternative Combination

N

Accept Alternative Combination Education

Accept Alternative Combination Education Years

Accept Foreign Education

Y

Accept Alternative Occupation

N

Accept Alternative Occupation Months

Accept Alternative Job Title

Job Opportunity Requirements Normal

Y

Foreign Language Required

N

Specific Skills

Academic background or work experience to includebr br 1. Using R and Python to produce reports and facilitate data management processes.br 2. Developing a Python application to read and transfer different formatfile types into a standard format.br 3. Working with business and IT stakeholders to understand, translate, and deliver data and analytics solutions.br 4. Troubleshooting and driving resolution to technical issues related to largescale data analytics platforms.br 5. Assessing and developing technical solutions, tools and capabilities related to data processing and analytics.br 6. Data mining and machine learning.br 7. Utilizing data collection methods and data sources.br 8. Using statistical techniques for data analysis.br 9. Using cloud tools to predict and prescribe business outcomes using collected data.br 10. Working with big data architecture.br 11. Working with relational databases to manipulate data and derive insights using SQL.br 12. Working with statistical computer languages R, Python, and SQL to manipulate data and draw insights from large data sets.br 13. Working with SQL to extract data and prepare reports.br 14. Translating business issues and data into actionable analysis.br 15. Using the following analytical methods Classification, Regression, and Cluster Analysis.br 16. Utilizing mathematical formulas, macros, VLookups, HLookups, VBA programming, pivot tables and pivot reporting, advanced charting, and dashboards in MS Excel.br 17. Writing SQL queries.br 18. Utilizing a Relational Database Microsoft SQL Server, including development of SQL queries joins, indexes and aggregation functions.br 19. Utilizing realtime messaging and NoSQL storage.br 20. Working with unstructured datasets, to include identifying, loading, processing, optimizing, and reporting.br 21. Performing root cause analysis on internal and external data and processes to answer business questions.br 22. Building processes supporting data transformation, data structures, metadata, dependency and workload management.br 23. Manipulating, processing and extracting value from large disconnected datasets.

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-12-04

SWA Job Order End Date

2021-01-04

Sunday Edition Newspaper

Y

First Newspaper Name

The San Diego Union Tribune

First Advertisement Start Date

2020-12-13

Second Newspaper Ad Name

The San Diego Union Tribune

Second Advertisement Type

Newspaper

Second Ad Start Date

2020-12-20

Employer Website From Date

2022-01-01 10:52:25

Employer Website To Date

2022-01-01 10:52:25

Professional Organization Ad From Date

2022-01-01 10:52:25

Professional Organization Advertisement To Date

2022-01-01 10:52:25

Job Search Website From Date

2022-01-01 10:52:25

Job Search Website To Date

2022-01-01 10:52:25

Employee Referral Program From Date

2020-12-16

Employee Referral Program To Date

2021-01-05

Local Ethnic Paper From Date

2020-12-18

Local Ethnic Paper To Date

2020-12-18

Radio/TV Ad From Date

2022-01-01 10:52:25

Radio/TV Ad To Date

2022-01-01 10:52:25

Employer Received Payment

N

Posted Notice at Worksite

Y

Layoff in Past Six Months

N

Country of Citizenship

TAIWAN

Foreign Worker Birth Country

TAIWAN

Class of Admission

Not in USA

Foreign Worker Education

Master's

Foreign Worker Information: Major

LIBRARY AND INFORMATION STUDIES

Foreign Worker Years of Education Completed

2017

Foreign Worker Institution of Education

THE UNIVERSITY OF WASHINGTON, SEATTLE

Foreign Worker Education Institution Address 1

1410 NE CAMPUS PARKWAY

Foreign Worker Education Institution Address 2

459 SCHMITZ HALL, BOX 355832

Foreign Worker Education Institution City

SEATTLE

Foreign Worker Education Institution State/Province

WA

Foreign Worker Education Institution Country

UNITED STATES OF AMERICA

Foreign Worker Education Institution Postal Code

98195

Foreign Worker Experience with Employer

N

Foreign Worker Employer Pays for Education

N

Foreign Worker Currently Employed

Y

Employer Completed Application

N

Preparer Name

Fausta M Albi

Preparer Title

PartnerAttorney at Law

Preparer Email

fausta@larrabee.com

Employer Information Declaration Name

Marc Johnston

Employer Information Declaration Title

Chief Financial Officer