Core Responsibilities
- Data Cleaning & Processing: Filtering out errors, handling missing values, and restructuring raw feeds using Python libraries like Pandas to ensure analytical accuracy.
- Database Architecture: Writing complex SQL queries with CTEs and stored procedures, or designing normalized star schemas to organize disparate data sources.
- Visualization & BI: Building interactive dashboards in Tableau, ensuring backend calculations (like aggregating with SUM rather than row-level averages) maintain proper dynamic filtering.
Typical Market Deliverables
- Automated Pipelines: Custom scripts that routinely extract, process, and clean data from web sources or APIs.
- Performance Dashboards: Visual reports highlighting retail product performance, profitability, and high-level metrics using Matplotlib, Seaborn