Monday, January 16, 2012

[Outsource:58848] Data Architect

Please send resume to annie@addonusa.com

 

Data Architect

Location: Menomonee Falls, WI

Duration: 6+ months

 

Details:

 

Job Description: The Data Architect will work with a variety of levels of IS personnel to independently analyze complex data requirements, develop/manage/update data models, and develop database designs. He/she will participate in data requirements gathering and analysis discussions and translate the business data requirements into logical and physical data models. He/she may also assist the application team in determination and clarification of business data requirements. The Data Architect must also be able to identify problems at the data modeling/design level and recommend solution to problems. The Data Architect interacts with team members, Database Administrators and other Information Services team members to ensure accurate identification, definition and interpretation of data requirements, data models and database designs. The Data Architect will maintain and enforce data architecture/administration standards, as well as standardization of column name abbreviations, domains and attributes. The preferred candidate will have multiple years of data modeling / database design experience. 

 

Data Architect - Data Architect 

 

Additional Skills: Focus

• 5+ years of logical and physical 3NF data modeling in an operational system development environment.

• 5+ years of logical and physical modeling utilizing a major data modeling tool (ex. ER/Studio, ERwin, PowerDesigner)

• Strong knowledge of DBMS concepts (views, foreign keys, primary keys, indexes, referential integrity, column constraints), SQL, and DDL generation and validation.

• Excellent interpersonal, verbal and written communication skills.

• Enterprise-wide viewpoint and forward thinking.

• Ability to research project needs independently and correlate them to other similar concepts within the enterprise.

• Strong analytical abilities. Based on both written and verbal system development requirements, knows what questions to ask and when to ask them.

 

**Tools / Software**

• ER/Studio & ER/Studio Repository

• Microsoft Office Suite

• Visio

 

Analysis

• Business Analysis

• Data Requirements Analysis

• Enterprise-wide consistency

• Major retail knowledge

 

Data Modeling

• Data modeling theory

• Logical data modeling

• Physical data modeling

• DDL generation and validation

• Excellent definition writing

• Semantic consistency (across the enterprise)

• IE ERD notation

• 3NF – Operational modeling

• Dimensional modeling (star schema and snowflake)

• DBMS constructs (views, constraints, indexes, etc.)

• Abstraction techniques

• Generalization recognition

• Appropriate application of denormalization

• Data modeling patterns

• Provides direction and training on modeling and DBMS constructs

• Knowledge of reference data models (ARTS, CWM, etc.) - optional

• CDMP certification - optional

 

Governance

• Follows standards & able to enforce standards

• Data quality

• Data security

• Familiarity with system development methodologies (ex. I.E., Zachman Framework)

 

Development

• SQL on multiple platforms

• Any development background 

 

 

Thanks & Regards

 

Annie Mark   

Addon Technologies

Ph:  734-956-4737 Ext 1+202

annie@addonusa.com

www.addonusa.com

 

Please visit  www.NRIYP.com
New generation Yellow pages for NRI's
Classifieds|Yellow Pages|Travel|Classmates

 

 

 

 

--
Introduce business in 3800 cities. How?
=====================================================
Thanks for using group.
Moderator
 
1) This group is managed by www.BRCIndex.blogspot.com
2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business.
3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club)
4) Reply to two message before posting new one.
5) Donot post same message in all 3800 business Referral Club.

You received this message because you are subscribed to the Google Groups "Outsource" group.
To post to this group, send email to Outsource@googlegroups.com
To unsubscribe from this group, send email to Outsource-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Outsource

No comments:

Post a Comment

PAID CONTENT