Beschreibung
For our client, an international FMCG company, we are looking for a Senior MS BI Architect
to review, develop and implement a Business Intelligence solution for their Branded Machine Business.
You will:
- Configure and optimise the BI environment, which includes relational and OLAP layers, and data migration components
- Work in a Datawarehouse environment, which includes data architecture and data modelling
- Define semantic layers and metadata repositories to support reporting and administration
- Define designs and build databases, using dimensional modelling methodology
- Develop Datawarehouse hardware and software platforms and integrating systems
- Troubleshoot BI Environment problems and tune for performance
- Diagnose and resolve application bottlenecks and performance issues
- Define and enforce coding standards, design styles and best practices
- Create DW schema design and ensure optimum database performance
- Identify and streamline routine processes in a fast-paced environment
- Gather and analyze business requirements to identify and understand source data systems
- Perform data analysis and translate business needs into long-term information architecture solutions
- Conduct data quality analysis to purge systems of old, unused, or duplicate data
- Collaborate with application developers and operation engineers to ensure proper handover and implementation
Candidates applying for this position must be able to demonstrate the following technical skills and experiences:
- Design and development of BI solutions based on the Microsoft SQL Server BI Suite
- Understanding of RDBMS concepts and experience in creating, maintaining and tuning Views, and Stored Procedures
- Reverse Engineering Data Models
- Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous
- Data modelling (Dimensional & Relational) and Database Architectue
- Designing Aggregations and pre-calculating the same in SSAS
- Processing Cubes, adding KPIs and Calculated Members USING SSAS
- Optimizing Cubes using SQL Server Analysis Services (SSAS) 2005 (Cube Partitioning)
- Multidimensional cubes
- Experience in conducting architecture reviews and aligning a technical solution towards best practices
This is a contract position with an international client for 7 months in the first instance. The client is located minutes from Lake Geneva, close to Lausanne. Info-Tech will provide advice and support through your relocation if you are working in Switzerland for the first time.