Senior Data Modeler

As a Sr Data Modeler in Bangalore with 5+ years of experience, your primary role will involve designing and creating enterprise-grade data models. You will be responsible for driving the implementation of Layered Scalable Architecture or Medallion Architecture to support robust, scalable, and high-quality data marts across multiple business units. Additionally, you will manage complex datasets from systems like PoS, ERP, CRM, and external sources. Key Responsibilities: - Design and deliver conceptual, logical, and physical data models using tools like ERWin. - Implement Layered Scalable Architecture / Medallion Architecture for building scalable, standardized data marts. - Optimize performance and cost of AWS-based data infrastructure (Redshift, S3, Glue, Lambda, etc.). - Collaborate with cross-functional teams (IT, business, analysts) to gather data requirements and ensure model alignment with KPIs and business logic. - Develop and optimize SQL code, materialized views, stored procedures in AWS Redshift. - Ensure data governance, lineage, and quality mechanisms are established across systems. - Lead and mentor technical teams in an Agile project delivery model. - Manage data layer creation and documentation: data dictionary, ER diagrams, purpose mapping. - Identify data gaps and availability issues with respect to source systems. Required Skills: - Minimum 3 years of experience in data modeling and architecture. - Proficiency with data modeling tools such as ERWin, with strong knowledge of forward and reverse engineering. - Deep expertise in SQL (including advanced SQL, stored procedures, performance tuning). - Strong experience in data warehousing, RDBMS, and ETL tools like AWS Glue, IBM DataStage, or SAP Data Services. - Hands-on experience with AWS services: Redshift, S3, Glue, RDS, Lambda, Bedrock, and Q. - Good understanding of reporting tools such as Tableau, Power BI, or AWS QuickSight. As a Sr Data Modeler in Bangalore with 5+ years of experience, your primary role will involve designing and creating enterprise-grade data models. You will be responsible for driving the implementation of Layered Scalable Architecture or Medallion Architecture to support robust, scalable, and high-quality data marts across multiple business units. Additionally, you will manage complex datasets from systems like PoS, ERP, CRM, and external sources. Key Responsibilities: - Design and deliver conceptual, logical, and physical data models using tools like ERWin. - Implement Layered Scalable Architecture / Medallion Architecture for building scalable, standardized data marts. - Optimize performance and cost of AWS-based data infrastructure (Redshift, S3, Glue, Lambda, etc.). - Collaborate with cross-functional teams (IT, business, analysts) to gather data requirements and ensure model alignment with KPIs and business logic. - Develop and optimize SQL code, materialized views, stored procedures in AWS Redshift. - Ensure data governance, lineage, and quality mechanisms are established across systems. - Lead and mentor technical teams in an Agile project delivery model. - Manage data layer creation and documentation: data dictionary, ER diagrams, purpose mapping. - Identify data gaps and availability issues with respect to source systems. Required Skills: - Minimum 3 years of experience in data modeling and architecture. - Proficiency with data modeling tools such as ERWin, with strong knowledge of forward and reverse engineering. - Deep expertise in SQL (including advanced SQL, stored procedures, performance tuning). - Strong experience in data warehousing, RDBMS, and ETL tools like AWS Glue, IBM DataStage, or SAP Data Services. - Hands-on experience with AWS services: Redshift, S3, Glue, RDS, Lambda, Bedrock, and Q. - Good understanding of reporting tools such as Tableau, Power BI, or AWS QuickSight.