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).
