- 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 & Qualifications :

- 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.

- Exposure to DevOps/CI-CD pipelines, AI/ML, Gen AI, NLP, and polyglot programming is a plus.

- Familiarity with data governance tools (e.g., ORION/EIIG).

- Domain knowledge in Retail, Manufacturing, HR, or Finance preferred.

- Excellent written and verbal communication skills.

Certifications (Preferred) :

- AWS Certification (e.g., AWS Certified Solutions Architect or Data Analytics Specialty)

- Data Governance or Data Modeling Certifications (e.g., CDMP, Databricks, or TOGAF)