Integration Data Analytics Architect

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

JD for Offshore Data Modeler Role

• 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.
  

• 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
  
• Finetune 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 industrystandard data modelling methodologies
  
• Excellent teamwork and communication abilities
  
• Excellent consultative facilitative and consensusbuilding abilities