Microsoft BI Developer

SHORT PROJECT DESCRIPTION:

The BI2 application is a key strategic project providing Standard Reporting and Self Service BI capabilities to the business. Standard Reporting includes Client Reporting, Product Reporting and Performance Reporting. Self Service BI provides a framework and environment of tools and capabilities for business users to develop adhoc solutions according to demand from end users including regulatory and compliance departments. Microsoft BI tools are used extensively in the project with Oracle used as the primary database.

MySTT is a price calculation application which manages and controls STTs (Special Tariff Terms, or discretionary pricing discounts).

LMS, Lead Management system is a CRM extension which uses public data and predictable analysis methods to search and identify leads with high potential.

Flow of Funds, FoF is PB's BI and alerting system to monitor and control global fund streams. It uses extensively descriptive analysis methods.

KEY TASKS...

The business logic is complex and the developer must be familiar with working with large non-transactional data warehouses and managing complex multi-dimensional structures. Your Key tasks are primarily:

- Develop SSRS, MDX based reports using SQL Server Analysis Services (SSAS) as a data source
- Tune and Improve performance both load time and query time of SSRS reports
- On regular basis interact and collaborate with team members in Zurich and Wroclaw
- Provide day-2-day technical support to peers and third level production team
- Participate on regular stand ups and all other agile/scrum based processes where required

Michael Bailey International is acting as an Employment Business in relation to this vacancy.