Responsibilities:

• Generation of databases based on sales results
• Analyzing and collating data from distributors, pharmacy chains, pharmacy facilities
• Development of algorithms to verify customer bonus terms, writing advisory SQL queries and generating the required data slice;
• Collecting and structuring purchasing/sales/residuals data from customers;
• Daily entry of purchasing/sales/stocks/adjustments data into analytical database
• Automating regular tasks;
• Calculation of fact plan.
• Conducting regular audits of data in customer reports;
• Keeping the database up to date;
• Updating pharmacy databases;

Requirements:

• Experience in analytics.
• Excellent Excel skills (including VBA), SQL software required.
• Experience in writing SQL queries, experience in report development