Data Analyst III

Data Analyst IIIJob Description We are seeking an experienced Contractor to support a Senior Manager in Marketing Operations in providing conference statistics, data analytics, forecasting, reporting, responding to requests for data and in ensuring data integrity between multiple databases. This critical role will deliver the business analysis, sales support and registration reporting necessary for the company to reach its registration goals and objectives. You will work directly with marketing, sales and IT teams to understand and deliver key reporting and recommend enhancements to optimize visibility and results for Dreamforce. The scope of the role will also include analysis, reporting and creation of executive level presentations for Salesforce. Coms global events. Responsibilities will increase as the Contractor demonstrates success in understanding processes, methodologies and systems and shows initiative in tackling more complex projects. Responsibilities will include: Consolidate and disseminate weekly (and potentially daily) updates of Dreamforce registration data (critical conference stats) from multiple systems and distill into executive level presentations illustrating trends and providing comprehensive analysis Develop and improve upon current forecast models for Dreamforce and other events Analyze and evaluate existing Excel models for trending and forecasting and improve upon methodologies Ensure that data is accurately flowing between two different database systems and develop a repeatable process to ensure accuracy Monitor registration data to ensure that key business stakeholders are kept current on registration trends Build, maintain, update and optimize critical dashboards in Salesforce.com for key business stakeholders in marketing and sales Assist in developing executive level presentations providing concise analyses of critical conference statistics Assist in developing framework for global events reporting standards including processes and refining critical metrics definitions Provide analysis and develop executive briefings based on analyses for all global events Assist, as requested, in extracting data and performing requisite analyses to answer critical business questions on demographics, trends, forecasting and other key variables as requested by business stakeholders Monitor Chatter posts to Dreamforce related Groups and provide answers and information as requested Work closely with Sales Account Executives and Sales Management to answer questions about their Dreamforce dashboards and registrations statistics/data in their respective regions Assist in developing comprehensive model to allocate regional Dreamforce pass sales quotas Assist, as requested, in providing updates and reporting on SPIFF programs to customer-facing teams Assist in providing weekly reporting on Sales Quota status, discount/comp budget usage, top accounts and pipeline. Analyze and improve upon all current models that track this data Provide periodic pull lists for all Dreamforce email campaigns, both for targeting and suppression Assist in providing logistics reporting to events team on areas including hotels, session capacities, on-site attendance Assist, as requested, in developing post-event reporting including survey results and influence analysis Assist, as requested, in developing the post-event wrap-up slides related to registration, attendance, customer satisfaction Assist, as requested, in performing analysis to help guide business decision making. Understand trends in data and highlight this to management. Assist, as requested, in providing support, analyses and insight for other high visibility marketing projects Ensure adherence to corporate data security requirements for the storage, transportation and retention of data. Required Skills/Experience: 4-6 years' experience as a data analyst or similar role Very strong Excel skills. This is mission critical Adept at integrating disparate information, building forecast and trending models, developing comprehensive charts, working with pivot tables, analyzing large tables of data, comfortable using VLOOKUP and other data analysis formulas, strong aptitude for correlating data and finding critical data trends. Salesforce.com. Experience in building and creating reports and dashboards in Salesforce.com PowerPoint. Strong ability to distill data analysis, insight and other key findings into executive level PowerPoint briefings Experience using Business Objects and other Business Intelligence tools (ie Tableau). Track record of identifying business data needs, performing detailed and insightful analysis and developing reports that meet these needs and drive business results. Ability to provide analysis and insight based on partial information Strong analytical and problem-solving skills Must be able to work well in a team environment Ability to understand the business and anticipate data needs Must be comfortable with changing requirements and priorities and working in a fast paced, high-pressure environment Excellent verbal and written communication skills; ability to communicate effectively with different levels of management Demonstrated ability to be productive with minimal supervision. Must be results oriented and able to move forward without complete information Experience with data quality assessment and implementing solutions to improve the data quality is a plus Experience working with events and large conferences is a plus'sInterested candidates please send resume in Word format Please reference job code 144421 when responding to this ad.