Data Modeler

Description

Description The Senior Data Modeler is primarily responsible for defining business data requirements and translating those data requirements into logical and physical database models. The design of the database models will include operational databases, analytical data warehouses, and specific data marts designed to support batch, operational, and analytical processing and ad hoc business reporting.Essential duties and responsibilities Gather and document business requirements, translate business requirements to technical specifications, project estimating support and identifying cost implications. Create, document, and maintain logical and physical database models. Mentor application development team and assist developers with complex query development and performance optimization. Proactive monitoring of system performance and diagnostics. Assist with production support and maintenance.Required Skills Must have excellent communication skillsQualifications (knowledge, experience, skills and abilities required Minimum three five (35) years data modeling experience. Minimum three five (35) years Relational database (Sybase or Oracle) experience (SQL scripts, stored procedures, triggers, etc.). Three to five years experience with UNIX/AIX preferred. Data modeling, Oracle database, and UNIX/AIX experience can be concurrent. One to three years Database Administration experience including tuning/optimization and monitoring (preferred). Health care insurance systems experience (preferred; especially member, provider, claims, and accounting subject areas). Understanding of Business Intelligence architectures. Experience working with business and IT teams.