Emorphis Technologies - Senior Data Modeler - Erwin

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.

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

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