data modeler

Company: Smartedge IT Solutions
Job type: Contract
Industry: Information Technology

Role Overview

  • Analyses business requirements and source system data. Documents the analyses by creating of source system data models.
  • Follows the principles, standards and guidelines of reference data models, data models and information standards.
  • Creates physical data models that are managing information assets in all layers of Integrated Data Warehouse.
  • Experience with data modeling tools - mainly with SAP Power Designer.

We need a team player and a data modeler

  • able to work in synergy with a BA and challenge requirements, analyze the sources , create data models from scratch.
  • able to challenge and be challenged by other modelers within the team or outside of it about the design choices he made in order to improve the solution

Once the model is created and validated, he/she must be able to develop the solution transform the source system data so to fit the model he/she designed. Skills

  • Dimensional data models (Kimball) both logical and physical
  • Core data models (3rd normal form, Inmon) both logical and physical

Technologies:

  • Power designer is the modeling case tool
  • Teradata SQL experience (preferred) or Oracle SQL experience
  • Snowflake or Redshift exposure nice to have
  • SQL, Stored Procedures, BTEQ, TPTs

Dimensional Modeling Transactional Modeling Source data & Business analysis Logical Mapping Modeling of standard reporting dataset views SQL/ETL developer Basic testing

Apply for this job