Are you comfortable with data modeling? Do you understand data modeling techniques and star schemas? Have you had experience with them?

Data modeling is the process of defining the structure, relationships, and constraints of data in a database. I use Entity-Relationship (ER) diagrams for conceptual modeling, then normalize to reduce redundancy. For analytical workloads, I apply dimensional modeling, creating fact tables that store measurable metrics and dimension tables that provide context. A star schema is a common dimensional model where a central fact table is surrounded by denormalized dimension tables, enabling fast query performance. I have designed star schemas for sales and inventory systems, ensuring that each dimension has a surrogate key and that the fact table uses foreign keys to link dimensions. I also consider slowly changing dimensions (SCD) to track historical changes. My experience includes using tools like ERwin for ER modeling and dbt for building and testing star schemas in a data warehouse.