Persha Privatna Brovarnya
Join the leadership team! Persha Privatna Brovarnya, a modern Ukrainian company that implements innovations and constantly grows, is looking for a Analyst of the sales department database support to join its team. Join a team of professionals who value quality and development!Main tasks:Writing SQL queries to databases for the formation of analytical data and further construction of reportingManagement of information collection processes for databasesSupport of OLAP-cube databases, work with the
Join the leadership team! Persha Privatna Brovarnya, a modern Ukrainian company that implements innovations and constantly grows, is looking for a Analyst of the sales department database support to join its team.
Join a team of professionals who value quality and development!
Main tasks:
- Writing SQL queries to databases for the formation of analytical data and further construction of reporting
- Management of information collection processes for databases
- Support of OLAP-cube databases, work with the platform Effie
- Formation of regular reporting (Sales channels, SQU, risks of execution of sales plans, balances, etc.).
- Reporting of the distribution channel: execution of tactical tasks, sales analysis, average number of SQU, average order value, etc.
- Participation in strategic and operational sales planning
- Digitization of goals and monitoring of budgets
- Collection and consolidation of information on the warehouse in terms of SKY
- Report of the sales team for each month in PowerPoint format (presentation)
- Analysis of equipment efficiency, generation of reports
- Regular reports based on created analytics
- Formation and analysis of operational reports
- Providing maximum analytical and informational support in the sales department
- Ad hoc management tasks
From you we expect:
- Higher education (economic, technical)
- Experience working as a sales analyst in a system company
- Understanding the work processes of retail enterprises, in particular FMCG
- Sufficient PC user, Microsoft Excel (functions, Power Pivot, Power Query)
- li>Experience with Power BI (preferred)
- Experience with OLAP cubes
- Proficient knowledge of 1C
- English language - preferred
- Personal qualities: sociability, analytical abilities, high self-organization, attention to details
We offer:
- Interesting work with high-quality, Ukrainian product
- 8-hour working day with certain flexibility, hybrid or remote working mode
- Annual paid vacation (24 days)
- Opportunity for training and development in the company< /li>
- Paid mobile communication and work equipment for the convenience of remote work
We are waiting for your resume!