Integrated Resources logo

Data Analyst/Modeler

Integrated Resources
Contract
On-site
Bloomfield, New Jersey, United States

Company 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Β 

Skills / Aptitude Required

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


Additional Information

Working Location is :- Whippany, NJ