PART A. MATCH TABLE | # | Requirement from the post | Match | Proof | Question or fact to add | |---|---|---|---|---| | 1 | Build weekly sales dashboards in Looker or Tableau | Partial | R2, R9 | Your weekly report (R2) is in Google Sheets and you list Looker Studio (R9), which is not the same product as Looker. Have you built a Looker Studio dashboard that someone else opened every week? If yes, add it as a fact with who used it. | | 2 | Write SQL to pull order and traffic data | Strong | R3, R9 | | | 3 | Analyze A/B tests on product pages | Gap | none | Have you compared two versions of anything and measured the difference, at work or in the certificate course (R8)? If yes, add what you compared and the result. | | 4 | Present findings to the merchandising team | Partial | R2, R6 | Your report reached 3 regional managers (R2) and you flagged slow sellers to a store manager (R6). Did you ever walk a group through your numbers in a meeting? If yes, add who and how often. | | 5 | Excel or Google Sheets | Strong | R2, R4, R9 | | | 6 | Python is a plus | Partial | R9 | You list basic Python (pandas). What did you use it for? One real task, such as cleaning a shipment export, would make this Strong. | | 7 | 1 to 2 years of analytics experience | Partial | R1, R2, R3, R4 | Your title is Operations Assistant (R1), not analyst. Roughly what share of your week goes to reporting and SQL? A line such as "about half of my week is reporting" helps if it is true. | Strongest matches used below: SQL (R3), Google Sheets reporting (R2, R4). PART B. SUMMARY (limit 50 words) Operations assistant applying for the Junior E-commerce Data Analyst role. I write SQL in BigQuery for monthly shipment reviews, built a weekly delay report in Google Sheets used by 3 regional managers, and cut manual reporting from 6 hours to 2 hours a week. B.A. Economics; Google Data Analytics Certificate. Word count: 50 PART C. BULLETS Operations Assistant, Brightline Logistics (Mar 2024 to present) - Built a weekly delivery-delay report in Google Sheets used by 3 regional managers. (R2) - Wrote SQL queries in BigQuery to pull shipment data for the monthly review. (R3) - Cut manual reporting time from 6 hours to 2 hours a week by automating a Sheets import. (R4) Retail Associate, Oakridge Outfitters (Jun 2022 to Feb 2024) - Tracked weekly sell-through for 40 SKUs and flagged slow sellers to the store manager. (R6) Education and certificate - Earned the Google Data Analytics Certificate in 2023. (R8) Only five bullets: your facts support five. A sixth would need a new fact, for example the Looker Studio dashboard in row 1 or the comparison in row 3, if either is true. Current bullets dropped: - "Responsible for reports": says what you were assigned, not what you built. Replaced by R2. - "Helped managers with data": no number, no tool. Replaced by R2 and R6. - "Did inventory tasks at retail store": vague. Replaced by R6, which names the 40 SKUs. - "Strong Excel skills": an adjective with no proof. Excel moves to your skills line (R9). PART D. KEYWORDS Found in your facts: - SQL (R3, R9) - Google Sheets (R2, R4, R9) - Excel (R9) - Python, basic pandas (R9) Missing (not added to the summary or bullets): - Looker (you list Looker Studio, a different product; do not write Looker unless you have used it) - Tableau - Dashboards (your facts say report, not dashboard) - A/B tests - Traffic data (your SQL facts are about shipment data) PART E. COVER LETTER (limit 150 words) Dear Fernway hiring team, I am applying for the Junior E-commerce Data Analyst role because I already spend my weeks turning raw operations data into reports people act on, and I want to do that for product and sales decisions. At Brightline Logistics I write SQL in BigQuery to pull shipment data for our monthly review (R3), and I built a weekly delivery-delay report in Google Sheets that 3 regional managers use (R2). Before that, I tracked weekly sell-through for 40 SKUs and flagged slow sellers to my store manager (R6), so I know how merchandising numbers look from the shop floor. I would welcome the chance to show how I can support your merchandising team with clear weekly numbers. Sincerely, Your Name Word count: 123 PART F. INTERVIEW PREP Row 1, dashboards Q: Walk me through a dashboard you built. Outline: Describe the weekly delay report (R2): the data it pulls, who uses it (3 regional managers), and the decision it supports. Say plainly it is in Sheets and that you have used Looker Studio (R9). Row 3, A/B tests Q: How would you read the result of a product-page test? No fact: prepare an honest example. Row 4, presenting Q: Tell me about sharing findings with a non-technical team. Outline: The slow-seller flags to your store manager (R6): what you saw in sell-through, how you raised it, what the manager did next. Row 6, Python Q: What have you done in Python? Outline: Say you have basic pandas (R9). Name one task you have really done with it; if none, say you use SQL and Sheets for the same jobs today (R3, R4). Row 7, experience Q: Your title is operations. How much of it is analytics? Outline: Point to the SQL review (R3), the weekly report (R2) and the 6-to-2-hour automation (R4) since Mar 2024 (R1). PART G. LINT | Phrase | Where | Problem | Fix | |---|---|---|---| | "Results-driven" | Current summary | On your avoid list; vague claim | Removed. The summary leads with the SQL and reporting facts instead. | | "team player" | Current summary | Vague claim | Removed. R2 (a report 3 managers use) shows the same thing with proof. | | "passionate about data" | Current summary | On your avoid list; vague claim | Removed. | | "Strong Excel skills" | Current bullets | Unverified adjective | Moved Excel to the skills line (R9) without the adjective. | | "Looker" | Job post vs. your facts | You list Looker Studio, not Looker | New text says Looker Studio only in the interview outline; never write Looker on the resume. | New text: no claims outside R1 to R9.