Optimacros Developer

Moscow Brewing Company Mytishchi, Moscow

Tasks:

• development, administration, and support of models on the Optimacros platform.
• setting up integrations with external systems: Navision, 1C; creating receivers from MS Excel, MS SQL Server databases, and other external transactional systems.
• participation in projects for building and developing BI systems and data warehouses on the Microsoft platform (SQL Server 2012 R2 and above): design, modification, and support of data warehouses on MS SQL Server databases, Integration Services ETL packages, Analysis Services OLAP cubes, Reporting Services reports;
• MS SQL database administration
• performance optimization;
• technical support;
• writing technical documentation.

Requirements

• Experience with Optimacros development is mandatory!
• Experience with Optimacros (model development, script writing), MS SQL Server 2012/2008, knowledge of T-SQL;
• Skills in integrating Optimacros with third-party systems;
• Understanding of the principles of building normalized and multidimensional data warehouses;
• Experience in designing and developing databases;
• Experience in designing and developing data warehouses, skills in working with Microsoft Analysis Services, Integration Services, Reporting Services;
• Result-oriented, responsible.

Conditions:

• The office is located in Mytishchi, near the stations of Metro Medkovo, as well as the railway station Mytishchi (Yaroslavsky direction). A corporate bus runs from Medkovo metro station and Mytishchi railway station.
• Remote work format is possible.
• Corporate fitness center, VHI (Voluntary Medical Insurance).