Sr. Data Modeler/Data Analyst - Bangalore

Sr Data Modeler
Location - Bangalore
Experience - 5+ years

This individual will be responsible for designing and creating enterprise-grade data models and driving

the implementation of Layered Scalable Architecture or Medallion Architecture to support robust,

scalable, and high-quality data marts across multiple business units.

This role will involve managing 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.

Global Presence: US - UK -UAE - IND - SGP | www.exponentia.ai | engage@exponentia.ai

• 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, purpos 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.

Job Types: Full-time, Permanent

Application Question(s):

• What is your notice period (in days)?

Experience:

• Data governance: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)
• AWS Glue: 1 year (Preferred)

Work Location: In person