Data Modeller

Job Summary We are seeking an experienced Data Modeler to design and maintain enterprise data models that support analytics, reporting, and operational applications. The ideal candidate should have strong expertise in conceptual, logical, and physical data modeling, dimensional modeling, SQL, and modern cloud data platforms. Experience with BigQuery, Snowflake, Azure Synapse, or similar data warehouses is preferred. Mandatory Skills Data Modeling (Conceptual, Logical & Physical) Dimensional Modeling (Star Schema & Snowflake Schema) ER Modeling and Database Design SQL Data Warehousing Concepts Data Dictionary & Metadata Management Data Governance & Data Quality Cloud Data Platforms (GCP BigQuery/Azure Synapse/Snowflake) Good-to-Have Skills GCP (BigQuery, Cloud Storage, Dataflow) Azure Data Factory (ADF) ETL/ELT Design Data Vault Modeling Power BI/Tableau Python Informatica/DBT Roles & Responsibilities Design and maintain enterprise-wide conceptual, logical, and physical data models. Develop dimensional models using Star Schema and Snowflake Schema for reporting and analytics. Collaborate with business stakeholders to understand data requirements and translate them into scalable data models. Define business entities, relationships, hierarchies, measures, dimensions, and semantic standards. Create canonical data models supporting enterprise data products and domain-driven architecture. Design data models for cloud-based analytical platforms such as BigQuery, Snowflake, or Azure Synapse. Support data modeling across Bronze, Silver, and Gold layers in modern data lakehouse architectures. Work closely with Data Engineers, BI Developers, Architects, and Business Analysts during solution design. Ensure data models comply with governance, security, privacy, and regulatory standards. Perform data profiling, impact analysis, and metadata management. Optimize data structures for scalability, query performance, and maintainability. Review existing models and recommend improvements for performance and data integrity. Create and maintain ER diagrams, data dictionaries, lineage documentation, and model standards. Participate in architecture reviews and establish enterprise data modeling best practices. Required Qualifications Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. 510 years of experience in Data Modeling and Data Warehousing. Strong expertise in SQL and relational database design. Hands-on experience with data modeling tools such as ERwin, ER/Studio, SAP PowerDesigner, Visio, or Lucidchart . Experience working with cloud data warehouses such as BigQuery, Snowflake, Azure Synapse, or Amazon Redshift . Strong understanding of Data Governance, Master Data Management (MDM), Metadata Management, and Data Quality concepts. Excellent analytical, communication, and stakeholder management skills. Preferred Skills Experience with GCP Data Platform and BigQuery. Knowledge of Data Vault 2.0. Familiarity with DBT, Apache Airflow, or other modern ELT frameworks. Experience in Agile/Scrum delivery environments. Exposure to Banking, Healthcare, Retail, or Insurance domains.