Farah Siddiqui
Data Analyst · SQL, Power BI & Retail Reporting
Profile
Data analyst with four years in retail and logistics. Owns the weekly trading pack for a buying team, maintains the dbt models behind it, and writes the readouts for checkout and pricing tests, including the ones that come back inconclusive. SQL, Power BI and Excel daily; Python for cleaning and one-off analysis.
Professional Experience
- Took over the weekly trading pack for the buying team and replaced 23 tabs with a one-page exceptions view, so the Monday meeting now opens on the lines that moved.
- Rewrote the stock-cover query with window functions over daily snapshots instead of a self-join, which let the model refresh nightly rather than weekly.
- Found that store and online returns were recorded against different date fields, which made returns look seasonal; agreed a single definition with finance and added it to the data dictionary.
- Maintain 30 dbt models behind the trading and stock reports, with tests on keys and freshness that flag a failed load before the pack goes out.
- Wrote the readout for a checkout test on delivery options: one variant showed a small but clear improvement and was shipped; the other was recommended against because the difference sat within the noise.
- Produced the daily operations report on fleet utilisation and on-time delivery for a network of 180 vehicles.
- Moved six recurring Excel reports onto Power Query refreshes, removing the copy-and-paste step behind most of the corrections the team had to send.
- Traced a rise in failed deliveries to an address-format problem in the routing import affecting three postcodes, and handed the fix to the systems team with worked examples.
Analytical Projects
- Analysed five years of anonymised waiting-list records for a local allotment society to show which sites had the longest waits and why; the committee used it to decide where to split plots.
- Published the method and a small dashboard built on aggregated figures only, with no personal data, as a public portfolio piece.
Education
- Dissertation on seasonal adjustment methods for retail time series.