Prevailing Wage SOC Title :Operations Research Analysts
Prevailing Wage Skill Level:Level I
Prevailing Wage:73694
Prevailing Wage Unit of Pay:Year
Prevailing Wage Source:OES
Prevailing Wage Other Source:
Prevailing Wage Determination Date :2021-11-10
Prevailing Wage Expiration Date :2022-06-30
Wage Offer From:104666
Wage Offer To:120366
Wage Offer Unit of Pay:Year
Workstie Address Line 1:The Landmark One Market St
Worksite Address Line 2:Suite 500
Worksite City :San Francisco
Worksite State:CALIFORNIA
Worksite Postal Code:94105
Job Title:Operations/Business Analyst
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 :6
Accept Alternate Field of Study:Y
Accept Alternate Major:See H.14
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:Y
Acceptable Alternate Occupation Month:6
Accept Alternate Job Title:See H.14
Normal Requirements of Job Opportunity:Y
Required Foreign Language:N
Specific Skills:Minimum Requirementsbr Masters degree in Business Analytics, Math, Business Administration or related field plus 6 months of experience in the job offered or in a business intelligencedata analyticsrelated graduate internship.br br May telecommute.br br Special Requirementsbr Position requires at least 6 months of experience in each of the following skillsbr 1 Formulate and apply mathematical modeling using R and Python to develop and interpret information that assists management or decision making;br 2 Create Rbased and SQL scripts to connect and manage large datasets from multiple data sources;br 3 Automate pipeline of collecting data from Oracle SQL database, feeding into data manipulation R script, and loading formatted output into PowerBI dashboard reports to facilitate stakeholders decisionmaking process;br 4 Perform optimization analysis to identify bottlenecks or customer pain points in business operations by applying scripting languages like R or Pythonbr 5 Monitor and improve data quality by performing data wrangling, cleaning and manipulation using scripting languages such as R and Python;br 6 Create data visualizations using R and Power BI to understand trends, outliers and relationships among variables;br 7 Develop, design and automate interactive selfservice business intelligence dashboards to monitor key performance measures and add customizations over data visualizations using R and PowerBI;br 8 Craft data stories through presentations, written summaries, and data visualizations using Excel, Power BI and Powerpoint that accurately outline problem statements and provide actionable and unbiased intelligence and recommendations;br 9 Work crossfunctionally with various teams by communicating technical analysis results to nontechnical audience and bridging the gaps between technical specifics and business requirements;br br Position also requires at least some work experience or graduatelevel researchcoursework experience in each of the following skillsbr 10 Define key business metrics to evaluate success based on statistical knowledge and domain expertise in web analytics using Adobe Analytics
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-12-27
Job Oder End Date:2022-01-31
Sunday Edition Newspaper:Y
First Newspaper Name:San Francisco Chronicle
First Advertisement Start Date:2022-03-27
Second Newspaper Name:San Francisco Chronicle
Second Advertisement Type:Newspaper
Second Ad Start Date:2022-04-03
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:2022-03-24
Pro.Org. Ad to Date:2022-04-02
Job Search Website from Date:2022-01-18
Job Search Website to Date:2022-02-01
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:2022-03-30
Local Ethnic Newspaper to Date:2022-03-30
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:Y
US Worker Considered:Y
Country of Citizenship:CHINA
Foreign Worker Birth Country:CHINA
Class of Admission :H-1B
Employee Info
Foreign Worker Education:Master's
Foreign Worker Education Other:
Foreign Worker Major:BUSINESS ANALYTICS
Year of Compelted Education:2019
Foreign Worker Istitution of Eduation:UNIVERSITY OF SOUTHERN CALIFORNIA
Foreign Worker Education Instution Address Line 1:UNIVERSITY OF SOUTHERN CALIFORNIA
Foreign Worker Education Institution Address Line 2:
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 :N
Foreign Worker Alternate Education and Experience :N/A
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:Peter B Bade
Preparer Title:Attorney
Preparer Email :autodeskiv@cipllp.com
Employer Information Declaration Name:Michael MacDonald
Employer Declaration Title:Global Mobility Program Manager