Senior Data Modeler

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:

• Bachelors or master's degree in computer science , IT, or related field(B.E./B.Tech/M.E./M.Tech/MCA).
• Minimum 5 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.