Data Warehouse Data Modeller (Dimensional Modelling)
A highly experienced Data Modeller with strong experience in data profiling, Data Quality Analysis, Dimensional Modelling and Data Warehouse concepts & architecture. Candidate must have experience in Erwin modelling tool to develop and maintain logical and physical data models. Candidate should be disciplined, detail-oriented, self-motivated, and delivery-focused.
7 to 10 years of strong experience in data profiling, Data Quality analysis and Dimensional modelling.
Experience in profiling from single column, to single table, to cross-table structural profiling and cross columns analysis.
Experience in using Erwin modelling tool to develop and maintain data models.
Experience in creating efficient data models for SQL Server 2016.
Experience in working with Source SMEs, DW Architect, Technical Leads and ETL developers to facilitate the overall data warehouse build and ETL development.
Analyse data-related system integration challenges and propose appropriate solutions.
Ability to understand data requirements and able to create data model to support self-service BI.
Expert knowledge in RDBMS concepts and SQL.
Experience in ETL tools like ODI, Pentaho or BODS.
Work experience in ETL development and design.
Strong in data warehouse architecture, methods, concepts, techniques, dimensional modelling to support building enterprise data warehouse and dimensional models.
Experience in assessing the risks and challenges involved in integrating multiple data sources.
Experience in defining data governance processes to improve the quality of the data.
Experience in writing source to target mapping sheet.
Strong Communication skills
Must have experience with On Site and Off Shore Development model.
Skills Desired but not mandatory: