slider1











Current Openings Go Back To Current Openings


Data Architect Modeler

Reference IDData Architect Modeler

Job description

Data Architect Modeler

Job Description:

  • Develop and support domain and semantic data models for databases.
  • Combines SOA principles including, decoupling, reuse, and agility with key information governance principles such as abstraction, shared semantic models and data standards.
  • Develops data models; evaluating logical data models including planning and execution tables; applying metadata and modeling standards, guidelines, conventions, and procedures; planning data classes and sub-classes, indexes, directories, repositories, messages, sharing, hiding, replication, back-up, retention, and recovery 
  • Developing and maintaining data dictionaries and repositories; integrating logical data models with enterprise data models; converting logical data models to physical data models; documenting model schema and system management 
  • Define technical requirements, design and maintain data architectures for the data repositories to support data warehouse, operational data stores, transactional systems, etc. 
  • Assist in the development of strategies for archive, data recovery, database implementation and data acquisition 
  • Maintains data model reliability by completing performance tuning; coordinating requirements and actions between database developers and administrators; monitoring application of standards, audit and reconciliation processes, and data integrity; modifying documentation 
  • Provide written status reports to management for project status, tasks, and issues / risks.
  • Provide third level operational support for development and production database systems.

 

Skills / Qualifications:

 

  • Knowledge of OLTP and OLAP Data Modeling Concepts
  • Experience in developing data models including relational, dimensional, and OO models 
  • Exhibit knowledge of the design, development and maintenance of data models and their components utilizing different tools
  • Experience in indexing, performance tuning and database optimization techniques 
  • Experience utilizing PL/SQL or the like
  • Experience with reporting tools (Preferred: Tableau, SAP BOE)
  • Experience with meta data management
  • Experience with data integration tools and concepts (Preferred: Pentaho Kettle, Oracle ODI or Informatica)
  • 5 years working experience in Oracle databases
  • Ability to analyze and determine impacts of migrating database schemas / instances.
  • Preferred: Oracle RAC 11g experience from the development perspective
  • Preferred: Experience with Agile methodology
  • Preferred: Experience with columnar databases such as Vertica
Apply for this job position

CAPTCHA