Data Modeler (Sr) @ Detroit, MI

Title:                Data Modeler (Sr) 

Location:                     Detroit, MI

Duration:         6+ Months

Start:               Immediate

 

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.

 

Must have excellent communication skills

 

QUALIFICATIONS (KNOWLEDGE, EXPERIENCE, SKILLS AND ABILITIES REQUIRED:

• Minimum three - five (3-5) years data modeling experience.
• Minimum three - five (3-5) 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).Health care insurance systems experience (preferred; especially member, provider, claims, and accounting subject areas).
• Understanding of Business Intelligence architectures.
• Experience in clarifying requirements and participating in analysis sessions with the user community.
• Strong knowledge of relational and multi-dimensional database architectures.

• Data analysis/profiling and reverse engineering of data.
• Ability to work with other team members to design and maintain a corporate data architecture that will allow the data warehouse to evolve with the business.
• Define and maintain corporate metadata definitions for all reporting databases (data stores and data marts) within a metadata repository.
• Define and maintain data dictionary.
• Develop, integrate, manage and promote enterprise level logical and physical data models and data model standards that source data from multiple origins (internal data sources, external data sources, third party data, etc.).
• Develop Business/Subject Area Logical Data Models, Data Flow Diagrams.
• Develop detailed mapping documents that will provide the reporting and data warehouse team with source to target data mapping which will include logical names, physical names, data types, corporate meta-data definitions, and translation rules.

• Ability to travel if necessary for work or training.

·         Knowledge of database management structures (relational, hierarchical, distributed and associated platforms.

·         Knowledge of tools, techniques and practices for efficient and effective design and support of physical databases.

·         Understand tuning concepts, such as query plan, indexes, and statistics.

·         Ability to manage multiple concurrent objectives, projects, groups of activities.  Effective judgment in prioritizing and time allocation.

• Knowledge of approaches, tools and techniques for working with individuals and groups in a constructive and collaborative manner.
• Knowledge and ability to use and administer company technology practices, standards and procedures.

·         Knowledge of and ability to use office support tools available at the desktop (for example: word processing, e-mail, presentation software and spreadsheets).

• Knowledge of practices, behaviors, applicable laws, rules and regulations governing proper business conduct.
• Additional Skills and Abilities a Plus:
• Application development experience
• Business Objects XI,,Brio
• TWS batch scheduling tool
• Informatica Power Center, Informatica Power Exchange
• Data quality tools
• System Architect
• Sybase database experience including querying tools such as SQL Advantage
• Sybase Replication
• PVCS

 

Thanks & Regards,

 

Vimal Khandelwal

Net2Source Inc., SBE Certified (State of NJ)

One Evertrust Plaza, Suite#1103, Jersey City, NJ 07302

Phone: (201) 221-3821 | Fax: (201) 221-8131
Email: vimal@net2source.com | www.Net2Source.com

 

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful.