|Initial term from 1-1,5 months with ability to extend.
Solid experience in modeling of efficient large scale OLAP and Analytical Databases.
Essential MS SQL Server knowledge, required for OLAP modeling and implementation.
Background in Financial IT development is a big advantage.
Proven ability to deliver working and future-prone results time-boxed.
You’d be the main expert to model the efficient OLAP database formed of streamed data, which currently resides within an OLTP database with millions of records. The OLAP DB efficiency by the major part is determined by it’s use within the financial reports, ordered quite a few times a day, even after the streamed OLTP data has been corrected/re-calculated for a substantial historic period. Thus, you’d be the one to propose and prove the most optimal schema whether it’s a star, snowflake or a galaxy and design the data structures accordingly. OLTP data streaming and re-arranging of the already developed reports onto the OLAP DB will be performed by your project’s colleagues.