Your browser cookies must be enabled in order to apply for this job. Please contact support@jobscore.com if you need further instruction on how to do that.

CRM Data Analyst

Sales and Marketing | Palo Alto, CA | Full Time

Job Description

TITLE: CRM Data Analyst

DURATION: Permanent Employee

LOCATION: Palo Alto, CA (right next to California Avenue Caltrain stop)

ABOUT SHIPWIRE (AND OUR EXCITING FUTURE)

We pioneered cloud logistics with our on-demand fulfillment center and shipping tools, Web services, innovative developer tools and integration with today's top e-commerce platforms.  Our award-winning platform provides on-demand e-commerce fulfillment and supply chain management from a network of global pick-pack and ship warehouses in the U.S., Canada, Europe and Asia to more than 1,000 emerging brands and web retailers.   

It's an incredibly exciting time for our organization. In December 2013 we were acquired by Ingram Micro Inc. (NYSE: IM), a Fortune 100 company who is also the world's largest wholesale technology distributor and a global leader in supply-chain and mobile device lifecycle services.  This will allow us to accelerate our platform (much more quickly than we could have as a stand-alone company) in a $40 billion market for e-commerce fulfillment services that is estimated to be growing by double-digits through 2015.  The full details are publicly available here: http://goo.gl/mSHCjc

As a stand-alone subsidiary of Ingram Micro in the Silicon Valley we will be continuing our start-up culture and maintaining our focus on revolutionizing the supply chain in favor of emerging brands.  Through Ingram we have access to global facilities and distribution strength that will accelerate our innovation.  Our charter is to be visionary and define the future of this market.   

Exciting?  We think so.

POSITION RESPONSIBILITIES

  • Work with department heads to plan, build, and iterate various reports and dashboards that support “forecasted vs. actual” and other visibility in the areas of marketing, sales, care, account management, and operations
  • Be responsible not only for the execution of, but act as a partner for strategic business planning
  • Work with sales operations and marketing operations to generate queries from CRM and marketing automation databases
  • Use Excel tables and charts to tell a story with the data
  • Wrapper the data and present it in PowerPoint
  • Build solid, flexible models from raw data
  • Automate and document processes so that “refreshing” data takes the least amount of cycles and there will be a reference point for future analysts
  • Snapshot and archive metrics for reference
  • Perform ad-hoc data reporting exercises

CANDIDATE REQUIREMENTS

  • 3-5 years experience with data consolidation, analysis and forecasting with spreadsheets
  • Excel whiz - must know all the logic functions in the book + pivot tables and charts
  • Experience with SQL (MySQL) desired
  • Experience with Macros in the Powerpoint and Excel context preferred
  • Familiarity (experience preferred) with B2B recurring revenue and SaaS models/business concepts
  • Proficiency in PowerPoint
  • Familiarity with reporting and data structure in Salesforce CRM preferred
  • Experience with marketing automation tools (Marketo, Eloqua) preferred
  • Bachelors Degree in economics, statistics, finance, information systems, marketing or related field
  • Proficiency with Google Apps preferred
  • Excellent oral and written communication skills
  • Live and breath data - you must love working with data
  • Track record of getting things done on time and on spec
  • Good nose and field vision for reporting objectives - should understand not just how, but why we’re doing what we’re doing