Data Modeler - SQL/Data Warehousing

Roles & Responsibilities : - Experience in working with SMEs to build Conceptual Data models - Convert business requirements into technical requirements, supported by an efficient data model and detailed mapping - Build Logical/Physical Models in Azure using best practices to ensure business requirements are met within the agreed SLAs - Hands on experience of implementing the following methodologies - Dimensional models (Ralph Kimball) - Corporate Information Factory (Bill Inmon) - Data Vault - Experience of building Data Lake / Data Warehouse on Azure - Good knowledge on ADLS, ADF, ADB & SQL - Optimize logical/physical models to support new requirements - Optimize logical/physical models with required metadata using Industry standard tools (Preferably ER/Studio) - Develop and implement best practices and processes around naming standards to ensure consistency across the models & versioning of models - Perform reverse engineering of physical models from existing databases and scripts - Recommend opportunities to reuse existing data models for new use cases - Analyse challenges around data integration / data mastering and propose appropriate solutions - Work with development team to implement data strategy, build efficient data flows and testing of data loads - Work with consumption teams to help explain the data model usage and amend the model to support efficient exploitation of data - Creation, review and maintenance of data modelling and data mapping artefacts - Contribute to the E2E Data Architecture & Design (Ingestion - Transformation - Reporting) - Identifying ways to improve data reliability, efficiency, and quality. (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 5/1/2025