Data Modeler
Richardson, TX
Job Description:
Required Qualifications:
•12 to 14 years’ experience on data modelling. Hands on experience on Data modelling tool – Erwin
•Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
•Designs dimensional data models for Highly scalable data warehouse.
•Interacts with OLTP systems and translated relational models into dimensional models.
•Maintains Data Model repository. Forward engineering/ Reverse Engineering
•Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.
•Executes and provides feedback for data modeling policies, procedure, processes and standards.
•Evaluates Database and data and develop the data model appropriately
•Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
•Knowledge of RDBMS platforms (e.g. SQL Server, Oracle, DB2 / UDB, NoSql, MongoDB, Hadoop) with experience in generating DDL
•Pharmacy Benefit Management experience preferred.
•12 to 14 years’ experience on data modelling. Hands on experience on Data modelling tool – Erwin
•Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
•Designs dimensional data models for Highly scalable data warehouse.
•Interacts with OLTP systems and translated relational models into dimensional models.
•Maintains Data Model repository. Forward engineering/ Reverse Engineering
•Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.
•Executes and provides feedback for data modeling policies, procedure, processes and standards.
•Evaluates Database and data and develop the data model appropriately
•Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
•Knowledge of RDBMS platforms (e.g. SQL Server, Oracle, DB2 / UDB, NoSql, MongoDB, Hadoop) with experience in generating DDL
•Pharmacy Benefit Management experience preferred.
Key Skills:
- data modelling,Erwin,OLTP ,Pharmacy Benefit Management