Data Modeler at ChaTeck Inc

Job Purpose: Supports data warehouse performance by designing, developing, and validating data models; Duties: * Enhances data modeling team accomplishments and competence by planning delivery of solutions; answering technical and procedural questions for less experienced team members; teaching improved processes; * Determines data availability by interviewing users; defining, analyzing, and validating data objects; identifying the relationship among data objects. * Develops data models by studying existing data warehouse architecture; evaluating alternative 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. * Validates data models by defining quality requirements; designing and completing verification tests. * Implements data models by designing procedures for moving data from operational tables to data warehouse, for replicating data between databases, and for updating operational tables; 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. * 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. * Improves data model by evaluating results; implementing enhancements. * Updates job knowledge by tracking data modeling developments; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations. * Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments. Skills/Qualifications: Problem Solving, Database Management, Operating Systems, Thoroughness, Requirements Analysis, Software Development Fundamentals, Initiative, Promoting Process Improvement, Data Modeling, Data Warehousing, General Programming Skills