Sr. Sales Planning Analyst- Japanese Bilingual

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 

Nature and Scope: 

• Works within knowledge 
• May provide guidance

Knowledge and 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 
• 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 

Experience:

• 7+ years of experience in: Quantitative business analysis, Forecasting & production planning, Finance & cost accounting 
• Must have business level Japanese and English bilingual

Education:

• Bachelor’s Degree (Statistics, Mathematics, Logistics, Finance, Accounting, etc.) 
• APICS certification a plus, CPA a plus 

To apply please email you resume to airaha@pasona.com