DATA MODELER

E-Solutions
TORONTO
$40-$75 an hour (estimated)
Full-time

Data Modeler

Location : Toronto(Hybrid) day in Downtown

  • Data Model using Erwin
  • Normalization techniques, NF, Star and Snowflake schemas, Forward and Reverse Engineering

This person will be working on BLDM BAU work.

Need excellent skills in Oracle, dimensional model, as well as entity relational data model.

Be able to come up with efficient, performing, and optimum design.

Experienced in data warehouse, dimensional and entity relational model.

We would love someone who can play a designer / solution lead role.

Definitely need DBA type skills : data modeling using Power Designer, and DDL.

Generating the DDS (Detailed Design Specification) from the BSA inputs to hand off to ETL team.

Data Modeler Responsibilities

Be in charge of developing conceptual, logical, and physical data models and implementing RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL / NoSQL).

Manage the extension of existing data architecture and optimize data query performance through best practices. The applicant must be capable of working both alone and cooperatively.

Involve business users in determining their information requirements

Examine the business process and conceive the entities that interact inside it

Determine how the various entities are connected and create entity relationship diagrams to depict the links between the entities

Determine the qualities and properties of each entity and verify that the entities can be distinguished inside the model

Create a logical data model and validate it to ensure it meets the demands of the business application and its users

Convert the model's logical representation into a physical manifestation and collaborate with database administrators to instantiate and maintain the data

Work with the BI and Analytics teams to create an efficient, reusable semantic model that includes metadata and lineage information

Fine-tune the model to achieve consistent performance

Keep the metadata the "data about the data" that describes the data model, its structure, and semantics up to date

Recommend and implement design and maintenance standards, guidelines, and procedures

Data Modeler Requirements & Skills

A bachelor's degree in Management Information Systems, Computer Science, Computer Information Systems, or a related Information Technology area

Proficient in industry-standard data modelling methodologies

Excellent teamwork and communication abilities

Excellent consultative, facilitative, and consensus-building abilities

30+ days ago
Related jobs
Promoted
Apex Systems Inc
Toronto, Ontario

Apex Systems is a global IT services provider and our staffing practice has an opening for....

eTeam
Toronto, Ontario
Remote

Experience as a Data Modeler (or closely related occupation) building Business Process Model Notation (BPMN) models to depict end to end business process flows and Domain Modeling Notation (DMN) to design and execute decisions and complex business rules management. DE designing and developing data v...

Astra North Infoteck Inc.
Toronto, Ontario

Data Engineer (Modeler)Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. ...

Astra North Infoteck Inc.
Toronto, Ontario

Data Engineer (Modeler)Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. ...

Foilcon
Toronto, Ontario

Perform data profiling, assess data accuracy, design and document data quality and master data management rules. Design dimensional data mart models, create source-to-target-mapping documentation, design and document data transformation from curated model to data mart. BI Data Architect experience i...

BrokerLink Insurance
Toronto, Ontario

We are seeking a Senior Data Modeler/Data Engineer to join our Information Technology Department to play a crucial role in designing and implementing data models for a data warehouse/lakehouse that support our business requirements. Create and maintain comprehensive technical documentation for datab...

hays-gcj-v4-pd-online
Toronto, Ontario

Experience with Azure Solutions Strong Data Analysis skills Strong Data Modeling skills Expertise with Power Designer, Erwin Data Modeling tool Familiarity with Capital Markets data Able tomunicate clearly, both verbally and in written form Good work ethic, results oriented, and accuracy, attention ...

ShoreWise Consulting
Ontario, CA

Advanced knowledge of data modeling techniques with an understanding of data gathering, inspection, cleansing, and transformation. Advanced skill in using data modeling tools and approaches with an understanding of physical implementation issues, data strategies, design implications, and performance...

Astra North Infoteck Inc.
Toronto, Ontario

Data Engineer (Modeler)Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. ...

E-Solutions
Toronto, Ontario

Be in charge of developing conceptual, logical, and physical data models and implementing RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL). Keep the metadata – the "data about the data" that describes the data model, its structure, and semantics – up t...