For visitors, travel, student and other international travel medical insurance.
Visit insubuy.com or call +1 (866) INSUBUY or +1 (972) 985-4400Greencard Sponsors
Greencard Sponsors Case Details
Certified-Expired
ACER AMERICA CORPORATION (San Jose, CALIFORNIA)
Job Title: Business Intelligence Analyst (Data Warehouse)
Wage Rate: $116,043.00
Employer Business Identification
Employer Name
ACER AMERICA CORPORATION
Fiscar Year
2023
Case Status
Certified-Expired
Case Number
A-22144-60380
Received Date
5/27/22
2007 NAICS US Code
334111
Job Title
Business Intelligence Analyst (Data Warehouse)
Country of Citizenship
INDIA
Prevailing Wage Information
SOC Code
15-1199
Level
Level II
Wage Rate
116043.0
SOC Title
Data Warehousing Specialists
Source
OES
Wage Rate & Work Location
Wage Rate
$116,043.00 per year
City
San Jose
State
CALIFORNIA
Contact & Attorney Information
Attorney Firm Name
Minami Tamaki LLP
Attorney Name
David M Palmer
Attorney Location
San Francisco, CALIFORNIA
Others
Decision Date
2/23/23
Refile
N
Scheduled A Sheepherder
N
Employer Phone
408-533-7700
Employer Number of Employees
416
Employer Year of Commenced Business
1976
FW Ownership Interest
N
Employer Contact Name
Lenny Pollak
Employer Contact Address 1
1730 North First Street
Employer Contact Address 2
Suite 400
Employer Contact City
San Jose
Employer Contact State/Province
CALIFORNIA
Employer Contact Postal Code
95112
Employer Contact Phone
408-533-7700
Employer Contact Email
[email protected]
Agent Attorney Phone
(415) 788-9000
Agent Attorney Email
[email protected]
Prevailing Wage Tracking Number
P10021224518078
Prevailing Wage Determination Date
4/7/22
Prevailing Wage Expiration Date
7/6/22
Minimum Education
Master's
Major Field Of Study
Comp Sci, Tech Mgmt, Bus Admin, Eng (any) or a rel fld
Required Training
N
Required Expirence
N
Acceptable Alternate Field Of Study
N
Acceptable Alternate Combination
N
Foreign Education Acceptable
Y
Alternate Occupation Experience Acceptable
Y
Alternate Occupation Experience Months
24
Alternate Occupation Job Title
Business Intelligence Analyst, Business Intelligence Developer, or a related occupation.
Job Opportunity Requirements Normal
N
Foreign Language Required
N
Specific Skills
Masters degree or foreign equivalent degree in Computer Science, Technology Management, Business Administration, Engineering any or a related field, plus 2 years of work of experience as a Business Intelligence Analyst, Business Intelligence Developer, or a related occupation.br br Experience must include 1. Relational Database, including planning, defining designing database and policies; 2. Business Intelligence Tools, including SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, defining KPIs using Data Analysis Expressions DAX, and SQL Server Reporting Services SSRS; 3. Building reports using data visualization tools, including Power BI, visual reports, dashboards and KPI scorecards; 4. TSQL Programming and SQL optimization, including DDL, DML, DCL commands, Stored Procedures, Functions, and Views; and 5. Debugging and troubleshooting, including production issues, data quality issues, root cause analysis.
Combination of Occupations
N
Offered To Foreign Worker
Y
Foreign Worker live in Employer Premises
N
Live-in Domestic Service Worker
N
Professional Occupation
Y
College or University Teacher
N
SWA Job Order Start Date
3/28/22
SWA Job Order End Date
4/26/22
Sunday Edition News Paper
Y
First News Paper Name
Mercury News
First Advertisement Start Date
11/28/21
Second News Paper Ad Name
Mercury News
Second Advertisement Type
Newspaper
Second Ad Start Date
12/5/21
Job Search Website From Date
5/24/22
Job Search Webiste To Date
5/25/22
Local Ethnic Paper From Date
12/3/21
Local Ethnic Paper To Date
12/3/21
Radio TV Ad From Date
11/30/21
Radio TV Ad To Date
11/30/21
Employer Received Payment
N
Bargaining Representative Notified
N/A
Posted Notice At Worksite
Y
Layoff In Past Six Months
N
Foreign Worker Birth Country
INDIA
Class Of Admission
H-1B
Foreign Worker Education
Master's
Foreign Worker INFO Major
TECHNOLOGY MANAGEMENT
Foreign Worker Education Completed
2013
Foreign Worker Educational Institution
SOUTHEAST MISSOURI STATE UNIVERSITY
Foreign Worker Educational Institution Address 1
1 UNIVERSITY PLAZA
Foreign Worker Educational Institution City
CAPE GIRARDEAU
Foreign Worker Educational Institution State
MO
Foreign Worker Educational Institution Country
UNITED STATES OF AMERICA
Foreign Worker Educational Institution Postal Code
63701
Foreign Worker Training Completed
N/A
Foreign Worker Has Required Work Experience
N/A
Foreign Worker Alternate Education/Experience
N/A
Foreign Worker Has Experience in Alternate Occupation
Y
Foreign Worker Experience With Employer
N
Employer Paid For Education
N
Foreign Worker Currently Employed
Y
Employer Completed Application
N
Preparer Name
David M Palmer
Preparer Email
[email protected]
Name Of Person Signing Employer Declaration
Lenny Pollak
Title of Person Signing Employer Declaration
VP of Human Resources Administration
Disclaimer: The H1B Sponsors Employers Search tool is intended for informational purposes only. immihelp®.com does not claim any affiliation nor endorsement relationship with any company appearing in the H1B Sponsors Employers Search tool.
