Tell me about one of your recent projects. Start from source discovery and explain how you implemented the data solution, including the business context. Then describe how the data moved from source to destination.

S: In my previous company we needed to provide real‑time customer insights to the marketing team. T: I was tasked with building a data pipeline from the CRM and website logs. A: I first performed source discovery by cataloguing the CRM tables and the web analytics API. I designed a Lambda‑based ingestion that pulled data every 5 minutes and stored it in S3. I then used Glue to transform the raw JSON into a cleaned silver schema, applied business rules to flag high‑value leads, and aggregated the data into a gold table in Redshift. The marketing analysts used QuickSight dashboards to view the results. R: The solution reduced the data latency from 24 hours to 5 minutes, enabling the team to launch targeted campaigns 48 hours faster. It also increased data quality scores by 15%.