ECommerce Data Analyst

dbrand

18h•$60,000 - $70,000

About The Position

The Role It's Wednesday morning and the entire internet is glued to their screens. What's the occasion? The largest smartphone manufacturer in the world is livestreaming the announcement of their latest devices. You've known about them for months now, but that hasn't stopped you from tuning in - where else are you going to see a Senior VP of Software Engineering travel at warp speed around a CGI campus? With each passing announcement, the product catalogue you've spent weeks QA-testing snaps into focus. New SKUs configured, sale pricing validated, order flows stress-tested everything's going according to plan. At the eleventh hour, a wrench in the system: a new smartwatch. A product nobody saw coming, and certainly nothing your marketing feeds were built around. Are the product data feeds pulling the right attributes? Do the upsell and cross-sell app configurations need updating? What does the post-purchase funnel look like for a brand-new accessory category with zero historical data to lean on? The answers to these questions hinge upon your work. Without missing a beat, you've pulled up your dashboards, kicked off a few SQL queries, and started combing through Shopify to make sure the infrastructure can actually support what the business needs all while keeping one eye on what the internet's peanut gallery is saying about the surprise announcement. By the end of the day, the data tells a clear story: a new AB test scoped for the post-purchase funnel, a product feed updated and verified for accuracy, and a fresh dashboard briefed and ready for stakeholder sign-off. The curveball has been caught, documented, and turned into an opportunity. Not only are we moving fast, we're moving with confidence, because the data holding everything together is clean, current, and trustworthy. None of this would have been possible without the sharp instincts and technical depth of our ECommerce Data Analyst. Does this sound like your Wednesday? Of course not. You don't work here... yet. Want to change that? Keep reading. The Environment Still here? Excellent. dbrand thrives where other eCommerce companies have failed because our customers enjoy a revolutionary degree of commitment, engagement, and accessibility from us. Maintaining an internal culture of excellence, the likes of which our highly-engaged audience demands and deserves, is critical to dbrand's current and future success. Our customers deserve no less than the absolute best, and we hold every member of the team to that exacting standard. So, what's in it for you? Well, unlike most companies, we actually care about the work we're doing. Every time our customers tweet about us, post on our subreddit, or write an adoring email, we're moving one step closer to world domination. Spreading the good word and growing our cult-like audience? That's its own reward. At dbrand, you have the opportunity to create once-in-a-lifetime brand experiences for consumers. If you're someone who's organized, committed, and excited about our mission, to say you'd thrive here would be an understatement. Before you can get the opportunity to join our passionate, dynamic team and help us grow the cult, you'll need to prove yourself. Let’s see if you’ve got what it takes… The Characteristics Agile: You’re nimble. You’re adaptable. You thrive in an environment where priorities can change in an instant. Analytical: Your decisions are driven by only one thing: data. You continue to master all the tools necessary to surface insights. Collaborative: You enjoy purposeful meetings. You value the contributions and perspectives of your CEO as much as you do your coworkers. Curious: You’re eager to learn new concepts and master new skills. There’s no tool that’s useless in your arsenal. Disciplined: You never allow the details to slip, understanding that every bit of minutiae forms the bigger picture. Enthusiastic: You exhibit a contagious passion for digital marketing. Innovative: You develop new approaches to complex problems. Perfectionist: You persist until the smallest detail has been optimized. Knows nothing less than 100%. Persistent: You’ve never failed. You’ve only experienced speed bumps on your path to success. Reliable: You live up to both verbal and written agreements. You can be trusted to work effectively, without oversight.

Requirements

A degree in Business Admin or Analytics, or 2 years' experience in a data analytics role
Strong foundational knowledge of DTC eCommerce businesses.
Advanced knowledge of Google Sheets and SQL.
Technical expertise regarding data models, database design development, data mining, and segmentation techniques.
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
Adept at queries, report writing, and presenting findings.
A robust communication style - you have exceptional written and verbal communication skills.

Nice To Haves

Working experience with databases such as SQL and data processes such as ETL frameworks is an asset.

Responsibilities

eCommerce Data Maintenance Configure and maintain Shopify application infrastructure, not limited to Marketing apps (coupons, channels, upsells), CX apps (help desk, customer data, tagging), Shipping (rates, availability rules), and Shopify automations (Fraud Prevention, Flow).
Work with other departments to collect and assess if data needs are being met, or if new solutions and opportunities would better serve those departments.
Collect and communicate requirement scoping to be prioritized with the data team and other departments.
eCommerce data and merchandising QA testing at major launches and catalogue changes (i.e. sale pricing, new product configurations, order flows, etc.)
Marketing Support Support product data feeds and catalogues, performing regular checks for feed accuracy and relevance.
AB Testing - execute (build or coordinate) regular AB testing for marketing performance - i.e. post-purchase funnels, shipping range testing, GWP incentives, etc.
Reporting & Dashboards Own universal data accuracy by regularly reviewing for changes in data structure that could impact downstream reporting.
Create new and maintain existing marketing and interdepartmental dashboards from documenting required sources & KPIs, brief approvals, and producing the draft dashboards for testing.
Service data requests - when a specific set of customer, order, margin, performance, or product data is needed, perform ELT tasks (extract, load, transform) the relevant data for decision-making and action.