Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:DIRECTAVENUE, INC.
Employer Address_Line 1:5963 LA PLACE COURT
Employer Address_Line 2:SUITE 300
Employer City :CARLSBAD
State:
Employer State/ Province:CALIFORNIA
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:92008
Employer Phone No.:(760) 579-4200
Employer Phone Extent No.:
Total Number of Employees:34
Employer Year of Commenced :
NAICS Code:541830
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Taylor Hindle
Employer Contact Address Line1:5963 La Place Court
Employer Contact Address Line2:Suite 300
Employer Contact City:Carlsbad
Employer Contact State/ Provice:CALIFORNIA
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:92008
Employer Contact Phone:(760) 579-4225
Employer Contact Email:taylor@directavenue.com
Attorney
Agent/ Attorney Name:Fausta M Albi
Agent/ Attorney Firm Name:Larrabee Albi Coker LLP
Agent/ Attorney Phone:(858) 642-0420
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:P.O. Box 919016
Agent/ Attorney Address Line 2:
Agent/ Attorney City:San Diego
Agent/ Attorney State/ Province:CALIFORNIA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:0
Agent/ Attorney Email:Fausta@larrabee.com
Position Info
Prevailing Wage Track Number:P10020324919037
Prevailing Wage SOC Code :15-2031
Prevailing Wage SOC Title :Operations Research Analysts
Prevailing Wage Skill Level:Level I
Prevailing Wage:62650
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-04-05
Prevailing Wage Expiration Date :2021-07-04
Wage Offer From:62650
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:5963 La Place Court
Worksite Address Line 2:Suite 300
Worksite City :Carlsbad
Worksite State:CALIFORNIA
Worksite Postal Code:92008
Job Title:Data Analyst
Minimum Education:Master's
Other Degree/ Diploma:
Major Field of Study:Information Science, Data Analytics, or a related field.
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :N
Required Expreience Months :
Accept Alternate Field of Study:N
Accept Alternate Major:
Alternate Combination of Education/ Experience:N
Required Alternate Level of Education :
Other Alternate Level of Education:
Acceptable Years of Experience:
Accept Foreign Educationa:Y
Acceptable Alternate Occupation:N
Acceptable Alternate Occupation Month:
Accept Alternate Job Title:
Normal Requirements of Job Opportunity:Y
Required Foreign Language: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 Applied Foreign Worker:Y
ForeignWorker Live on Premises :N
Live in Domestic Service Worker:N
Employment Contract :
Professional Occupation :Y
College/ University Teacher:N
Competitive Process:
Basic Recruitment Process :
Teacher Select Date:
Teacher Publish Journal Name:
Additional Recruitment Information:
Job Oder Start Date:2020-12-04
Job Oder 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 Name:The San Diego Union Tribune
Second Advertisement Type:Newspaper
Second Ad Start Date:2020-12-20
Job Fair From Date:
Job Fair to Date:
On Campus Recruiting from Date:
On Campus Recruiting to Date:
Employer Website from Date:
Employer Website to Date:
Pro. Org. Ad from Date:
Pro.Org. Ad to Date:
Job Search Website from Date:
Job Search Website to Date:
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:2020-12-16
Employee Referral Program to Date:2021-01-05
Campus Placement from Date:2020-12-04
Campus Placement to Date:2020-12-11
Local Ethnic Newspaper from Date:2020-12-18
Local Ethnic Newspaper to Date:2020-12-18
Radio/TV Ad from Date:
Radio/TV Ad to Date:
Employer Received the Payment:N
Payment Details:
Bargaining Representative Notified:N/A
Posted Notice at Worksite:Y
Layoff in Past Six Months:N
US Worker Considered:
Country of Citizenship:TAIWAN CHINA
Foreign Worker Birth Country:TAIWAN CHINA
Class of Admission :Not in USA
Employee Info
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:LIBRARY AND INFORMATION STUDIES
Year of Compelted Education:2017
Foreign Worker Istitution of Eduation:THE UNIVERSITY OF WASHINGTON, SEATTLE
Foreign Worker Education Instution Address Line 1:1410 NE CAMPUS PARKWAY
