Previous Job
Previous
Data Modeler
Ref No.: 18-53599
Location: Toronto, Ontario
Position Type:Contract
Start Date: 07/27/2018
 ·        5+ years of experience in creating standard abbreviation document for logical, physical and dimensional data models.
·        Create logical, physical and dimensional data models (data warehouse data modelling).
·        Document logical, physical and dimensional data models (data warehouse data modelling).
·        Generate reports from data model.
·        Knowledge on P&C in mandatory.
·        Perform data modeling analysis and de-normalization to resolve requirement conflicts and gaps between various data stores and business entities create entity relationship and multidimensional data models, reports and diagrams.
·        Define principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, slowly changing dimensions, foreign key concepts, referential integrity.
·        Create sql code from data model and coordinate with DBAs to create development, testing, regression and production database.
·        Check to see data models and databases are in sync.
·        Adding data base objects (like indexes, partitions in oracle database) for performance.
·        Review the data model with functional and technical team.
·        Interact with Business Analysts to get the functional requirements.
·        Interact with end users and find out the reporting needs.
·        Conduct interviews, brain storming discussions with project team to get additional requirements.
·        Gather accurate data by data analysis and functional analysis.
·        Determine the appropriate data flow model among primary and ancillary data stores
·        Define & document meta-data, data lineage and data dictionaries across the data stores
·        Design and document data flow diagrams, schema and data mapping/cross-walks across the data stores
·        Model business requirements into the physical data warehouse design either from existing data sources or from new data sources to be integrated.
·        Understand current-state data schema and data model and define future-state data schema