BCforward is currently seeking highly motivated Data Analyst in Powell, OH 43065(Remote)
Role: Data Analyst
Location: Powell, OH 43065(Remote)
Duration: 6+ Months
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.
The Contractors 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.
1-2 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'
Interested candidates please send resume in Word format Please reference job code 149892 when responding to this ad.