Description
You will design and develop conceptual, logical, and physical data models for OLTP, ODS, and Data Warehouse systems.
This role is on-site.
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
- 13+ years of professional experience in data modeling.
- Strong expertise in Data Modeling methodologies (Inmon & Kimball).
- Hands-on SQL skills including DDL, DML, and query optimization.
- Experience with Data Warehousing and Cloud Technologies.
- Proficiency with Erwin Data Modeler.
- Experience with AWS services.
- Any Graduate education.
Preferred Skills
- 2+ years tenure in previous roles.