The Demand Analyst will lead design architecture inside Anaplan™ Demand Planning module, and design supporting visual reports via Microsoft Power BI linked to Microsoft AZURE datasets. The end goal is to provide key insights via forecasting data services to meet the needs for our Sales and Product Management groups.
Requirements
- Strong knowledge of Microsoft Power BI data visualization software
- Strong understanding of Multi-Dimensional data architecture
- Proficiency in building and managing data solutions using Power BI and Azure services, designing and managing Azure SQL tables and Azure data storage.
- Proficiency in Python coding.
- Experience with demand planning systems such as Anaplan or in machine learning forecasting and predictive analytics is preferred.
- Excellent problem-solving skills and attention to detail.
- Basic knowledge of sales forecasting.
Responsibilities
- Develop, maintain, and optimize demand forecasts using statistical models, historical data, and market trends in Anaplan’s system software
- Use Data Science to analyze sales data, inventory levels, and market trends to provide actionable insights and recommendations by gathering data from multiple sources and using various tools, data visualization, and techniques (Excel pivot tables, Azure SQL, Python, PowerBI, Azure Data Explorer, R coding, MS Copilot)
- Produce PowerBI paginated reports and dashboards, and presentations communicating key findings and insights to stakeholders
- Conduct sales channel and macro trend research in alignment with data analysis to identify trends, patterns and insights that can inform business decisions and forecast analysis.
- Monitor key performance indicators (KPIs) for demand planning and inventory management
- Conduct root cause analysis for forecast inaccuracies and develop strategies for continuous improvement
- Work with Anaplan Solutions Architects to either directly build or lead 3rd party contractors to the end-to-end design of an Anaplan Model.
Other
- Coordinate and host monthly meetings with Sales and Product Management teams to solidify a sales forecast.
- Collaborate with Sales, Marketing, and Product departments to understand their needs and requirements and develop insights and solutions that align with overall business goals
- Identify and communicate potential supply chain risks and opportunities based on demand forecasts
- Participate in meetings with stakeholders to discuss findings, answer questions, and make recommendations for process improvements.
- Ability to teach internal resources with no prior Anaplan knowledge how to interact with the Anaplan platform.
