Prevailing Wage Other Source:Aon Radford US Prevailing Wage
Prevailing Wage Determination Date :2023-02-28
Prevailing Wage Expiration Date :2023-06-30
Wage Offer From:140000
Wage Offer To:161000
Wage Offer Unit of Pay:Year
Workstie Address Line 1:2600 Casey Ave.
Worksite Address Line 2:
Worksite City :Mountain View
Worksite State:CALIFORNIA
Worksite Postal Code:94043
Job Title:Staff Business Data 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 :36
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:36
Accept Alternate Job Title:See H.14
Normal Requirements of Job Opportunity:N
Required Foreign Language:N
Specific Skills:Employer will accept a Masters degree in Computer Science, Computer Engineering, Marketing Analytics; or related field and 3 years of work experience in the job offered or in an analystrelated occupation. Position requiresbr br 1. Utilizing big data analytics tools such as Tableau, SQL, or R to evaluate media performance and synthesize business decisions;br 2. Creating media forecasting methodologies and setting paid media goals using predictive models in Excel and R;br 3. Creating and automating media reporting pipelines using Datorama, SQL, and Tableau;br 4. Capturing and analyzing campaign performance and traffic metrics from DSP, DMP, media reporting platforms and web analytics using Google Analytics, Facebook Ads, SA360, Campaign Manager, or Trade Desk;br 5. Developing deep dive analysis in data clean rooms using Google Ads Data Hub and Facebook AA with SQL, using Tableau dashboard to provide actionable insights;br 6. Developing SQL queries to track key marketing metrics in Google BigQuery, performing data analytics with advanced statistics, and using Tableau dashboard to visualize and share key findings; andbr 7. Testing advanced programs for paid media measurement, including AB testing and Media Mix Modeling MMM.
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:2022-12-14
Job Oder End Date:2023-01-18
Sunday Edition Newspaper:Y
First Newspaper Name:The Mercury News
First Advertisement Start Date:2022-12-18
Second Newspaper Name:The Mercury News
Second Advertisement Type:Newspaper
Second Ad Start Date:2022-12-25
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:2023-01-01
Pro.Org. Ad to Date:2023-01-01
Job Search Website from Date:2022-12-14
Job Search Website to Date:2022-12-22
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-12-23
Local Ethnic Newspaper to Date:2022-12-23
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: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:MARKETING ANALYTICS
Year of Compelted Education:2017
Foreign Worker Istitution of Eduation:UNIVERSITY OF ROCHESTER
Foreign Worker Education Instution Address Line 1:40 CELEBRATION DRIVE
Foreign Worker Education Institution Address Line 2: