Role & responsibilities
- Enterprise Data Architecture & Modeling: Lead the design, development, and maintenance of Conceptual, Logical, and Physical data models for both OLTP and OLAP enterprise systems.
- Dimensional Modeling & Warehousing: Architect scalable Data Warehouse schemas using Kimball methodology, facts, dimensions, star, and snowflake schemas to support advanced analytics.
- Database & Cloud Optimization: Design robust relational and cloud database structures across platforms such as Oracle, SQL Server, PostgreSQL, Snowflake, Amazon Redshift, and Azure Synapse.
- Data Modeling Tool Mastery: Utilize industry-standard tools (ERwin, ER/Studio, SAP PowerDesigner, Oracle SQL Developer Data Modeler, Lucidchart, or Visio) to generate and maintain comprehensive data models and documentation.
- ETL/ELT Integration & Pipeline Design: Collaborate with data engineering teams to define data pipelines, source-to-target mappings (STM), ETL/ELT workflows, and transformation logic.
- Data Governance & Metadata Management: Establish data modeling standards,



maintain enterprise business glossaries, manage metadata, and enforce Data Governance and Master Data Management (MDM) best practices.
- Cross-Functional Collaboration: Partner with BI developers, cloud architects, and business analysts in an Agile/Scrum environment to ensure data models align with reporting and business intelligence requirements (Power BI, Tableau, Looker).
- Cloud & Advanced Tech Integration: Leverage cloud data ecosystems (Azure, AWS, GCP) and big data platforms (Databricks, Spark) to modernize data pipelines and support NoSQL/API integrations where required.

Preferred candidate profile
- Experience: 7 to 10 years of overall IT experience with a minimum of 3 years of hands-on expertise in enterprise data modeling (OLTP & OLAP).
- Core Technical Expertise:
- Solid mastery of Conceptual, Logical, and Physical Data Modeling using Kimball Dimensional Modeling methodologies.
- Deep expertise in writi

📌 Data Modeller (Indore)
🏢 BCS Consulting
📍 Indore