[Hiring] Senior Data Analyst @Activate Talent

Role Description

In your first phase, you will act as a senior analytics partner to Growth, Product, and Lifecycle teams. You will translate ambiguous questions into structured analysis, deliver clear recommendations, and help shape experimentation and channel strategy. As you ramp, you will assume greater ownership of the analytics layer in our modern data stack. This includes:

• Designing, refactoring, and maintaining dbt models that define our core business metrics.
• Improving metric consistency across BI tools.
• Strengthening the reliability and scalability of reporting.

You will collaborate closely with Data Engineering (pipeline and infrastructure) and Data Science (advanced modeling and forecasting), while owning the analytical semantic layer that connects raw data to decision-making.

Qualifications

• 5–8 years of experience in analytics, business intelligence, or a related quantitative role, at least 2+ years supporting eCommerce or DTC businesses.
• Advanced SQL proficiency (Snowflake preferred) with the ability to independently build complex queries and analytical datasets.
• 3+ years of hands-on experience in growth or marketing analytics, including paid media performance analysis and customer acquisition economics.
• Experience working with web or product analytics tools (Amplitude or similar) to analyze funnel and behavioral data.
• Demonstrated experience designing and analyzing experiments (A/B testing, CRO).
• 2+ years of experience working with dbt or similar transformation frameworks, with practical understanding of dimensional modeling and metric layer design.
• Experience building and maintaining dashboards in BI tools (Looker or Omni preferred).
• Proven ability to independently manage ambiguous requests and translate them into structured analyses.
• Strong written communication skills in a remote, asynchronous environment.
• Ability to provide partial overlap with US Eastern Time for key alignment meetings (full-day overlap not required).

Requirements

• Own growth and lifecycle analytics across paid acquisition, web funnel, and retention.
• Analyze Shopify, Amplitude, and marketing channel data to surface actionable insights that influence budget allocation and experimentation strategy.
• Lead experimentation analysis (A/B testing, conversion rate optimization, landing page performance).
• Develop and maintain executive-ready dashboards and reporting in Looker (with migration to Omni underway).
• Partner with stakeholders to define clear success metrics and ensure decisions are grounded in consistent definitions.
• Design, refactor, and maintain core data marts in dbt to ensure metric consistency and scalable reporting.
• Standardize key business definitions (e.g., CAC, LTV, retention, repeat rate) and enforce alignment across teams.
• Improve data quality through QA, reconciliation, and proactive anomaly detection across marketing, commerce, and attribution sources.
• Collaborate with Data Engineering on upstream model design and with Data Science on downstream analytical use cases.
• Contribute to the evolution of our analytics layer as the company scales.

Company Description