Data Modeler (mid-level)

Title

Data Modeler (mid-level)

Location

Wilmington, DE

Duration

1 year +

Interview mode

phone then F2F

Description

Required Skills

• Minimum 3-5+ years’ experience modeling complex databases using 3rd party modeling tools such as ERWin 9.2
• Experience designing and building large financial services data warehouses with very strong data analysis skills
• Have good knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments.
• 3-5+ years of hands-on experience in data management, data warehousing, data transformation, metadata and reference data management and business intelligence tools.
• 3+ years of experience with advanced SQL query techniques using TOAD, SQL Navigator. Basic UNIX would be a Plus.
• Previous experience as a hands-on Oracle DBA of large database is a plus.
• Must have good understanding of leading 3rd party products in the relevant areas (e.g. Datastage, Business Objects, Microstrategy).
• Significant experience with System Development Life Cycle (SDLC)

Responsibilities

• Capture business requirements and rules, design the associated logical models, and create all required documentation to support, communicate, and validate the data model.
• Design, build and maintain the logical and physical data models to support the business requirements in a dynamic, expanding business environment.
• Map data elements of data sources into the domain data models.
• Maintain documentation of data models, including relationships, constraints and metadata.
• Publish and conduct model reviews with business and technical project teams.
• Review database design changes with the team to determine the impact to the physical database and other systems.
• Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues.
• Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization
• Architect with an eye toward high performance, scalability, and high availability.

NEED TO BE LOCAL TO WILLINGTON,DELWARE(DE)

Title

Data Modeler (mid-level)

Location

Wilmington, DE

Duration

1 year +

Interview mode

phone then F2F