Job Description :

Title: Data Modeler
Location: St. Louis, MO or Minneapolis, MN
Duration: 18 months
Mode of Interview: Web-Ex or (Phone and Skype)!!!!

Experience designing dimensional and transactional database models in ERWin, PowerDesigner (preferred) or ER/Studio, including model management in a shared environment.
Optimization and generation of DDL for both Oracle and DB2.
Source to target mapping and data analysis. Deployment of database changes using Harvest/Anthill or equivalent.

Top Skills:

Data Modeling in a large environment using a tool such as PowerDesigner, ERWin or ER/Studio. We use PowerDesigner so that is preferred.
Oracle or DB2 physical design experience including indexing, referential integrity, partitioning, etc.
Experience performing source-to-target mapping and creating design documents
Analytic skills – need the ability to reconcile the obligatory vague and conflicting requirements with the existing database design and recommend solutions
Communication skills – we are a distributed company and most meetings will be virtual. Candidate needs to be comfortable jumping on a phone call, sharing their screen and walking through a database with a group of people they cannot see.
Self-starter – we’re bringing in several people and our team is too small to devote a ton of resources to onboarding without negatively impacting projects in flight. We have copious documentation that will need to be read (some coffee required