Role : Sr Data Modeller
Location : Bangalore (working from Office)
Job Summary : We are seeking a highly experienced Senior Data Architect to lead the design and development of conceptual, logical, and physical data models for enterprise and application-level databases. The successful candidate will have a strong background in data modeling, data warehousing, and data governance, with expertise in cloud environments, Databricks, and Unity Catalog. The ideal candidate will have a deep understanding of business processes around master data management in a B2B setup and experience with data governance and data quality concepts.
Key Responsibilities :
- Design and develop conceptual, logical, and physical data models for enterprise and application-level databases
- Translate business requirements into well-structured data models that support analytics, reporting, and operational systems
- Define and maintain data standards, naming conventions, and metadata for consistency across systems
- Collaborate with data architects, engineers, and analysts to implement models into databases and data warehouses / lakes
- Analyze existing data systems and provide recommendations for optimization, refactoring, and improvements
- Create entity relationship diagrams (ERDs) and data flow diagrams to document data structures and relationships
- Support data governance initiatives including data lineage, quality, and cataloging
- Review and validate data models with business and technical stakeholders
- Provide guidance on normalization, denormalization, and performance tuning of database designs
- Architect end-to-end data pipelines, data integration frameworks, and data governance models to enable seamless flow of structured and unstructured data from multiple sources (cloud and on-premise)
- Ensure models comply with organizational data policies, security, and regulatory requirements
Requirements :
12+ years of experience in data modeling, data warehousing, and data governanceStrong understanding of business processes around master data management in a B2B setupStrong Experience with Databricks, Unity Catalog, and cloud environments (Preferable Azure) is must.Background in data governance and data quality conceptsStrong understanding of data normalization, denormalization, dimensional modeling, warehousing concepts, and schema designHands-on experience with data modeling tools such as ERwinExperienced in data profiling, data sampling, and data conversion exercisesExperience in Agile or Scrum environmentsStrong skills in integration, databases, data warehouses, and data processingExtensive experience in contributing to blueprinting, design workshops, and requirements gathering activitiesExperience and track record of success selling data and / or analytics software to enterprise customersStrong hands-on technical background in Big Data, streaming platforms, Databricks, Snowflake, Redshift, Spark, Kafka, SQL Server, PostgreSQL, and modern BI toolsDemonstrated ability to design and scale data pipelines and architectures in large, complex environmentsExcellent soft skills including leadership, client communication, and stakeholder management.