Description :
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 identifications and resolutions. Ability to operate relevant personal computing hardware (e.g., personal computers, software, printers, storage media) and standard software (e.g., word processing, graphics packages, spreadsheets/databases).
[ + ] System/Data Architecture
Ability to model and analyze data from a computing technical and specific business process viewpoint; integrates the data into a computing system and application architecture. Ability to interrelate, from system architecture, design, build, test, and deploy the fundamental aspects needed to produce effective computing solutions.
Education and/or Experience
Bachelor's degree and typically 9 to 13 years' related work experience or a Master's degree with 7 to 11 years' related work experience or a PhD degree with 4 to 8 years' related work experience or an equivalent combination of education and experience.
Other Job related information
Although you need to live locally, virtual office arrangements are possible after an appropriate level of experience and proficiency is attained. On-call support and overtime will be required. Travel between Renton and Everett and possibly other Puget Sound locations is expected.
