SALES PLANNING ANALYST

Thermal-Supply,-In; Seattle (WA); Hybrid; USD 66,000 - 83,000; Full time

Job summary

Thermal-Supply,-In seeks a Sales Planning Analyst to drive data-driven forecasting and reporting for multiple product classes. You will collect sales data, analyze economic conditions by channel and region, and develop standardized tools and processes to improve efficiency and decision making.

Responsibilities include creating monthly forecasts, inventory planning by model and SKU, and preparing sales/margin reports.

Qualifications

• Working knowledge of finance-cost accounting, forecasting and planning methodologies.
• Ability to build and maintain complex computer applications and programs that perform analysis, organize data & create reports from various sources.
• Knowledge of relational databases and the ability to create stored procedures.
• Ability to perform complex analysis such as regression, forecasting, and probability modeling.
• Ability to capture and document business and reporting requirements from multiple sources.
• Ability to co-ordinate and manage simultaneous data analysis requests of varying size and scope.
• Advanced Excel skills and strong in Access.
• Excellent written/verbal communication and presentation skills.

Responsibilities

• Create aggregate monthly sales forecast by model for assigned product class.
• Prepare monthly inventory plan by model for assigned product class.
• Forecast sales demand by product class and SKU.
• Prepare monthly inventory plan by SKU.
• Prepare and compile sales/margin reports related to assigned product class or requested business unit data.
• Maintain distribution warehouse inventory levels based on established lead times while managing within approved budget.
• Maintain working relationships with cross-functional teams to optimize efficiency and ensure smooth product flow to the customer.
• Manage phase-in and phase-out of new product introductions and transitions.
• Analyze large amounts of sales and inventory data to make proficient production decisions at the SKU level.
• Collect business intelligence data from available industry reports, public information, field reports, or purchased sources.
• Communicate across all business disciplines both verbally and written.
• Perform validation and testing of models to ensure adequacy and reformulate models as necessary.
• Gather, compile and analyze data from various sources, including offsite sales personnel in the field.
• Assist in annual planning and preparation of tools.
• Create/maintain sales/margin reports that assist key sales management personnel throughout business unit.
• Participate in additional projects to support ongoing business needs.

Skills

Finance & cost

Forecasting

Data analysis

Advanced Excel

Relational DB

Stored procedures

Regression modeling

Reporting requirements

Communication

Teamwork

Decision making

Problem solving

Education

Bachelor's Degree

Job description

Locations

Showing 1 location

Seattle TSI 717 S Lander St Seattle, WA 98134, USA

Seattle TSI 717 S Lander St Seattle, WA 98134, USA

• Hybrid
• Finance
• Full-Time
• Requisition #: SALES014291

Description

The Sales Planning Analyst is responsible for the collection, analysis, and reporting of sales related data in an on-going effort to increase overall sales productivity. Collect relevant internal. external sales data and economic conditions by channel and region in order to accurately forecast sales. Develop and track key performance indicators considered instrumental in enhancing business understanding and improve decision-making. The Sales Planning Analyst will create both standardized & custom reports, conduct quantitative product & sales analysis; provide support other assistance as necessary assessing future needs and data integrity. Develop standardized tools, methodologies and business processes to improve operational efficiency.

Position Responsibilities may include:

• Create aggregate monthly sales forecast by model for assigned product class
• Prepare monthly inventory plan by model for assigned product class
• Forecast sales demand by product class and SKU
• Prepare monthly inventory plan by SKU
• Prepare and compile sales/margin reports related to assigned product class or requested business unit data
• Maintain distribution warehouse inventory levels based on established lead times while managing within approved budget
• Maintain working relationships with cross-functional teams to optimize efficiency and ensure smooth product flow to the customer
• Manage phase-in and phase-out of new product introductions and transitions
• Analyze large amounts of sales and inventory data to make proficient production decisions at the SKU level
• Collect business intelligence data from available industry reports, public information, field reports, or purchased sources
• Communicate across all business disciplines both verbally and written
• Perform validation and testing of models to ensure adequacy and reformulate models as necessary
• Gather, compile and analyze data from various sources, including offsite sales personnel in the field
• Assist in annual planning and preparation of tools
• Create/maintain sales/margin reports that assist key sales management personnel throughout business unit
• Participate in additional projects to support ongoing business needs

Nature & Scope:

• Possesses a broad theoretical job knowledge typically obtained through advanced education
• Has no discretion to deviate from established procedures by performing structured work assignments
• Work is closely supervised
• Problems faced are not typically difficult nor complex
• Explains facts, policies and practices related to job area

Knowledge & Skills:

• Working knowledge of finance-cost accounting, forecasting and planning methodologies
• Ability to build and maintain complex computer applications and programs that perform analysis, organize data & create reports from various sources
• Knowledge of relational databases and the ability to create stored procedures
• Ability to perform complex analysis such as regression, forecasting, and probability modeling
• Ability to capture and document business and reporting requirements from multiple sources
• Ability to co-ordinate and manage simultaneous data analysis requests of varying size and scope
• Advanced Excel skills and strong in Access
• Must have strong analytical, quantitative and problem-solving skills, high level of attention to detail
• Ability to anticipate and solve practical problems and resolve issues
• Excellent written/verbal communication and presentation skills
• Ability to apply good judgement, decision making skills and strong work ethics and integrity on the job
• Strong interpersonal skills with the ability to work independently and within a team environment

Competency:

Experience:

• 3+ years of experience in: Quantitative business analysis, Forecasting & production planning, Finance & cost accounting

Education/Certification:

• Bachelor’s Degree (Statistics, Mathematics, Logistics, Finance, Accounting, etc.) or 4 years’ sales planning experience in a high paced environment

People Management: No

Physical Requirements / Work Environment:

• Must be able to perform essential responsibilities with or without reasonable accommodations.

Reports To:

Salary: $66,140.00 to $82,730.00

Qualified Applicants must be legally authorized for employment in the United States. Qualified applicants will not require employer sponsored work authorization now or in the future for employment in the United States.

The Company provides equal employment opportunity to all employees and applicants regardless of a person’s race, color, religion (including religious dress or grooming practices), creed, national origin (including language use restrictions), citizenship, uniform service member or veteran status, ancestry, disability, physical or mental disability (including HIV/AIDS), medical condition (including cancer and genetic characteristics), genetic information, request for protected leave, marital status, sex, pregnancy, age (over 40), sexual orientation, gender, gender identity or expression, political affiliation, or any other characteristic protected by law. The Company will comply with all federal and state regulations and statutes pertaining to individuals with disabilities.

Qualifications

Skills

Behaviors

:

Motivations

:

Education

Experience

Licenses & Certifications

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.