Key Responsibilities :

- Analyze, understand and translate business requirements and specifications into data models.

- Work with application teams and others to build data flows, and develop conceptual data models.

- Perform data mapping and linage documentation.

- Create logical and physical data models using best practices and company standards.

- Optimize and update logical and physical data models to support new and existing projects.

- Maintain conceptual, logical and physical data models along with corresponding metadata.

- Perform reverse engineering of physical data models from databases and SQL scripts.

- Ensure models align with enterprise architecture standards and best practices.

- Create and maintain data dictionaries, metadata, and data lineage documentation.

- Develop and maintain dimensional models (fact / dimension tables and star schemas).

Required Skills & Experience :

- 2 - 4 years of experience in database structure and data model drafting.

- Data mapping and integration.

- Strong analytical skills.

- Strong verbal and written communication skills.

- Quest erwin Data Modeling Platform.

- Experience working in Agile / Scrum delivery models.

Education :

- Bachelors of Degree in Engineering, Computer Science, or a related discipline.

Good to Have :

- Experience working on enterprise applications (Banking, Insurance, or large-scale systems).

- Experience working on Business Intelligence Reporting.