Business Analyst (Excel/ VBA) Palo Alto, CA Business Analyst/Data Analyst - Short term contract - Palo Alto - 50% time Remote work REQUIRED • Ability to import and format data from a variety of sources, merge and integrate records • Use of complex calculations, formulas, formatting, functions • Data analysis, • Create graphs, scattergrams, trendlines, distribution tables, PivotTables • Write custom automated macros and validate them to perform these activities Working Environment *** Work from home 50% of time could be possible • PC • VPN access to the Client Project Objectives: 1. Consolidate multiple input streams and integrate into a series of records for data analysis and trending of information. 2. Using Excel Macros and VBA automate the importing and reporting of the information calculated. 3. Create a management dashboard for analyzing and reviewing the information. 4. Create charts, graphs, and reports as requested regarding the information and data. Skills: • Microsoft Office • SharePoint • LiveMeeting Advanced Excel and VBA skills Palo Alto ATR76064 3 to 6 weeks contract