Data Modeler (mid-level)

Spruce Infotech; Wilmington (DE); On-site; USD 85,000 - 115,000; Full time

Job summary

A leading service provider in Wilmington, Delaware, is seeking a mid-level Data Modeler to design and maintain complex data models. The ideal candidate has 3-5+ years of experience in database modeling and data warehousing, particularly within financial services. Responsibilities include capturing business requirements, maintaining documentation of data models, and participating in performance tuning. Familiarity with 3rd party tools like ERWin, TOAD, and SQL Navigator is essential. The role requires local presence in Wilmington and offers a dynamic, collaborative work environment.

Qualifications

• 3-5+ years’ experience modeling complex databases using ERWin 9.2.
• Experience designing large financial services data warehouses.
• Good knowledge of ER/Dimensional modeling in multi-application environments.

Responsibilities

• Capture business requirements and design logical models.
• Maintain logical and physical data models to support business needs.
• Conduct model reviews with project teams.
• Participate in performance tuning activities.

Skills

Complex database modeling

Data warehousing

Data analysis skills

ER/Dimensional modeling

Advanced SQL techniques

Oracle DBA experience

Business Intelligence tools

System Development Life Cycle (SDLC)

Tools

ERWin 9.2

TOAD

SQL Navigator

UNIX

Job description

Spruce InfoTech is the leading service provider in the fields of project management, architecture design, installation, implementation and administration of EPM and BI projects. Our team of experts provide with proven industry solutions that help our clients to have better understanding of the business and aides in decision making. We provide our clients with various services that help them to manage, control and transform their businesses by employing new age technology solutions that are cost effective and productive in nature. Our team members have huge experience in different types of enterprise solutions like that of Oracle Enterprise Performance Management (aka Hyperion), OBIEE and TIBCO.

Job Description

Title: Data Modeler (mid-level)

Duration: 1 year +

Interview mode: phone then F2F

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.

Qualifications

NEED TO BE LOCAL TO WILLINGTON,DELWARE(DE)