Description

You will design and develop conceptual, logical, and physical data models for OLTP, ODS, and Data Warehouse systems.

Responsibilities

• Design and develop conceptual, logical, and physical data models for OLTP, ODS, and Data Warehouse systems.
• Create and maintain data dictionaries, metadata, and governance processes.
• Develop data pipelines on AWS using Glue, DBT, and Fivetran (HVR).
• Optimize complex SQL queries, stored procedures, and database objects for performance.
• Collaborate with business teams, engineers, and executives to translate requirements into effective data models.

Required Skills

• Strong expertise in Data Modeling (Inmon & Kimball).
• Hands-on SQL skills (DDL, DML, query optimization).
• Experience with Data Warehousing and Cloud Technologies.
• Proficiency with Erwin Data Modeler.
• Experience with AWS.
• 13+ years of professional experience required.

Key Skills

Education

Any Graduate