Job Description

We are seeking a Data Operations & Analytics Engineer to own the accuracy and availability of our business data. This is a role for a builder who loves dirty data as much as clean insights.Your primary mission is to build the "Source of Truth". You will engineer the pipelines that move data from our e-commerce and ad platforms into BigQuery (or an alternative data lake), and you will specifically lead the critical project of systematizing our financial data – ensuring every dollar in Shopify matches every dollar in QuickBooks. Once the data is clean, you will build the dashboards that drive our product and marketing strategy.

Responsibilities:
  • E-commerce Reconciliation: Automate the flow of transactional data from Shopify, payment processors and other software into QuickBooks or alternative bookkeeping software.
  • Complex Mapping: Write logic to correctly categorize Gross Sales, Refunds, Shipping Income, Taxes, and Gateway Fees so our P&L is generated automatically and accurately.
  • Inventory Reconciliation: Ensure COGS (Cost of Goods Sold) data flows correctly from our inventory systems (Finale/ShipStation) into our financial reporting.
  • Pipeline Management: Design, build, and maintain ETL pipelines to ingest data into Google BigQuery from various sources (Meta Ads, Google Ads, TikTok, Klaviyo, etc.).
  • Cloud Architecture: Utilize Google Cloud Platform (Cloud Functions, Cloud Scheduler) to automate data refreshes and transformation jobs.
  • Data Quality Assurance: Implement automated tests to catch data discrepancies. If the numbers break, you are the first to know and the one to fix it.
  • Product Analysis: Analyze lifecycle metrics for our brands. Identify trends in seasonality, repeat purchase rates, and product affinity (cross-selling opportunities).
  • Dashboarding: Build and maintain high-utility dashboards (Looker Studio/Tableau) for Finance, Marketing, and Support.Ad-Hoc Analysis: Answer complex business questions via SQL (e.g., "What is the LTV of customers who bought Product X in Q4?").
Required Qualifications:
  • You must understand e-commerce finance. You know the difference between an Order Date and a Settlement Date, and you understand how COGS impacts Net Profit.
  • Ability to create clear, actionable visualizations that stakeholders can understand without explanation.
  • Attention to Detail: You are bothered when numbers don't add up, and you don't stop until you find the variance.
Benefits:
  • Paid days off, medical insurance, yearly bonus, wellness benefits, and referral bonuses.
  • A collaborative, supportive environment where your ideas and professional growth are highly valued.
Skills:
  • Advanced SQL and Python (Pandas/Dataframes) are essential.
  • Experience with Google Cloud Platform (BigQuery) and modern ETL tools.
Technologies:
  • SQL
  • Python
  • Google Cloud Platform
  • BigQuery
  • Shopify
  • QuickBooks
  • Looker Studio
  • Tableau
Note:

✨ Our intelligent job search engine discovered this job and republished it for your convenience.
Please be aware that the job information may be incorrect or incomplete. The job announcement remains the property of its original publisher. To view the original job and its full details, please visit the job's URL on the owner’s page.