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