Data Analyst/Modeler
TLDR
Develop and implement enterprise data models and requirements for banking tech, leveraging Oracle/RDBMS, SQL, and data warehousing expertise to drive data-driven solutions.
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
Integrated Resources, Inc. is a leading staffing firm that specializes in connecting businesses with top-tier talent in Information Technology, Clinical Research, Rehabilitation Therapy, and Nursing. Known for our exceptional service and integrity, we help organizations streamline their workforce solutions by providing quality resources tailored to their specific needs.