| DATA MODELER || INVESTMENT DOMAIN || NEW YORK - HYBRID at NYC, New York, USA |
| Email: [email protected] |
| Role: Data Modeler Location: NYC NY 3 Days Hybrid from Day 1 EXPERIENCE : 12+ YEARS Investment Domain / Capital Market experience is must. Given we use a wide variety of databases in MDP, it would be a plus if the candidate worked in OLTP (on-prem), OLAP (Redshift) and NoSQL Databases (like Mongo, Graph etc.,). Prior experience in Investment Banking and Capital Markets will also be a good advantage for a candidate. Job Description: Develop conceptual, logical, and physical data models for SQL (e.g: OLTP & OLAP) and NoSQL Databases (e.g: MongoDB, Search Stores, GraphDB) to meet the needs of the business. Work closely with domain experts, business stakeholders & key SMEs to understand business processes, use-cases, data requirements and translate them into data models. Design and implement data structures, database schemas, tables, views, and indexes that support efficient storage, retrieval and management of structured, semi-structured and un-structured data. Create data flow diagrams and entity-relationship diagrams to document data structures. Work with ETL developers to ensure data transformations are correctly implemented. Support data integration efforts by providing data models that facilitate data exchange between systems. Collaborate with data architects and database administrators to ensure data models are implemented correctly. Optimize database performance through efficient data modelling techniques. Conduct regular reviews of data models and make necessary adjustments to improve performance and scalability. Monitor and troubleshoot database performance issues. Desired Skills: Proven experience as a Data Modeler or in a similar role w/ exposure to Investment Banking and Capital Markets domain. Proficiency in data modelling tools (e.g., ERwin, ER/Studio, PowerDesigner). Strong understanding of database management systems (e.g., SQL Server, AWS Redshift, MongoDB). Knowledge of data warehousing concepts and technologies. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Exposure to Cloud is a plus. -- Keywords: information technology New York DATA MODELER || INVESTMENT DOMAIN || NEW YORK - HYBRID [email protected] |
| [email protected] View all |
| Thu Aug 15 23:19:00 UTC 2024 |