Full Time
400$ / mo
32
Dec 20, 2024
Job Title: E-Commerce Operations Analyst
Job Description:
We are seeking a detail-oriented and highly organized E-Commerce Operations Analyst to oversee our daily order management and financial reporting processes. This role ensures that our cost structures, supplier pricing, and store profitability are meticulously tracked and maintained.
Responsibilities:
1. COGS and Invoice Verification:
- Ensure consistent Cost of Goods Sold (COGS) on each invoice.
- Verify suppliers are charging fair and accurate prices, preventing overcharges.
- Cross-check invoices against supplier quotes.
2. Pricing Management:
- Maintain a strict COGS threshold: COGS must not exceed 35 percent of the selling price.
- Adjust product prices as needed to meet profit margins.
- Monitor products sold more than five times without proper pricing and follow up with suppliers.
3. Daily Reporting:
- Generate and submit daily financial reports to the CEO, including:
- Total revenue
- Total COGS
- Ad spend
- Profit margins (ensure BER is 1.6 or lower).
- Provide both store-level and overall company financial snapshots.
4. Data Management:
- Update COGS sheets, profit sheets, and store metrics daily.
- Flag discrepancies and new product entries for pricing validation.
- Identify products or suppliers requiring follow-up.
5. Process Improvement:
- Streamline workflow to improve daily reporting accuracy and timeliness.
- Collaborate with team members to resolve pricing or supplier issues.
Key Performance Indicators (KPIs):
- Maximum COGS of 35 percent across all products
- Maximum BER of 1.6
- Accurate invoice checking and reporting
- Daily updates of store metrics and financial data
Requirements:
- Proven experience in e-commerce operations, supply chain management, or financial reporting
- Proficiency in Excel or Google Sheets for data analysis and reporting
- Strong analytical skills and attention to detail
- Ability to work independently and meet daily deadlines
- Excellent communication skills for reporting and follow-ups
What We Offer:
- A dynamic role in a fast-growing e-commerce company
- Opportunities for professional growth and process leadership
- Competitive salary based on experience
How to Apply:
If you have a passion for e-commerce analytics and a keen eye for numbers, we’d love to hear from you. Send your resume and a brief cover letter outlining your relevant experience to
Workflow - Step by Step Process
1. Step 1: Go to the store’s Partner or Invoice channels, download invoices for each order, and open them in Shopify for verification.
2. Step 2: Check the COGS for each order to ensure they align with the COGS sheet.
3. Step 3: Verify that each product has a COGS that is a maximum of 35 percent of the selling price. Adjust product pricing if necessary.
4. Step 4: Monitor and address products that have incorrect pricing or require supplier invoice verification if sold more than five times.
5. Step 5: Create a daily report of total revenue, COGS, and profitability across all stores, and send it to the CEO.
6. Step 6: Create individual reports for each store, including:
- Total revenue
- Total COGS
- Ad spend
- Transaction fees
- Refund amounts
- Profit margin (ensure BER is 1.6 or lower)
7. Step 7: Update the COGS and Profit Sheets with the latest data.
8. Step 8: Review and validate new product entries and update pricing accordingly.
9. Step 9: Rinse and repeat this workflow every day.
By following these steps, you will ensure accuracy in reporting, optimized pricing strategies, and improved store profitability.
Kind regards,
Umut