Previous Job
Previous
Data Modeler
Ref No.: 18-01517
Location: New York, New York
Job Description:
Develop database models and support documentation in order to meet business requirements for reporting and analytic databases. Analyze data sources and requirements and business rules. Perform logical and physical data modeling. Write prototypes to prove data transforms. Write specifications for development, then implement and test database design. Coordinate data models across marts and warehouses. Manage dictionaries and other documentation across multiple datamarts and warehouses.

Requirements:
Extensive experience in: data modeling/database design experience; database administration; and impact analysis of data structure changes. 5+ years of logical and physical data modeling in an operational system development environment. 5+ years of logical and physical modeling utilizing a major data modeling tool. 5-7 years of relevant work experience required.

Additional
4. Good understanding of relational database modeling, Strong hands-on experience in in Oracle SQL and PL/SQL development in 11g and 12c environments
5. Assist the development team in the design, development, testing, tuning and implementation of database applications.
6. Create and maintain SQL queries and routines, work with complex data models and object relational database mapping, while producing complex reports.
7. Need to be able to optimize, tune and troubleshoot SQL code
8. Good understanding of Server performance troubleshooting
9. Understanding of third party software management a huge plus