Data Analyst/Modeler

Integrated Resources Inc.; Bloomfield (NJ); On-site; USD 80,000 - 120,000; Full time

Job summary

A staffing firm seeks a Senior Data Analyst/Data Modeler to join a leading bank's team in New Jersey. The role involves defining and implementing data models, preparing functional specifications, and collaborating with technology teams to enhance data systems. Ideal candidates will have strong analytical skills with experience in reference data and database technologies.

Qualifications

• Experience with Enterprise wide Reference Data Systems.
• Expertise across Equities/Fixed Income/Derivative asset classes.
• Hands-on SQL data query knowledge and performance tuning.

Responsibilities

• Prepare Functional requirements specification documents following SLDC practices.
• Perform data analysis, including mappings and transformations.
• Develop logical and physical data models for projects.

Skills

Data Analysis

SQL

Data Modeling

MS Excel

MS Access

Education

Experience preparing functional/business/technical requirements

Reference Data Analyst experience

Reference Data Modeling experience

Tools

Erwin

Oracle

Job description

A Few Words About Us - Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.

This position is with my direct client

Job Description

Main Function

o Senior Data Analyst/Data Modeler

o The design and implementation of functional and non-functional requirements

o Integrate with existing and emerging bank technologies

Main Duties

o Prepare Functional requirements specification documents in accordance with standard SLDC business practices.

o Define Data Repository Conceptual / Logical Data Model based on requirements

o Physicalize the data model on Oracle / RDBMS Database

o Define Metrics Logical Entities and Attributes

o Perform all levels of data analysis, including data mappings, data feeds, data models, and data transformation as related to an Enterprise Environment

o Develop fully defined logical and physical data models as related to assigned task and/or project

o Provide consultative expertise related to business practices, procedures, requirements, risk management and process improvements

o Implement Stored Process and View to upload and access information

o Test / Validate the information and access

o Test the performance of the implementation

o Liaise with technology team to plan and execute requirements

o Superior communication skills both written and verbal

o Extremely proficient with MS Excel and Access with emphasis on data comparison

o Hands on SQL data query knowledge and performance tuning

o Ability to derive data models through requirements gathering with developers and end users

o Experience with data modeling tools like Erwin

o Experience developing both OLTP and Data Warehousing data models

o Solid understanding of relational databases

Qualifications

Qualification / Education Requirements

o Experience preparing and obtaining acceptance of Functional, Business and Technical requirements

o Reference Data Analyst experience

o Reference Data Modeling experience

o Prior knowledge/experience of working on Enterprise wide Reference Data Systems

o Reference Data domain expertise across Equities/Fixed Income/Derivative asset classes