Senior MS BI Architect

Vaud  ‐ Vor Ort
Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.

Schlagworte

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.

Start
01/03/2013
Dauer
7 months +
(Verlängerung möglich)
Von
INFO-TECH
Eingestellt
31.01.2013
Projekt-ID:
481798
Vertragsart
Freiberuflich
Um sich auf dieses Projekt zu bewerben müssen Sie sich einloggen.
Registrieren