Saxon Global
Data Modeler
Saxon Global, New York, New York, us, 10261
Role: Data Modeler
Location: NYC NY
3 Days Hybrid from Day 1
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.
Location: NYC NY
3 Days Hybrid from Day 1
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.