Data Modeler / Architect

Mindlance; Somerset (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

A national recruiting company is seeking an experienced Data Warehouse Data Modeler/Architect to create and maintain data structures for data management solutions. The ideal candidate will have over 5 years of experience and a strong background in data modeling. Responsibilities include developing data models and analyzing complex data structures. Join a fast-paced environment where you will utilize your analytical skills and knowledge of database technologies.

Qualifications

• 5+ years of experience as a Data Warehouse Data Modeler/Architect.
• Experience in building complex, large scale logical data models.
• Excellent analytical and communication skills.

Responsibilities

• Create relational and dimensional data structures for data management solutions.
• Develop and maintain data subject area data models.
• Design and validate data solutions based on architectural principles.

Skills

Data modeling

Data analysis

Communication skills

Database design

Analytical skills

Education

Undergraduate degree in applicable area

BS degree

Tools

Erwin

E/R Studio

Oracle

Job description

Mindlance is a national recruiting company which partners with many of the leading employers across the country. Feel free to check us out at http://www.mindlance.com.

Job Description

Location: Bristol CT

Duration: 9 Months

Responsibilities:

• Partner with our architecture, data development and application development teams to create relational and dimensional data structures for data management solutions.
• Develop and maintain various data subject area data models for Data Warehouse, Operational Data Store and Data Marts.
• Define relationships and touch points between data subject areas.
• Gap analysis.
• Analyze complex data structures
• Compose accurate and complete definitions for entities and attributes
• Perform source system analysis and data profiling
• Design and validate data solutions which are achieved through the application of industry proven architectural principles, standards and governance.

Basic Qualifications:

• 5+ years of experience working as an Data Warehouse Data Modeler / Architect.
• Undergraduate degree in applicable area of expertise or equivalent work experience
• Experience in building complex, large scale logical data models with Erwin, E/R Studio, or another data modeling tool
• Experience in relational and dimensional schemas for Enterprise Data Warehouse
• Experience in data modeling (physical and logical), ER diagrams, data dictionary, data mapping
• Experience in Data Architecture and Database design
• Experience with database technologies (e.g. Oracle)
• Excellent analytical and communication skills

Preferred Qualifications:

• Exposure with the below technologies and / or skills will be considered a plus:
• Oracle 11G, Data movement architectural patterns, and a thorough understanding of system development lifecycles.
• Experience in data modeling, data mapping, and data architecture is desirable.
• Required Education BS

Additional Information

Vikram Bhalla | Team Recruitment | Mindlance, Inc. | W : 732 504 6695

All your information will be kept confidential according to EEO guidelines.