- We are seeking an experienced Data Modeler to design, develop, and maintain high-quality data models that support enterprise analytics, reporting, and operational systems.

- The role focuses on translating complex business requirements into logical and physical data models while ensuring data consistency, integrity, scalability, and governance across platforms.

- The ideal candidate will work closely with business stakeholders, data architects, data engineers, and application teams to enable reliable, well-structured, and future-ready data ecosystems.

Key Responsibilities :

Data Modeling & Design :

- Create and maintain conceptual, logical, and physical data models for enterprise systems.

- Design relational, dimensional, and NoSQL data models aligned with business and technical requirements.

- Develop star, snowflake, and hybrid schemas for data warehouses and analytics platforms.

- Define data entities, attributes, relationships, keys, constraints, and normalization standards.

Business Requirements & Collaboration :

- Work with business stakeholders to understand data requirements, definitions, and usage patterns.

- Translate business rules into structured data models and metadata definitions.

- Partner with data architects, BI teams, and application developers to ensure alignment.

Data Governance & Quality :

- Establish and maintain data standards, naming conventions, and modeling best practices.

- Support data governance initiatives including lineage, ownership, and stewardship.

- Ensure data quality, integrity, and consistency across systems.

- Assist with impact analysis for schema changes and data migrations.

Enterprise Data Platforms :

- Model data for OLTP systems, data warehouses, data lakes, and lakehouse architectures.

- Support cloud-based data platforms (AWS, Azure, GCP) and modern analytics ecosystems.

- Design models optimized for performance, scalability, and query efficiency.

Documentation & Metadata :

- Maintain comprehensive data dictionaries, ER diagrams, and metadata repositories.

- Document source-to-target mappings and transformation logic.

- Provide inputs for regulatory, audit, and compliance reporting (where applicable).

Must-Have Skills & Qualifications :

- Strong experience in data modeling for large-scale enterprise systems.

- Proficiency in ER modeling, dimensional modeling, and normalization techniques.

- Hands-on experience with relational databases (Oracle, SQL Server, PostgreSQL, MySQL).

- Strong SQL skills for data analysis and validation.

- Ability to translate complex business requirements into structured data designs.

Technical Skills :

Data Modeling Tools :

- ERwin, ER/Studio, PowerDesigner, or equivalent

Databases :

- Oracle, SQL Server, PostgreSQL, Snowflake, Redshift

Analytics & BI (good to have) :

- Power BI, Tableau, Looker

Cloud Platforms :

- AWS, Azure, or GCP (data services exposure preferred)

Data Concepts :

- Data warehousing, data lakes, metadata management, MDM

Preferred Qualifications :

- Experience in Banking, Financial Services, Insurance, or Regulated Domains.

- Exposure to big data ecosystems (Hadoop, Spark).

- Knowledge of data governance, lineage, and regulatory reporting.

- Certification in Data Management or Data Modeling (CDMP, DAMA good to have).

Key Competencies :

- Strong analytical and problem-solving skills

- Attention to detail and data accuracy

- Ability to work independently and manage multiple data initiatives

- Excellent communication and stakeholder interaction skills