Position: Data Analyst
Category: SQL
English level: intermediate
Years of experience: 7


Creating export databases, tables and fields according to data requirements and types, creating data, clearing and normalizing input data, using a relational MySQL database to fill the repository with relevant data, which can be used for analytical work OLAP cube.
Communication with the customer: defining goals, wishes, forming requirements for the final product.
Close cooperation and coordination of 1C developers, and outsourcing OLAP Architect.
End-user communication: technical support, end-user training, data troubleshooting.
Working with the data warehouse: data analysis, creating queries to the database to find the causes of data inaccuracy.
Database administration: adding users, assigning rights, setting up service mailings, creating tasks for the database. Creation of manual and automatic backups for data storage and OLAP cubes, creation of tasks for automatic updating of database storage with current data.
Work with OLAP cubes: creation of sections, processing of OLAP cubes (full, updating, processing of separate sections).
Working with the BAT analytical program: administration, creation of users, user groups, reports, creation and management of access rights, connection of OLAP cubes, creation of automatic mailings.
Other skills: installing software to develop the OLAP cube on the server, installing the BAT program, deploying a web server and mail server for the BAT program, transferring software to the cloud server.