Urgent requirement: Data Architect, MENOMONEE FALLS, Wisconsin

Data Architect (150812-IO80ADAHER)

MENOMONEE FALLS, Wisconsin

5 months

Description:

Data Architect to support OPERATIONAL PROJECTS.
We are looking for Data Architects with strong data modeling experience who can lead modeling sessions, if necessary. The candidate will need to work independently with minimal work direction and have a thorough understanding of operational modeling techniques (3NF, etc).

Please see Additional Skills section for the specific skill set we are seeking.

Attached form MUST be completed for each candidate submitted. !
Estimated Expense: $0.00 (Sum of Expense * Quantity of Candidates)

General InformationGeneral Information
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.

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