Data Analyst

About Medterra

Founded in 2017, Medterra has evolved from an innovative CBD start-up into a forward-thinking botanical wellness company. As experts in the industry, our mission is to empower individuals to optimize their mental and physical well-being. We combine cutting-edge natural ingredients with scientific advancements to create superior wellness solutions that are accessible to all, offering tangible results everyone can feel.

Job Summary

The Data Analyst will play a key role in driving impactful insights and fostering cross-functional partnerships across the organization. This hands-on role requires expertise in BI tools, data modeling, and SQL, and will focus on eCommerce KPIs, supply chain, and finance. The role is integral to helping the company make data-driven strategic decisions by utilizing top-tier analytics platforms and ensuring high-quality, actionable reports. This is a Temp-to-Perm position, allowing for a transition into a full-time role based on performance and business needs.

Key Responsibilities

• Analyze and report on eCommerce KPIs, including customer CAC, LTV, product affinity, and conversion optimization.
• Collaborate with cross-functional teams to deliver critical business insights and support decision-making across Marketing, Operations, and Finance.
• Build ad-hoc reports and troubleshoot data quality issues as they arise.
• Create and optimize SQL queries to work with various data formats like CSV, JSON, and XML.
• Maintain and support data integrations with external vendors and systems, including Shopify, and BigQuery.
• Help shape the company’s BI strategy and tooling by collaborating with both internal stakeholders and external advisors.

Key Qualifications & SkillsRequired

• 2+ years of experience in CPG/Retail Analytics with a focus on eCommerce, Marketing, and AdTech.
• 2+ years of hands-on experience with BigQuery and/or SQL (or equivalent).
• 1+ years of hands-on experience with Microsoft PowerBI: Well versed in DAX functions such as calculate, switch, sumx, related, filter, lookupvalue etc. Comfortable with creating and maintaining relationships between multiple data sources
• Strong knowledge of working with sensitive data and security best practices related to data access and storage.
• Bachelor's degree in Computer Science, IT, Math, Economics, Business or a relevant field.

Preferred

• Expertise in data modeling, reporting, and optimization techniques.
• Knowledge of digital media/web analytics/AdTech KPIs.

Success Metrics / KPIs

• Timeliness and accuracy of eCommerce and business insight reports.
• Performance in optimizing SQL queries and data integration processes.
• Stakeholder satisfaction with cross-functional collaboration and reporting outcomes.

Benefits

• Competitive Compensation Package including Salary, Bonus, Benefits, and Generous 401k Savings Plan with company matching
• Unlimited vacation policy that you're encouraged to use, sick time, paid holidays
• Paid parental leave
• Medical, Dental, Vision, LTD and Life Insurance
• Annual Wellness Allowance which includes Fitness, Groceries, Health, Nutrition, Spa Treatment Reimbursements
• 100% remote workforce with annual reimbursement for home office technology and equipment
• Robust Employee Assistance Program (for you and your loved ones)
• Training and Development Programs
• Generous Employee Discounts