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:

• Bachelor’s 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.

Mandatory Skills

Data Warehousing, Data Modeling, ERwin, Data Governance, SQL

Job Type: Contractual / Temporary
Contract length: 6 months

Pay: ₹75,000.00 - ₹1,250,000.00 per month

Work Location: In person