Greenpoint Business Consultancy
Summary The Business Intelligence and Sales Analyst transforms sales, customer, product, pricing, distribution, and market data into actionable business insights. This position owns recurring performance reporting and ad hoc analysis for the National Accounts organization, identifies trends, opportunities, and risks, and develops executive-ready and customer-facing presentations. The role combines quantitative analysis with business storytelling to support sales growth, distribution expansion, pricing decisions, promotional effectiveness, category performance, and account strategy. Essential Duties and Responsibilities Analyze sales performance by customer, product, market, geography, time period, and other relevant dimensions. Prepare and maintain recurring reports and dashboards covering sales, distribution, velocity, productivity, pricing, inventory, market share, and other key performance indicators. Standardize, validate, import, and export customer and internal data for use in Cognos and other reporting platforms. Use IRI/Circana and Nielsen syndicated data to analyze category performance, market share, distribution, velocity, pricing, promotional activity, competitive performance, and market trends. Gather, analyze, and compare competitor assortment, pricing, promotional activity, and market information; maintain the market intelligence database. Identify trends, performance drivers, gaps, opportunities, and risks, and translate findings into clear business implications and recommended actions. Conduct post-promotional performance analysis, including sales lift, efficiency, trade-spending effectiveness, and execution learnings. Create executive-ready and customer-facing presentations that communicate complex information through concise, visually compelling business stories. Support customer reviews, annual planning, line reviews, category reviews, and strategic sales initiatives with fact-based analysis and recommendations. Partner with Sales Managers and cross-functional teams to clarify analytical questions, define appropriate measures, validate conclusions, and recommend next steps. Develop and maintain standardized KPI definitions, reporting methodologies, and quality-control procedures to ensure consistent and reliable analysis across customers and reporting periods. Validate data, reconcile conflicting sources, identify anomalies, and resolve reporting discrepancies before information is distributed. Improve reporting processes, dashboards, templates, data definitions, and quality controls to increase consistency, accuracy, and efficiency. Serve as the trained backup for essential AFS entry, promotional calendar maintenance, and recurring promotion-support tasks under the department’s cross-training plan. Perform other related duties as assigned. Qualifications The successful candidate must be self-motivated, organized, highly productive, and able to work effectively with a diverse team in a fast-paced environment. Independent judgment is required to plan, prioritize, and organize a varied workload, recommend process improvements, and manage multiple assignments and deadlines. Advanced Excel Skills Advanced proficiency with pivot tables, XLOOKUP/VLOOKUP, nested formulas, SUMIFS, data validation, charts, and large-data-set reconciliation. Ability to combine, clean, validate, and analyze multiple data sources accurately and efficiently. IRI/Circana and Nielsen Expertise Demonstrated expertise using IRI/Circana and Nielsen syndicated data to analyze sales performance, market share, distribution, velocity, pricing, promotional activity, competitive performance, and category trends. Ability to extract, validate, and interpret syndicated data; identify growth opportunities and performance gaps; and translate findings into actionable recommendations. Ability to use syndicated data effectively in internal leadership presentations, customer reviews, category reviews, and strategic account planning. Advanced PowerPoint and Business Storytelling Ability to independently build executive-ready and customer-facing presentations. Ability to translate complex data into clear, concise, and visually compelling business stories. Ability to communicate key findings, business implications, and recommended actions to technical and non-technical audiences. Business Intelligence and Analytical Skills Ability to identify trends, performance drivers, gaps, opportunities, and risks across sales, distribution, pricing, category, and promotional data. Ability to develop actionable recommendations rather than only reporting results. Experience with Cognos, VIP, retailer portals, customer reporting platforms, or comparable business-intelligence systems is preferred. Retail and CPG Analytics Knowledge Strong understanding of retail and consumer packaged goods performance measures, including dollar and unit sales, market share, distribution, ACV, velocity, pricing, promotional lift, assortment, and year-over-year trends. Ability to understand retailer and category performance and identify opportunities to increase sales, distribution, productivity, and market share. Data Visualization and Reporting Tools Experience developing dashboards and reports using Power BI, Tableau, or comparable business-intelligence tools is preferred. Ability to select the appropriate data visualization and present findings clearly to non-technical audiences. Data Accuracy and Quality Control Demonstrated ability to validate data, reconcile conflicting sources, identify anomalies, document metric definitions, and maintain consistent reporting standards. Strong attention to detail and commitment to distributing accurate and reliable information. Critical Thinking and Problem-Solving Ability to anticipate issues, challenge assumptions using data, and apply sound business judgment to ambiguous questions. Ability to clearly distinguish facts, assumptions, conclusions, and recommendations. Ability to investigate discrepancies, identify root causes, and recommend practical solutions. Benefits Additional leave Company Christmas gift Company events Health insurance Life insurance Opportunities for promotion Pay raise Promotion to permanent employee Work from home Application Question(s): Years of experience as Business Intelligence Analyst: Years of experience using IRI/Circana and Nielsen syndicated data platform? Years of experience in sales: Are you willing to work remotely and nightshift? Are you willing to attend midnight virtual interviews? Current/Previous salary: Asking salary: Reason for looking another opportunity: Notice period: Birthdate (for validation): Active email: Active viber/mobile number: Do you acknowledge and consent to ACCPRO International’s collection, use, storage, and processing of your personal data from your application and other lawful sources for recruitment purposes (including screening, verification, and endorsement to prospective employer clients), with the understanding that your data will be shared only for legitimate recruitment, retained as required by law, protected through appropriate safeguards, and processed in accordance with the Data Privacy Act of 2012 (Republic Act No. 10173), including your rights as a data subject to access, correct, object to, or withdraw consent where applicable? Work Location: Remote
Greenpoint Business Consultancy
