Data Analyst/Modeler
At a glance
Mid-level Data Analysis & BI role at Integrated Resources INC. Bloomfield · contract.
Pay not stated Data Analyst salary
dataroles summary, based on the employer's posting.
What you'll do
- Turn business needs into functional specifications, then build conceptual, logical and physical data models
- Map data flows and transformations across enterprise systems, including metrics, feeds and repository structures
- Use Oracle databases to implement stored processes and views for uploading and accessing information
- Validate data access and implementation performance, then coordinate delivery plans with technology teams
- Advise on business processes, requirements, risk management and opportunities to improve operations
What you bring
- You have prepared functional, business and technical requirements and secured stakeholder acceptance
- You bring reference data analysis and modeling experience, including work with enterprise-wide reference data systems
- You understand reference data across equities, fixed income or derivatives
- You can query and tune SQL, compare data in Excel and Access, and build models with tools such as Erwin
Who this fits
This mid-level contract role suits a data analyst/modeler with enterprise reference data expertise and experience creating both OLTP and data warehouse models. The position is onsite in Whippany, New Jersey.
From the employer
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
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
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
Working Location is :- Whippany, NJ
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.