IN_Senior Associate_Business Analyst\SAP Analytics_Advisory_Hyderabad (India)

<table border="0" cellpadding="0" cellspacing="0" width="901" style="width:677pt;"> <colgroup><col width="234" style="width:176pt;" /> <col width="667" style="width:501pt;" /> </colgroup><tbody><tr style="height:140pt;"> <td height="187" class="xl70" width="234" style="height:140pt;width:176pt;">Job Description & Summary: </td> <td class="xl69" width="667" style="border-left:none;width:501pt;">Results-oriented Business Analyst with expertise in gathering, analyzing, and translating business requirements into scalable data and analytics solutions. Skilled in working with cross-functional stakeholders to bridge the gap between business objectives and technology teams, enabling data-driven decision-making and digital transformation initiatives. Experienced in SAP data ecosystems, data integration, reporting, process optimization, and analytics platforms, with a strong understanding of modern data architectures and cloud-based technologies. Adept at conducting requirement workshops, process mapping, gap analysis, user story creation, and solution validation to ensure successful project delivery. Proven ability to collaborate with business users, solution architects, data engineers, and leadership teams to drive enterprise-wide transformation programs and deliver measurable business value across diverse industries.</td> </tr> <tr style="height:43.5pt;"> <td height="58" class="xl71" style="height:43.5pt;">Job Position Title:</td> <td class="xl66" width="667" style="border-left:none;width:501pt;">IN_Senior Associate_Business Analyst\SAP Analytics_Advisory_Hyderabad (India)</td> </tr> <tr style="height:409.6pt;"> <td height="547" class="xl71" style="height:409.6pt;border-top:none;">Responsibilities:</td> <td class="xl67" width="667" style="border-top:none;border-left:none;width:501pt;">Secondary Sales Analytics & Reporting<br /> • Analyze secondary sales data (sell-out/sell-through) across channels, regions, SKUs, distributors, and retail outlets to derive actionable insights.<br /> • Design and manage daily, weekly, and monthly secondary sales dashboards and MIS reports for leadership and field teams.<br /> • Track and report on key KPIs including numeric & weighted distribution, strike rate, lines per call (LPC), productivity per beat, ECO (Effective Coverage Outlet), and per-outlet billing.<br /> • Perform sales trend analysis, seasonality assessment, and demand pattern recognition at granular levels.<br /> <br /> Distribution & Channel Management<br /> • Partner with sales and distribution teams to monitor distributor ROI, claim settlements, inventory norms, and stock redistribution.<br /> • Analyze and optimize Route-to-Market (RTM) strategies and recommend improvements for beat plans, journey plans, and outlet coverage.<br /> • Evaluate channel-wise (GT, MT, e-Commerce, institutional) secondary sales performance and identify growth levers.<br /> • Support the implementation and tracking of DMS (Distributor Management Systems) and SFA (Sales Force Automation) tools.<br /> <br /> Sales Performance & Target Management<br /> • Assist in sales target setting and cascading (region → ASM → TSI/PSR level) using historical<br /> sell-out data and market intelligence.<br /> • Track and analyze target vs. achievement (TGT vs. ACH) at all levels and highlight<br /> performance gaps and corrective actions.<br /> • Build scorecards and incentive tracking models for the field sales force.<br /> <br /> Trade Promotion & Scheme Effectiveness<br /> • Evaluate the effectiveness of trade promotions, schemes, and BTL activities on<br /> secondary sales uplift.<br /> • Conduct pre- and post-promotion analysis to assess ROI and provide recommendations<br /> for future schemes.<br /> • Analyze price elasticity and competitive pricing impact on secondary sales performance.<br /> <br /> Business Intelligence & Process Improvement<br /> • Develop automated reports, data models, and visualization dashboards using BI tools<br /> (Power BI, Tableau, QlikView, or similar).<br /> • Work with IT and data engineering teams to ensure data integrity, standardization, and<br /> integration across DMS, ERP (SAP/Oracle), and CRM systems.<br /> • Identify process gaps and recommend automation and digitization opportunities within<br /> the secondary sales ecosystem.<br /> • Collaborate with cross-functional teams (Supply Chain, Marketing, Trade Marketing,<br /> Finance) to align S&OP and demand planning with secondary sales trends.<br /> <br /> Stakeholder Management & Strategic Support<br /> • Partner with Regional Sales Managers, Zonal Heads, and National Sales Head to provide<br /> strategic sales intelligence.<br /> • Present insights and recommendations to senior leadership through compelling<br /> storytelling and data visualization.<br /> • Support the annual business planning (ABP) process with secondary sales forecasts and<br /> scenario planning.</td> </tr> <tr style="height:113.5pt;"> <td height="151" class="xl71" style="height:113.5pt;border-top:none;">Mandatory skill sets:</td> <td class="xl67" width="667" style="border-top:none;border-left:none;width:501pt;">• 4+ years of progressive experience as a Business Analyst, Sales Analyst, or<br /> Commercial Analyst in the FMCG / CPG / Retail industry.<br /> • Deep understanding of secondary sales processes, distributor management, general<br /> trade (GT), modern trade (MT), and retail execution.<br /> • Proficiency in Advanced Excel, SQL, Power BI/Tableau, and familiarity with DMS<br /> platforms (Bizom, Botree, Infosys TradeEdge, FieldAssist, etc.). Working knowledge<br /> of SAP/Oracle ERP is a plus.<br /> • Strong capabilities in data mining, statistical analysis, forecasting models, and<br /> deriving business insights from large datasets.</td> </tr> <tr style="height:63.5pt;"> <td height="85" class="xl71" style="height:63.5pt;border-top:none;">Preferred skill sets:</td> <td class="xl67" width="667" style="border-top:none;border-left:none;width:501pt;">• Data Analysis<br /> • API Understanding<br /> • Basic SQL Query Writing<br /> • Power BI Reporting<br /> • Data Modeling Concepts</td> </tr> <tr style="height:15.5pt;"> <td height="21" class="xl71" style="height:15.5pt;border-top:none;">Years of experience required:</td> <td class="xl68" style="border-top:none;border-left:none;">4 to 7 Years</td> </tr> <tr style="height:15.5pt;"> <td height="21" class="xl71" style="height:15.5pt;border-top:none;">Education qualification:</td> <td class="xl68" style="border-top:none;border-left:none;">BE/B.Tech/MBA/MCA/M.Tech</td> </tr></tbody></table>