Data Warehouse / Business Intelligence Analyst Programmer

Employment Type:Permanent
Job Location:Zug Switzerland
Job Function:

  • Working closely with Local and Regional team members to deliver Global Reporting solutions to enable the Group to meet its Strategic Goals in challenging and volatile markets.
  • Maintaining and extending the Global Data Warehouse (DWH) Business Intelligence (BI) solution
  • Integration of Data Marts and Cubes to deliver standard and bespoke Financial, Customer Services and Operational reporting capabilities  
  • Developing and improving the Global Data Warehouse Database, extending Multidimensional Cube solutions to meet the ongoing need to meet the Group’s  Support of both the finance and operation analysts teams

 

Job requirements:

 
At least 3 years’ hands-on experience in a DWH/BI Project as designer/architect and developer
Understand DWH/BI methodologies (data modelling, cleansing and transformation
Used to work with mainly functional & business requirements as well as technical requests.
Significant experience in Microsoft SQL Server 2012 (development, optimization)
Design, develop and optimize ETL processes in MS SQL with TSQL and Integration Services (SSIS)
SQL Server Analysis Services (SSAS) / Cube design and optimization
Experience in MultiDimensional eXpressions (MDX), Server Reporting Services (SSRS), Power Pivot, Excel, SharePoint
Experience with MS Dynamics AX 2012 R3