Job Title: Data Modeler

Job Overview:

A Data Modeler is responsible for designing, implementing, and maintaining data models that support an organization’s data strategy. Their role is critical in ensuring data is structured efficiently for storage, retrieval, and analysis.

Responsibilities:

1. Understanding the data requirements of different business processes and stakeholders to create suitable data models.
2. Develop conceptual, logical, and physical data models to support business requirements.
3. Define data entities, attributes, relationships, and constraints to ensure consistency and integrity.
4. Ensure data models align with governance policies, business rules and standards.
5. Enforce naming conventions, data definitions, metadata standards, and documentation.
6. Work with Data Stewards to maintain data quality and consistency.
7. Partner with Data Architects to design scalable, optimized database structures.
8. Work with ETL developers and Data Engineers to implement data pipelines that align with the models.
9. Engage with business analysts and product owners to translate requirements into effective data structures.
10. Support data warehousing and analytical modeling for reporting and AI/ML use cases.
11. Maintain model documentation, data dictionaries, and lineage tracking.

Required Skills and Qualifications:

1. Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
2. Strong understanding of database concepts (relational, dimensional, NoSQL)
3. Data analysis skills
4. Business knowledge and ability to translate business needs into data models
5. SQL query writing skills
6. Excellent communication and collaboration skills

Preferred Skills

1. Familiarity with data warehousing methodologies
2. Experience is Snowflake
3. Experience in optimizing queries
4. Familiarity with Finance or Banking data models
5. Ability to work with business users, and technical teams
6. Strong skills in maintaining data dictionaries, lineage, and business glossaries

Experience Levels

Junior Data Modeler (1-3 years experience)

1. Exposure to relational (OLTP) and dimensional (OLAP) models
2. Ability to write queries with joins, indexing, and basic performance tuning
3. Understanding of data ingestion and transformation concepts
4. Basic understanding of ETL/ELT processes and data pipeline development.