Data Modeler; mid-level

Spruce Info Tech is a leading service provider in project management, architecture design, installation, implementation, and administration of EPM and BI projects. Our team of experts provides proven industry solutions that help clients better understand their business and make informed decisions.

We are seeking a Data Modeler (mid-level) with a minimum of 3-5 years of experience.

Duration: 1 year +

Interview mode: phone then F2F

• Capture business requirements and rules, design associated logical models, and create required documentation to support, communicate, and validate the data model.
• Design, build, and maintain logical and physical data models to support business requirements in a dynamic environment.
• Map data elements of data sources into 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 to determine the impact on the physical database and other systems.
• Coordinate with development/implementation teams to improve model formats and approaches regarding 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.

• Minimum 3-5+ years of experience modeling complex databases using 3rd party modeling tools such as ERWin 9.2.
• Experience designing and building large financial services data warehouses with strong data analysis skills.
• Good knowledge of ER/Dimensional modeling and extensive experience developing logical and physical data models in complex 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 is a plus.
• Previous experience as a hands-on Oracle DBA of large databases is a plus.
• Must have a good understanding of leading 3rd party products in relevant areas (e.g., Datastage, Business Objects, Microstrategy).
• Significant experience with System Development Life Cycle (SDLC).
• Must be local to Wilmington, Delaware (DE).