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
SQL Data Modeler
Data Engineer (Modeler)Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. ...
Data Modeler
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...
Data Architect Modeler 5782
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...
Data Modeler @ Toronto, ON - Long Term
Data Engineer (Modeler)Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL</p> <p>Competencies: Data Concepts & Data Modelling</p> <p>Essential Skills: a. Data Engineer (Modeler)Database Design, Oracle...
Data Modeler
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...
Intermediate Data Modeler- Capital Markets - data architecture strategy, data modeling, and the overall data practice with a OLTP environment - 80460-1
Job Description: Seasoned professional responsible for providing operational leadership, governance and stewardship for the data architecture strategy, data modeling, and the overall data practice, in addition to all related principles, policies, and procedures around data management. Position Title...
Data Modeler
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...
Senior Data Modeler/data Engineer
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...
SQL Data Modeler
Data Engineer (Modeler)Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. Database Design, Oracle Exadata, complex SQL and PL/SQL, DDL. ...
Data Modeler
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 ...