MS BI Architect, Basel, Switzerland

MS BI ARCHITECT

BASEL, SWITZERLAND

6MONTHS + CONTRACT

KEY SKILLS: MS-BI ARCHITECT, Data modelling, FINANCE DATA WAREHOUSING PROJECTS, BI TOOLS (ESPECIALLY MICROSOFT BI STACK AND BIRST)

JOB DESCRIPTION:

- Over all 10-15 YEARS of experience as MS-BI ARCHITECT
- Very good Data Warehouse design and programming experiences.
- Very good multi-dimensional design capabilities.
- Datamodelling experience for analytics (shared dimensions, time dependency of master data, ODS & aggregates, star schema, snow flake, ..)
- Very good knowledge of BI tools (especially Microsoft BI stack and BIRST)
- Data load processing design, orchestration experiences (especially with Microsoft SSIS and BIRST connect).
- Good Data Analytics and reporting capabilities.
- Knowledge of Sales & Marketing and Distribution business processes and data.
- Knowledge of supply chain business processes and data.
- Knowledge of supply chain business processes and data.
- Experience with SDFC as a data source.
- Experience with SAP ECC and SAP BW as a data source.
- Experience with BW Extractors on SAP BW (LO Cockpit).
- Experience collaborating with remote developers.
- Demonstrated end to end ownership for the technical solution of one domain.
- Theobald software Extract IS experience (with SSIS).
- Good analytical skills.)
- Good Knowledge in SSIS Packages
- Knowledge in SSAS/SSRS
- Creating Tables and Writing Stored Procedures and User defined functions in SQL server
- Strong Knowledge SAP Integrations, SAP BW and SAP R/3 Integrations with MS-BI.
- Functional proficiency in FINANCE DATA WAREHOUSING PROJECTS.
- Experience in OLTP, OLAP/Data Warehouse, Data Marts and dimensional modelling.
- Worked on creation of Entity Relationship diagrams and Data Models using Star and Snowflake Schema.
- Excellent COMMUNICATION, DOCUMENTATION, PRESENTATION AND INTERPERSONAL SKILLS.