Skip Navigation

Business Analyst

Apply Now
Job location: New York, New York Position type: Professional Req No: 18008868
Nestle Nespresso is looking for a Business Analyst to join our growing B2B department to contribute to the reporting framework and forecasting of our B2B sales team’s activities.

The Business Analyst will be responsible for building and maintaining the Sales Reporting Framework, delivering Forecasting tools and models in alignment with Finance and other departments. Additionally, the Business Analyst will support related functions (e.g. CRM, Finance, Sales, Operations) with solid and standardized generic reports and handling and supporting reporting and analytics-related system changes and migrations (e.g. recreating existing reporting standards within a future BW system and reporting environment).

Responsibilities:
Supply and Evolve monthly & daily reporting (incl. management & improvement):
• Prepare and execute monthly & daily reports (both sell-in and sell-out, direct & distribution) and supply them to target audience
• Coordinate necessary data retrievals from other departments (e.g. finance, sales teams)
• Create and maintain documentation for existing and new reports
• Train other departments (e.g. sales) on ways of working for the reports
• Provide Internal Control analysis (e.g. Free Goods)
• Run analysis for the monthly commissions calculation for the Sales team

Creation & Standardization of Sales Reporting:
• Build and maintain based on the requirements of the sales organization standards for reporting
• Optimize existing reports based on the evolving requirements
• Standardize raw data extraction from BW based on the actual system (today COGNOS, Future SAP/Hana)
• Accompany evolution in data warehouse system from sales (reporting) perspective and migrate actual reports to new reporting system
• Make changes in account ownership in the system (e.g. account hand-over from direct to distribution)

Monthly Business Planning & Ad-hoc Analysis:
• Support and evolve MBP-cycle (reports and meetings):
- Preparation of MSR & MGR meetings (e.g. presentation deck, forecast details)
- Maintaining the forecast template
- Collecting the team inputs for the monthly forecast and aggregating it
• Support and create efficient ad-hoc analysis for sales team and other departments (e.g. Finance, TQM)
• Calculation of quarterly Distribution Partner rebates

REQUIREMENTS:

Education:
• Bachelor's Degree Required

Experience:
• 3+ years of experience in reporting & analytics required
• 2+ years of experience in Sales & Marketing preferred
• Excellent Excel and Power BI skills required
• Excellent PowerPoint and presentation building skills preferred
• Experience with SAP, Cognos, or Oracle preferred


The Nestlé Companies are equal employment and affirmative action employers and looking for diversity in qualified candidates for employment.
.
Apply Now