Case Details

Case info Company Info HR Info Attorney Position Info Employee Info
Case info
  • Data Publish Year :2022
  • Case Number:A-21055-55128
  • Case Status:Certified-Expired
  • Received Date:2021-04-01
  • Decision Date:2021-10-21
  • Refile:N
  • Original File Date:
  • Previous State Work Force Agency (SWA) Case Number Stete:
  • Schedule A or a Sheepherder Occupation :N
Company Info
  • Employer Name:M. ARTHUR GENSLER JR. AND ASSOCIATES INC.
  • Employer Address_Line 1:2101 WEBSTER STREET
  • Employer Address_Line 2:SUITE 2000
  • Employer City :OAKLAND
  • State:
  • Employer State/ Province:CALIFORNIA
  • Employer Country:UNITED STATES OF AMERICA
  • Employer Postal Code:94612
  • Employer Phone No.:510-625-7459
  • Employer Phone Extent No.:
  • Total Number of Employees:6000
  • Employer Year of Commenced :
  • NAICS Code:541310
  • Foreign Worker Ownership & Interest:N
HR Info
  • Employer Contact Name:Despina P Pigott
  • Employer Contact Address Line1:45 Fremont St
  • Employer Contact Address Line2:Suite 1500
  • Employer Contact City:San Francisco
  • Employer Contact State/ Provice:CALIFORNIA
  • Employer Contact Country :UNITED STATES OF AMERICA
  • Employer Contact Post Code:94105
  • Employer Contact Phone:415-836-4296
  • Employer Contact Email:despina_pigott@gensler.com
Attorney
  • Agent/ Attorney Name:Anna Mikolajczak
  • Agent/ Attorney Firm Name:Fakhoury Global Immigration, USA PC
  • Agent/ Attorney Phone:(248) 643-4900
  • Agent/ Attorney Phone Ext.:
  • Agent/ Attorney Address Line 1:5250 Corporate Drive
  • Agent/ Attorney Address Line 2:Ste 300
  • Agent/ Attorney City:Troy
  • Agent/ Attorney State/ Province:MICHIGAN
  • Agent/ Attorney Country:UNITED STATES OF AMERICA
  • Agent/ Attorney Postal Code:48098
  • Agent/ Attorney Email:anna@employmentimmigration.com
Position Info
  • Prevailing Wage Track Number:P10020163647746
  • Prevailing Wage SOC Code :15-1131
  • Prevailing Wage SOC Title :Computer Programmers
  • Prevailing Wage Skill Level:Level II
  • Prevailing Wage:97261
  • Prevailing Wage Unit of Pay:Year
  • Prevailing Wage Source:OES
  • Prevailing Wage Other Source:
  • Prevailing Wage Determination Date :2020-10-06
  • Prevailing Wage Expiration Date :2021-06-30
  • Wage Offer From:97261
  • Wage Offer To:
  • Wage Offer Unit of Pay:Year
  • Workstie Address Line 1:2101 Webster Street
  • Worksite Address Line 2:Ste 2000
  • Worksite City :OAKLAND
  • Worksite State:CALIFORNIA
  • Worksite Postal Code:94612
  • Job Title:Tableau Report Analyst
  • Minimum Education:Master's
  • Other Degree/ Diploma:
  • Major Field of Study:Computer Science, or related field
  • Required Training:N
  • Required Training Month:
  • Required Field of Training:
  • Required Experience :Y
  • Required Expreience Months :12
  • Accept Alternate Field of Study:N
  • Accept Alternate Major:
  • Alternate Combination of Education/ Experience:Y
  • Required Alternate Level of Education :Bachelor's
  • Other Alternate Level of Education:
  • Acceptable Years of Experience:5
  • Accept Foreign Educationa:Y
  • Acceptable Alternate Occupation:Y
  • Acceptable Alternate Occupation Month:12
  • Accept Alternate Job Title:Comp Prgrmr,Tableau Rprt Anlyst,Data Quality Analyst,Tableau Developer or rel position
  • Normal Requirements of Job Opportunity:N
  • Required Foreign Language:N
  • Specific Skills:Must have one 1 year of IT experience with all of the following 1 Tableau, SSRS, SSIS, AQT, Teradata, and SAS; 2 Implementation and execution of Scripts using SQL for reporting; 3 Building monitors, reports and reviewed quality for reporting; 4 Verifying data integrity and compliance by performing data cleansing, data audit andor data validation; 5 Performing Optimization of Workbooks and Data Sources; 6 Building data visualizations and designs for easy user experience; AND 7 Perform testing in order to ensure data quality. In the alternative, we will accept a Bachelors Degree or foreign equivalent in Computer Science, or related field, plus five 5 years of progressive IT postbachelors degree experience. One 1 year of the five 5 years of progressive experience must include experience with all of the following 1 Tableau, SSRS, SSIS, AQT, Teradata, and SAS; 2 Implementation and execution of Scripts using SQL for reporting; 3 Building monitors, reports and reviewed quality for reporting; 4 Verifying data integrity and compliance by performing data cleansing, data audit andor data validation; 5 Performing Optimization of Workbooks and Data Sources; 6 Building data visualizations and designs for easy user experience; AND 7 Perform testing in order to ensure data quality. All experience may be acquired concurrently.br br Any suitable combination of education, training or experience is acceptable.
  • 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-09
  • Job Oder End Date:2021-01-13
  • Sunday Edition Newspaper:Y
  • First Newspaper Name:San Francisco Chronicle
  • First Advertisement Start Date:2020-12-20
  • Second Newspaper Name:San Francisco Chronicle
  • Second Advertisement Type:Newspaper
  • Second Ad Start Date:2020-12-27
  • Job Fair From Date:
  • Job Fair to Date:
  • On Campus Recruiting from Date:
  • On Campus Recruiting to Date:
  • Employer Website from Date:2020-12-11
  • Employer Website to Date:2020-12-22
  • Pro. Org. Ad from Date:
  • Pro.Org. Ad to Date:
  • Job Search Website from Date:2020-12-16
  • Job Search Website to Date:2020-12-29
  • Private Employment Firm from Date:
  • Pricate Employment Firm to Date:
  • Employee Referral Program from Date:
  • Employee Referral Program to Date:
  • Campus Placement from Date:2020-12-11
  • Campus Placement to Date:2020-12-25
  • Local Ethnic Newspaper from Date:2021-01-06
  • Local Ethnic Newspaper to Date:2021-01-12
  • 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: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:COMPUTER SCIENCE
  • Year of Compelted Education:2017
  • Foreign Worker Istitution of Eduation:TEXAS AM UNIVERSITY
  • Foreign Worker Education Instution Address Line 1:2200 CAMPBELL ST
  • Foreign Worker Education Institution Address Line 2:
  • Foreign Worker Education Institution City:COMMERCE
  • Foreign Worker Educatution Institution State:TX
  • Foreign Worker Education Institution Country :UNITED STATES OF AMERICA
  • Foreign Worker Education Training Post Code:75428
  • Foreign Worker Training Completion :N/A
  • Foreign Worker Required Experience :Y
  • Foreign Worker Alternate Education and Experience :Y
  • Foreign Worker Alternate Occupation Experience:Y
  • Foreign Worker Experience with Employer:N
  • Foreign Worker Employer Pay for Education:N
  • Foreign Worker Currently Employed:Y
  • Employer Completed Application :N
  • Preparer Name:Anna Mikolajczak
  • Preparer Title:Attorney
  • Preparer Email :anna@employmentimmigration.com
  • Employer Information Declaration Name:Despina P Pigott
  • Employer Declaration Title:Director of Immigration and Mobility
Back to Top

Contact Us : contact@iadapt.ca

Office Address : Social Innovation Hub Unit #290, 3553 31 St NW Calgary, AB, Canada T2L 2K7 (Please contact us in advance for visiting)