Job Description :
Position Title Database Analyst
Duration: 18 months
Locations:
1 N Jefferson Ave Saint Louis MO United States 63103
550 South 4th St Building 68 Minneapolis MN United States 55415
Data Modeler
Responsibilities:
Provides the highest technical expertise for the planning, analysis, design, implementation, and control of the organization's data. Handles and leads the most complex or critical data management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database design, integration, source-to-target mapping, data modeling and performance tuning. As the recognized technical expert, consults extensively with multiple client groups to provide solutions, implementing long-range internal and enterprise-level data architecture and management strategies. Serves as a consultant on technological advancements. Provides oversight, mentoring and leadership to less experienced staff.
Requirements:
· 10+ years of database design and administration experience
· Experience designing dimensional and transactional database models in PowerDesigner (preferred), ERWin 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