Business Data Analyst

Main Responsibilities Sales Performance Analysis Analyze sales by product, sales representative, territory/region, and customer segment. Identify trends, opportunities, and performance gaps. Track achievement against sales targets and budgets. Dashboard & Reporting Create and maintain dashboards for management. Prepare daily sales reports, weekly performance reviews, monthly business reviews, and forecast reports. Ensure data accuracy and consistency. Forecasting & Planning Support sales forecasting. Analyze historical sales trends. Predict future demand and revenue. Help management set realistic targets. Customer Analysis Analyze customer purchasing behavior. Identify high-value customers, customers at risk of leaving, and growth opportunities within accounts. Support customer segmentation strategies. Pricing & Profitability Analysis Analyze gross margins, product profitability, discount impact, and customer profitability. Recommend actions to improve profitability. CRM & Data Quality Management Monitor CRM data quality. Ensure opportunities, customer records, and sales activities are correctly recorded. Identify missing or inaccurate data. Business Intelligence Support Build reports using Microsoft Power BI, Tableau, Microsoft Excel, and SQL Server. Automate reporting processes where possible. Key KPIs for a Sales Data Analyst Report Accuracy % Dashboard Adoption Rate Forecast Accuracy % Data Quality Score Time Required to Generate Reports Number of Actionable Insights Implemented Revenue Opportunities Identified Margin Improvement Recommendations Requirements Qualifications – Sales Data Analyst Bachelor’s degree in Business Administration, Economics, Finance, Statistics, Data Analytics, Computer Science, or a related field. 5-7 years of experience in Sales Analysis, Business Intelligence, Data Analysis, Commercial Analytics, or a related role. Strong experience in sales performance analysis, forecasting, reporting, and business analytics. Advanced proficiency in Microsoft Excel, including Pivot Tables, Power Query, formulas, and data analysis. Hands-on experience with Microsoft Power BI and dashboard development. Good knowledge of SQL Server and the ability to extract, manipulate, and analyze data from databases. Knowledge of Tableau is an advantage. Strong understanding of sales KPIs, revenue, margins, targets, forecasting, and profitability analysis. Experience working with CRM systems and maintaining data accuracy and quality. Strong analytical and problem-solving skills with the ability to translate data into actionable business insights. Excellent attention to detail and ability to identify data discrepancies and performance gaps. Strong communication and presentation skills, with the ability to present complex data in a clear and management-friendly manner. Ability to work with large datasets and manage multiple reporting requirements within deadlines. Experience in the medical devices, pharmaceutical, FMCG, or distribution sectors is a plus. Show more