Requirements:

• Experience in the field of analytics
• Excellent knowledge of Excel (including VBA), SQL is a must
• Experience writing SQL queries and reporting

Responsibilities:

• Formation of databases based on sales results
• Analysis and comparison of data from distributors, pharmacy chains, pharmacy institutions
• Development of algorithms for verifying the bonus conditions of clients, writing advising SQL queries and forming the necessary data slice;
• Collection and structuring of data on purchases / sales / balances from customers;
• Daily entry of data on purchases / sales / balances / adjustments to the analytical database
• Automation of regular tasks;
• Fact Plan Calculation
• Conducting regular audits of data in customer reports;
• Keeping the database up to date;
• Update of pharmacy databases;