Previous State Work Force Agency (SWA) Case Number Stete:
Schedule A or a Sheepherder Occupation :N
Company Info
Employer Name:HealthAde
Employer Address_Line 1:2012 Abalone Ave
Employer Address_Line 2:
Employer City :Torrance
State:
Employer State/ Province:CALIFORNIA
Employer Country:UNITED STATES OF AMERICA
Employer Postal Code:90503
Employer Phone No.:18184042506
Employer Phone Extent No.:
Total Number of Employees:265
Employer Year of Commenced :
NAICS Code:424410
Foreign Worker Ownership & Interest:N
HR Info
Employer Contact Name:Carolyn Wright
Employer Contact Address Line1:2012 Abalone Ave
Employer Contact Address Line2:Suite A
Employer Contact City:Torrance
Employer Contact State/ Provice:CALIFORNIA
Employer Contact Country :UNITED STATES OF AMERICA
Employer Contact Post Code:90503
Employer Contact Phone:4243995535
Employer Contact Email:cwright@health-ade.com
Attorney
Agent/ Attorney Name:Kristi Q Ngo
Agent/ Attorney Firm Name:Fragomen, Del Rey, Bernsen Loewy, LLP
Agent/ Attorney Phone:9492610209
Agent/ Attorney Phone Ext.:
Agent/ Attorney Address Line 1:18401 VON KARMAN AVENUE
Agent/ Attorney Address Line 2:Suite 255
Agent/ Attorney City:irvine
Agent/ Attorney State/ Province:CALIFORNIA
Agent/ Attorney Country:UNITED STATES OF AMERICA
Agent/ Attorney Postal Code:92612
Agent/ Attorney Email:jade.woods@fragomen.com
Position Info
Prevailing Wage Track Number:p10020197716838
Prevailing Wage SOC Code :15-1199
Prevailing Wage SOC Title :Data Warehousing Specialists
Prevailing Wage Skill Level:Level III
Prevailing Wage:85987
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-02-16
Prevailing Wage Expiration Date :2021-06-30
Wage Offer From:145000
Wage Offer To:
Wage Offer Unit of Pay:Year
Workstie Address Line 1:2012 Abalone Avenue
Worksite Address Line 2:Suite A
Worksite City :Torrance
Worksite State:CALIFORNIA
Worksite Postal Code:90501
Job Title:Database & Business Intelligence Manager
Minimum Education:Master's
Other Degree/ Diploma:
Major Field of Study:See H.14
Required Training:N
Required Training Month:
Required Field of Training:
Required Experience :Y
Required Expreience Months :36
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:N
Acceptable Alternate Occupation:N
Acceptable Alternate Occupation Month:
Accept Alternate Job Title:
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:MASTERS DEGREE IN INFORMATION SYSTEMS, MATHEMATICS, ELECTRICAL ENGINEERING, OR RELATED FIELD AND 3 YEARS OF PROFESSIONAL EXPERIENCE IN THE JOB OFFERED OR A RELATED OCCUPATION.br br ADDITIONALLY, THE APPLICANT MUST HAVE EXPERIENCE WITHbr 1. DEVELOPMENT OF BUSINESS REQUIREMENTS AND SYSTEMS INTEGRATION USING DOMO;br 2. MANAGING ETL PROCESSES CREATING OPTIMIZED DATAFLOWS;br 3. DESIGN DATA WAREHOUSES USING MYSQL AND AMAZON REDSHIFT DATABASES;br 4. AUTOMATED REPORTING SOLUTIONS AND DATA MINING THAT ENABLE USERS TO MAKE CRITICAL BUSINESS DECISIONS;br 5. INTEGRATE DISPARATE DATABASES AND DATA SETS ACROSS THE INTERNAL AND EXTERNAL SPHERE OF DATA SUCH AS FINANCIAL, SALES, PROMOTION, MARKETING AND EXTERNAL CUSTOMER SALES THROUGH INTO A COHESIVE SET OF STRUCTURED DATA THAT CAN BE RELIED UPON TO ASCERTAIN PERFORMANCE AND SET TARGETS ACROSS THE ORGANIZATION; AND,br 6. MANAGERIAL EXPERIENCE IN BUSINESS INTELLIGENCE ANALYTICS TEAM.br br MUST POSSESS EXPERTISEKNOWLEDGE SUFFICIENT TO ADEQUATELY PERFORM THE DUTIES OF THE JOB BEING OFFERED. EMPLOYER WILL ACCEPT ANY SUITABLE COMBINATION OF EDUCATION, TRAINING OR EXPERIENCE.
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:2021-06-30
Job Oder End Date:2021-08-04
Sunday Edition Newspaper:Y
First Newspaper Name:Los Angeles Times
First Advertisement Start Date:2021-07-04
Second Newspaper Name:Los Angeles Times
Second Advertisement Type:Newspaper
Second Ad Start Date:2021-07-11
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:2021-06-14
Job Search Website to Date:2021-06-28
Private Employment Firm from Date:
Pricate Employment Firm to Date:
Employee Referral Program from Date:
Employee Referral Program to Date:
Campus Placement from Date:
Campus Placement to Date:
Local Ethnic Newspaper from Date:2021-07-07
Local Ethnic Newspaper to Date:2021-07-07
Radio/TV Ad from Date:2021-07-10
Radio/TV Ad to Date:2021-07-10
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:INDIA
Foreign Worker Birth Country:INDIA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:ELECTRICAL ENGINEERING
Year of Compelted Education:2015
Foreign Worker Istitution of Eduation:UNIVERSITY OF SOUTHERN CALIFORNIA
Foreign Worker Education Instution Address Line 1:UNIVERSITY PARK CAMPUS
Foreign Worker Education Institution Address Line 2:3551 TROUSDALE PKWY
Foreign Worker Education Institution City:LOS ANGELES
Foreign Worker Educatution Institution State:CA
Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
Foreign Worker Education Training Post Code:90007
Foreign Worker Training Completion :N/A
Foreign Worker Required Experience :Y
Foreign Worker Alternate Education and Experience :N/A
