Data Modeler

Position summary:

The Data Modeler is responsible for creating and maintaining product data models, providing expertise and leadership with respect to requirements, gathering, analyzing, executing and providing best practice recommendations throughout various project lifecycles. The Data Modeler is responsible for Logical and Physical Modeling in Erwin for a highly scalable data warehouse and VLDB OLTP system, and must understand the dimensional/relational modeling techniques and bridge the gap between the OLTP developers, data warehouse developers ETL and DBA teams.

Position description:

  • Translates functional product requirements into technical designs
  • Configures and tests objects
  • Identifies and resolves issues related to configuration and testing
  • Delivers product releases on-time and with quality
  • Creates weekly detailed status reports
  • Tracks and reports on project metrics
  • Creates and delivers training to the end users of product
  • Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
  • Analyze source system data using profiling tools
  • Designs dimensional data models for highly scalable data warehouse
  • Refines current data models to improve efficiency
  • Interacts with OLTP systems and translated relational models into dimensional models
  • Maintains Data Model repository
  • 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
  • Design data models in Data Modeling tools (ERWIN preferred)
  • Knowledge of RDBMS platforms (e.g.  Oracle ) with experience in generating DDL

Qualifications / requirements:

  • BS degree and 7+ years’ of experience or equivalent combination of related experience
  • Experience data modeling for Exadata a plus
  • Proficiency in Oracle SQL and Oracle VLDB/Partitioning
  • PL/SQL
  • Proficiency in database concepts and systems types including OLTP, Data Mart
  • Experience with ODI a plus
  • Experience with healthcare data a plus
  • Able to work well with various teams
  • Great English verbal and written communication required for telecommuting roles
  • Ability to establish and maintain professional working relationships with all levels of staff, clients and the public
  • Detail orientated with the ability to work with minimum/no supervision
  • Experience with unit testing, release procedures, coding design and documentation protocol
  • Knowledge of IT fields and computer systems
  • Understanding of the systems development life cycle
  • Ability to manage tasks independently
  • Knowledge of basic Agile terminology and practices such as User Stories, Backlog, Scrum, and Acceptance Criteria
  • Experience with an Agile Tool, specifically JIRA is a plus

Apply Now

Diversity creates a healthier atmosphere: Sentry Data Systems, Inc. is an Equal Employment Opportunity and Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.