Sales Reporting Analyst

Position: Sales Reporting AnalystLocation: Sunnyvale, CA and Elk Grove, CADuration: 6+ Months
Responsibilities:
Exp:8+ Years
Support sales account managers and assist with their daily reporting responsibilities, including:
In-Flight Campaign Reporting:
daily and weekly data extraction from campaign booking tool (Workbench) including but not limited to the following breakouts:
Summary level
Line level
By creative
MTD activity
Post campaign summary reporting
extracting data, aggregating data, and configuring to custom client templates
Campaign creative
Screenshots of live creative during campaign
Data Formatting
CSV file extraction, transfer into excel client custom file template with three tabs, update date ranges from UK to US
Transfer CSV data to internal excel file with VLOOKUP formulas, organize columns according to client custom template, transfer data into external Google sheet
• Cross-reference client IO naming convention for creative level CSV report placed into client custom template
Job Type: Contract
Pay: $55.00 - $60.00 per hour
Benefits:

401(k)
Dental insurance
Health insurance

Schedule:

Day shift

Education:

High school or equivalent (Preferred)

Experience:

csv: 5 years (Required)
Sales: 6 years (Required)
REPORTING: 6 years (Required)

Ability to Commute:

Sunnyvale, CA 94087 (Preferred)

Work Location: In person