Sr. Sales Planning Analyst

AirReps•HOUSTON, TX

20h

About The Position

This role applies practical knowledge of job area typically obtained through advanced education and work experience. The individual is encouraged to seek continuous improvements and performs a range of mainly straightforward assignments, working independently with general supervision. Problems faced are difficult but not typically complex.

Requirements

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
Customer focus, sales, presentation and negotiation skills, comfortable in working with C-level executives
In-depth knowledge of SQL, Excel, VBA, Maplnfo, CRM, ERP computer programming and relational databases
7+ years of experience in: Quantitative business analysis, Forecasting & production planning, Finance & cost accounting

Nice To Haves

APICS certification a plus
CPA a plus

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