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
Senior Data Modeler
On behalf of our insurance client, Procom is seeking a....
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...
data modeler
Computer and technology knowledge.Advanced Business Application Programming (ABAP).Langue de travail: Anglais ou Français.Heures de travail: 35 hours per week....
BSA/Data modeler
Experience with data hub, operational data store (ODS), data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required. Responsible for hands on creation of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (OD...
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...
Senior Data Engineer, Data Modeler
Incorporate core data management competencies including data governance, data security and data quality. Travelers Data Engineering team constructs pipelines that contextualize and provide easy access to data by the entire enterprise. In addition to your strong analytical mind, you will bring your i...
Senior SQL Data Modeler with SAP HANA
Analyzing source or target system data requirements and mapping the data to match the enterprise data platform design. Identifying outlying data patterns and data cleanliness issues for resolution. Experience with data systems analysis and data warehouse design. Analyzes and conceptualizes the desig...
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 ...
Senior SQL Data Modeler with SAP HANA
Analyzing source or target system data requirements and mapping the data to match the enterprise data platform design. Identifying outlying data patterns and data cleanliness issues for resolution. Experience with data systems analysis and data warehouse design. Analyzes and conceptualizes the desig...
Senior SQL Data Modeler with SAP HANA
Analyzing source or target system data requirements and mapping the data to match the enterprise data platform design. Identifying outlying data patterns and data cleanliness issues for resolution. Experience with data systems analysis and data warehouse design. Analyzes and conceptualizes the desig...