Previous Job
Data Modeler
Ref No.: 17-25318
Location: Overland Park, Kansas
Required Skills :

Basic Qualifications :
We're seeking candidates who have 5+ years of experience in Data Modeling, and experience with:

Relational database administration (preferably SQL, DB2, and/or M204)
SQL queries
Data analysis
Reverse engineering of data
Basic UNIX commands/scripting

Job Description :
Develop, maintain, and support the company’s logical data environment. Participate in projects relative to the requirements and design of the logical data environment. Provide guidance to developers, database administration, and data administration concerning design and transition to the physical data environment. Propose ways to improve the environment and help set data administration direction. Advocate the development and use of an enterprise data model and metadata management. Participate in large, cross-enterprise projects requiring strong analysis, design, and leadership skills.
Conduct sessions and interviews to gather data requirements.
Understand and apply logical entity-relational design concepts.
Perform enterprise and project data modeling, including model consolidation and integration.
Document, develop, and maintain data models in Erwin or equivalent modeling tools.
Participate in business process modeling, working with the developers, with respect to data mapping and validation of the data’s life cycle.
Safeguard the integrity of the logical design in true third-normal form as a reflection of the business not a system.
Manage and establish standards for naming and abbreviation conventions, data definitions, ownership, documentation, procedures, and techniques.
Market and educate on the data administration role to facilitate its advocacy and reinstitution.
Consult with DBAs on the translation of logical models into physical models.
Demonstrate clear, concise, accurate, and timely communication to management, peers, and customers; in written and oral form.
Adopt, support, and participate in the implementation of the Enterprise Data Management Strategy.
Possess a good understanding of the company and the transportation industry.
Deal with vendor-related issues concerning the support, implementation, upgrade and impact analysis, evaluation, and selection of third-party products.
Bachelor’s degree in Computer Information Systems, Management Information systems, or Computer Science or related job experience.
2 year relational database administration in Oracle, SQL Server, DB2
5 years as data modeler involved in mid- to large-scale system development projects
Database administration on one or more of the following platforms – Oracle, SQL Server, DB2, and M204
Erwin data Modeler or equivalent tool
Basic Unix/AIX commands and scripting
Exposure to all System Development Life Cycle (SDLC) phases, with experience directly contributing to design, development, validation, implementation and operational support activities
Data analysis/profiling and reverse engineering of data.
Strong knowledge of relational and multi-dimensional database architectures.
Transportation experience