Data Modeler,

ISHR; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading data management company in Chennai is looking for a Data Modeler to design, implement, and optimize data models for its data warehouse and cloud-based initiatives. The role involves collaboration with Data Engineers, Analysts, and stakeholders to meet evolving business needs. Candidates should have a Bachelor's degree in Computer Science and proven experience in data modeling, ETL, and cloud environments. Knowledge of SQL and data modeling tools is essential, along with strong analytical skills.

Qualifications

• Proven experience as a Data Modeler with a focus on data warehousing and ETL.
• Strong background in designing and implementing data models.
• Hands-on experience with SQL and relational databases.

Responsibilities

• Design and develop conceptual, logical, and physical data models.
• Collaborate with cross-functional teams to support data initiatives.
• Optimize data models for performance and scalability.

Skills

Data modeling techniques

SQL proficiency

Cloud-based data platforms

Data warehousing

ETL processes

Education

Bachelor's degree in Computer Science or related field

Tools

ETL tools

PostgreSQL

MySQL

SQL Server

Data modeling tools

Job description

Position Overview

As a Data Modeler, you will play a crucial role in designing, implementing, and optimizing our data models to support our data warehouse, ETL processes, and cloud-based data initiatives. You will collaborate closely with cross-functional teams including Data Engineers, Data Analysts, and Business Stakeholders to ensure that our data architecture meets the evolving needs of the business.

Responsibilities

• Design and develop conceptual, logical, and physical data models that align with business requirements and support data warehousing, ETL processes, and data modernization initiatives.
• Collaborate with Data Engineers to implement and maintain scalable data pipelines for extracting, transforming, and loading data from various sources into our data warehouse.
• Optimize data models for performance, scalability, and data integrity, considering factors such as query performance, data volume, and storage requirements.
• Work closely with Business Stakeholders and Data Analysts to understand data requirements, translate business needs into technical solutions, and ensure data models meet analytical and reporting needs.
• Drive data modernization efforts by evaluating and implementing new technologies, methodologies, and best practices for data modeling, data management, and data governance.
• Provide technical expertise and guidance to junior team members, promoting knowledge sharing and continuous learning within the team.

Requirements

• Bachelor’s degree or higher in Computer Science, Information Systems, or a related field.
• Proven experience (X years) as a Data Modeler or similar role, with a strong background in designing and implementing data models for data warehousing, ETL, and cloud-based environments.
• In-depth knowledge of data modeling concepts, techniques, and best practices, including dimensional modeling, star schemas, and snowflake schemas.
• Hands‑on experience with ETL tools and processes, including data extraction, transformation, and loading.
• Proficiency in cloud‑based data platforms such as AWS, Azure, or Google Cloud Platform, with experience designing data solutions in a cloud environment.
• Strong SQL skills and experience working with relational databases such as PostgreSQL, MySQL, or SQL Server.
• Familiarity with data modeling tools such as ERwin, ER/Studio, or PowerDesigner.
• Excellent analytical and problem‑solving skills, with the ability to translate complex business requirements into practical data solutions.
• Strong communication and collaboration skills, with the ability to work effectively in cross‑functional teams.

Preferred Qualifications

• Experience with big data technologies such as Hadoop, Spark, or Hive.
• Knowledge of data virtualization and data federation.