Data Modeler — Financial DW & BI Specialist

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

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.