Logical Data Modeler - P4 - (US-WA-Renton - 98059)

Minimum Education: None
Jobcode: 48973901
Email this job to yourself or to a friend

Logical Data Modeler - P4

Requisition Number: 07-1025247
Job Status: Activated - Posting Type: Posted Internally and Externally. - Posting Status: Available

Location
Renton, WA

Virtual Office/Telecommute?
(Things you should know about Virtual Office)
Virtual Work Possible

Shift
First

Business Unit
Engineering Ops & Tech

Division
Information Technology

Program
Architecture & Info Mgmnt

Occupation Title
Information Technology

Skills Management Title
Data Analysis & Modeling

Job Classification
BAUVP4

Job Type
Non-Management

Experience Level
Mid Level (5-15 years of experience)

Exemption Status
Exempt

Union
No

Security Clearance Required?
(Security Clearance definitions)
No Security Clearance Required

Work Eligibility Required?
Yes

US Person Status Required?
Yes

Export Control Required?
Yes

Relocation Money Available?
Yes

Date Posted
10/18/2007

Closing Date
(Things you should know about closing dates)
01/14/2008

Position Description
BCA Common Data Warehouse (CDW) Logical data modeler with hands-on experience implementing 3NF logical and physical models. Working under the direction of the Data Architect, work with business and IT computing system personnel to discover data related requirements and utilize them to create logical data models. Required: 5 years of conceptual and logical data modeling experience resulting in implemented systems. High proficiency using data modeling tools (Erwin preferred). Data analysis skills using SQL, especially as related to Data Profiling large and complex data sets to be able to discover and/or validate data quality and business rules. Modeling experience with Engineering and Manufacturing data, especially the integration of disparate data into common structures. Desired: Some DBA/Physical Data model implementation experience. Operational Data Store/Data Warehouse/Data Mart implementation experience. Functional Specification creation experience- especially for data conversion/ETL. Characteristics Required: - Must be a self-starter and capable of operating independently within specified architectural boundaries and approach. - Must dislike ambiguity but be able to deal with it. - Must be practical and adaptive. - Must be able to communicate effectively with non-IT people and very technical IT people - Must be able to ferret out data model requirements from a wide variety of sources- business documentation, system documentation, actual data, conversations with subject matter experts. - Must be able to organize and lead data modeling sessions with IT and non-IT people. - Must be a team player.

Competencies
General/Leadership
[ + ] Adaptability

Maintains effectiveness when experiencing major changes in work tasks or the work environment; adjusts effectively to work within new work structures, processes, requirements, and/or cultures.
[ + ] Communication

Clearly conveys information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.
[ + ] Customer Focus

Makes customers and their needs a primary focus of one's actions; develops and sustains productive customer relationships.
Technical
[ + ] Analytical Skills

Skill and ability to: collect, organize, synthesize, and analyze data; summarize findings; develop conclusions and recommendations from appropriate data sources.
[ + ] Data Mining

Ability to use a variety of techniques and tools to analyze the data stored in databases, data warehouses and/or data marts. Presents interpretable results in a format understood by the business.
[ + ] Data Model/Architecture

Ability to build conceptual (business objects), logical (systems), and/or physical (database) models using computer tools. Integrates models across domains and applications and translates models from one level (e.g. conceptual) to another (logical).
[ + ] Data Modeling Technology

Knowledge of information design, data modeling tools, and techniques. Apply knowledge of business processes to data models.
[ + ] Database Architecture

Knowledge of web standards for web designing. Knowledge of information design, database software, network and server hardware, database networking protocols, and database performance tools.
[ + ] Information Technology Fluency

Ability to utilize technological tools (e.g., PC's, web sites) and business system applications to manage, synthesize, and interpret data relevant to workloads, responsibilities, problem identifi