MS BI Architect

Job type:
12 months
flag_no Switzerland
project ID:

This project is archived and not active any more.
You will find vacant projects in our project database.
Reference Nr: 915194NC

Industry: Banking

Location: Zurich und Region

Start Date: ASAP

Duration: 12 Months

Introduction: Since its founding in 1997 ITech Consult AG has expanded its network of freelance IT continuously. Today we have access to over 30,000 reported IT specialists (developers, system specialists, project managers, supporters, etc. ). So we are able to present computer science professionals with the required profiles in a short term.


As the BI Platform Architect you will be responsible for designing and delivering quality solutions to support the growth and stability of a rapidly evolving, global BI platform.

-Defining the physical BI architecture to support scalability, DR and high availability.
-Planning and supporting technical upgrades (SQL Server 2014).
-Conducting proof of concepts and performance tests.
-Leading white-boarding sessions, workshops, design sessions, and project meetings as needed.
-Lead analysis, architecture, design and development of data marts and business intelligence solutions.
-Work independently or as part of a team to design and develop solutions using SSIS, SSRS, SSAS.
-Design and develop Integration (ETL, ELT) processes using MS SQL Server 2014 SSIS, DQS, MDM or other related tools/technologies.
-Collaborate across teams to standardize BI implementation(s).


-5-20+ years of experience, specializing in BI solution architecture, design, and development.
-Programming experience, developing tailored BI solutions using BIDs and C#.
-Technical Specialization in: SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, SQL Server and other related technologies.
-Familiarity with database centric applications and VLDB/data warehouse solutions.
-Experience with Agile solution delivery.
-Data Warehousing and Data Modeling, specifically building / understanding star schema based data marts.
-Architecture: defining non-functional requirements and ensure they are achieved.
-Strong aptitude for learning new technologies and analytics techniques.
-Excellent written and verbal communication skills.
-Highly self-motivated and able to work independently as well as in a team environment


-Microsoft BI (Business Intelligence) certification a plus
-German language is a plus
-Banking/Financial Services domain knowledge