ahmed samed

I've built an end-to-end analytics engineering project using the theLook eCommerce dataset, transforming raw e-commerce data into structured staging and analytical models.

I developed fact and dimension models for orders, customers, products, and related business entities using SQL, BigQuery, and dbt. My work includes joins, aggregations, filtering, type conversion, date handling, and investigating data relationships and potential duplication issues.

I applied dimensional modeling concepts such as table grain, primary keys, surrogate keys, and relationships. I also created data quality tests for uniqueness, not-null values, accepted values, and relationships.

I'm a self-directed learner who documents models and columns in dbt, manages work with Git and GitHub, and is eager to grow through practical remote entry-level data work.