Spruce Infotech Inc.

Data Modeler (mid-level)

  • Wilmington, DE
  • contractor
  • Posted over a year ago
  • Staffing / consulting
Apply on Spruce Infotech Inc.'s site ↗Checked today on the employer's career site. We never take applications.

Job Description

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.

Qualifications

NEED TO BE LOCAL TO WILLINGTON,DELWARE(DE)

Additional Information

Title: Data Modeler (mid-level)

Location: Wilmington, DE

Duration: 1 year +

Interview mode: phone then F2F

Similar open jobs

JIRA Admin

Spruce Infotech Inc.Austin, TX

Employerover a year ago