What are the responsibilities and job description for the Data Modeler position at Saxon Global?
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 :