Role Profile
We are looking to bring on board a Commercial Analyst responsible for leading market research & analysis; business performance analysis and driving profitability as well as identifying key customer trends that can be monetized to drive value for the organization in terms of revenue generation.
He or she will support the negotiation of joint business plans, lead market research, generate reports that add valuable insights to the business performance and direction; sales analysis & data compilation and driving a data-driven approach to decision-making within the business.
Key Responsibilities:
Business Analytics: Automate data analysis and reporting to ensure there is timely delivery of sales reports and other key reports needed for decision-making. Mine and analyse data from the organization’s databases to drive optimization and improvement of product development, marketing techniques and business strategies. Work with the technical team to develop the capability to produce relevant Ad Hoc reports that meet the commercial team & business requirements.
Data Value Maximization: Review product margins to ensure SKU’s that are selling below the recommended margin average per category and recommend improvement plans. Perform regular data analysis to uncover revenue opportunities and identify income leakages. Develop predictive modelling to increase and optimize customer experiences, foretell and avert attrition, increase revenue generation and guide marketing campaigns.
Market Intelligence: Lead market research and development-focused reports that highlight the various retail value chains products and category performance for the business and related parties. Identify leading customer data trends that can be capitalized on to generate value for the business capturing both balance sheet growth and revenue generation
Business Advisory: Review all joint business plans (JBP) signed off by the organization and its suppliers to advise the establishment of realistic achievable growth targets and including extra revenue from trade discounts and rebates from various elements. Deliver reports that enable managers to gain a deep understanding of the business and unit performance to drive growth and profitability. Use data analytics to assess processes, determine requirements and deliver data-driven recommendations and reports to relevant stakeholders.
Reporting: Generate business analytical reports that provide insights on business performance and deliver a roadmap towards profitability. Lead sales data compilation, evaluation and analysis including creating statistical reports, building and maintaining files aimed at increasing the business’ sales. Develop weekly performance reports indicating comparison of buying and selling trading reports; Purchases vs operational & sales reports for the commercial and operations teams; Margin analysis to indicate items going on negative margin; Monthly sales vs stock turnover ratio report.
Business Performance Management: Champion monthly category performance review and SKU-wise performance to advise on rationalization for non-performing SKUs within the business. Work collaboratively with the FP&A Accountant and the Sales Manager to develop and review the sales budget and rolling sales forecast including sales-to-budget variance analysis. Monitor Monthly/Weekly/Daily Average Actual Sales Turnover against Target.
Stakeholder Alignment: Support the development and implementation of the growth strategy per business unit by working on product merchandising and assortment to ensure properly stocked products according to sales movement and check on opportunities missed by not allocating the right assortments. Monitor and report overall negative inventory to the concerned and perform a root cause analysis.
Benchmarking: Research the wider macroeconomic models relevant to the sector and market best practices relevant to our business model and operation. Lead external market performance review vs the general trade performance & growth in alignment with the business’ growth performance.
Minimum Requirements & Key Skills:
A minimum of six (6) years of working experience as a Commercial Analyst/Commercial Data Analyst; Business Analyst or Data Analyst;
BS in Mathematics, Economics, Computer Science, Information Management or Statistics;
A professional qualification in a related field is an added advantage;
Technical understanding of data models, database design development, data mining and segmentation techniques;
Strong knowledge of and experience working with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks);
Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc). Experience working with advanced analytics tools including advanced Excel, VBA, SQL, Python, Power BI, R and other data analysis tools;
Demonstrated analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy;
Adept at queries, report writing and presenting findings;
Solid knowledge of the business operations and finance around commercial activities;
Experience in economic impact assessment modelling is preferred;
Demonstrable skills in data analysis and data interpretation.
Competencies & Skills
Analytical Thinking;
Commercial Acumen;
Attention to Detail;
Stakeholder Management;
Problem-Solving Skills;
Tech Savvy.
Apply via :
kyosk.hire.trakstar.com
