Clackamas, Oregon
Sales Analyst Job Opening in Clackamas, Oregon - JOB SUMMARY
The Sales Analyst is responsible for the collection, analysis and reporting of sales related data in an on-going effort to increase overall sales productivity. This individual must collect sales records and evaluate performance based on sales quotas while taking into consideration current market economic conditions. The development and tracking of key performance indicators will be critical to enhance the understanding of the business and to improve decision making.
The Sales Analyst will create both standardized and custom reports, conduct quantitative product and sales analysis, provide support for internal, retailer and consumer promotions, and assess future needs and data integrity. This individual must develop standardized tools, methodologies and business processes amid at improving operational efficiency.
ESSENTIAL FUNCTIONS
It is essential for all employees to adhere to Company policies.
Collect, analyze, evaluate and report data to increase sales productivity
Collect sales records and trends and evaluate performance measured against sales quotas
Analyze sales and performance record, interpret results of overall sales, recommend promotion or change of personnel in under-productive departments
Assist management in developing and reviewing the sales budget and rolling sales forecast including sales to budget variance analysis
Analyze line of business operations (product lines, stores, etc.) to determine profitability and to establish a baseline for action and operational changes
Develop models and reporting structure that identify costs (by function, process, fixed, variable) per unit (store, order, script, other) and identify a baseline for action
Guides sales people (Key Accounts, Regional Sales, etc.) in entering an accurate forecast in our CRM tool, generate reports for forecast and collaborate forecasts into weekly-monthly reports
Align with business analysts, administrators and users of ERP-CRM-reporting tools to reflect sales structure in systems
Co-ordinate the complete sales reporting and forecasting process for all sales channels (Key Accounts, Regional Sales, Vehicle Navigations and Data Products)
Communicating sales reports and sales forecasting to Senior
Analyze results and set up reports containing respective conclusions, ideas and general guidance
Generate ad hoc reporting for Sales and Marketing
Provide customized reporting and recommendations in support of ongoing business decisions or initiatives
Work with forecasting by providing them with the necessary information and guidance for short and long-range forecast
Conduct quantitative analysis including but not limited to ROI, trending, identification and assessment of opportunity and risk, forecasting, regressions, correlations, cannibalization and probability modeling
Communicate results to Executives to support informed business decisions by providing in-depth analysis and recommendations
Ensure current and future data and software requirements are met to provide accurate decision support to the business
Other duties as assigned.
KEY BEHAVORIAL ATTRIBUTES
Commitment to high ethical standards
Integrity in everything
Self-Motivated
Persuasive with details and facts
Positive Demeanor
Inspires collaborative thinking and team building
Dependable, exemplifying this through attendance and job duties
Constantly seeking better processes and challenging status quo: Continuous Improvement
Bachelor?s degree; appropriate experience in lieu of degree
2 - 5 years? experience in a Sales Analyst role
Expert knowledge of SQL, Excel, Foxpro, VBA, Mapinfo, CRM, computer programming and relational databases
Strong knowledge of MS Office applications including Word, Excel, Project and PowerPoint
Ability to build and maintain complex computer applications and programs that perform analysis, organize data and create reports from various sources
Knowledge of relational database and the ability to create stored procedures
Ability to perform complex analysis such as regression, forecasting, cannibalization and probability modeling
Ability to capture and document business and reporting requirements from multiple sources
Ability to co-ordinate and manage simulations data analysis of varying sizes and scope
Strong communication skills, both written and verbal, with the ability to convey complex information to a broad audience
Strong interpersonal skills with the ability to work independently and within a team environment
Detail oriented, analytical thinker
Entrepreneurial approach to managing the area
UNPLANNED DUTIES
Job may require hours that often exceed 8 hours per day and/or 40 hours per week
Must be able to pass a drug sceen
Does this position require protective equipment?
Yes No
Does this position require a Non-Compete Agreement?
Yes No
The characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The information contained in this job description is for compliance with the Americans with Disabilities Act (ADA) and is not an exhaustive list of the duties that may be required for this position. Additional duties are performed by the individuals currently holding this or similar positions and additional duties may be assigned.
EQUAL OPPORTUNITY EMPLOYER
Job Type: Full-time
Salary: $55,000.00 to $65,000.00 /year
Required education:
Bachelor's
Required experience:
Sales Analyst: 2 years
|
