Data Analyst
The Data Analyst will support TED’s growing media and business analytics efforts with a primary focus on TED’s membership and subscription programs, including TED Membership, an initiative aimed at supporting TED’s nonprofit efforts to spread ideas far and wide.
We’re looking for a curious soul who is data-savvy, scrappy, and has an eye for the story in the numbers. Success in this role looks like translating data into insights and insights into actionable recommendations that can support marketing, engagement, creative and product teams in optimizing against acquisition, engagement and retention strategies. You should feel comfortable in both collaborative and independent settings, and have a passion for community and impact-driven initiatives.
You’ll be responsible for leveraging data to inform continued and accelerated revenue and customer growth and retention. You’ll work closely with a forecast model to set goals, monitor pacing and provide strategy recommendations. Working closely with both marketing and engagement team members, you’ll support A/B testing efforts, monitor our acquisition and engagement tactics, develop new KPIs to measure success and uncover growth opportunities, and identify ways to reduce churn and support long-term satisfaction and retention.
Responsibilities
- Manage, organize and report on all customer KPIs, including those associated with revenue and subscriber growth, churn, member satisfaction and engagement, marketing and acquisition, and member make-up
- Prepare routine reports, including weekly and monthly performance and pacing updates, along with ad hoc deep dives aimed at illuminating key facets of the Membership engine
- Create and manage dashboards for key stakeholders + executives
- Assist in development and measurement of A/B testing across the funnel, from marketing to landing page conversion
- Create forecasting models across member acquisition channels and work alongside Membership stakeholders to set goals + performance metrics, monitor pacing and make strategy recommendations
- Support reporting across qualitative methods, like member satisfaction surveys, cancellation feedback, and more
- Bring data and insights to life through data visualization, storytelling and actionable recommendations
Skills + Experience
- 3+ years experience in an analytics role for a subscription model. Must have an understanding of KPIs affiliated with all aspects of the user conversion funnel — impressions, CTR, conversion, retention — and should have some experience measuring engagement and user-level data.
- Technical:
- A deep-level of experience with a range of analytics tools, including:
- Product analytics tools such as Google Analytics or Mixpanel
- Business intelligence + analytics tools like Tableau and Stripe
- Off-platform-specific tools like Sprout Social and MailChimp
- Proficient in writing your own SQL queries
- Deep understanding of digital campaign tracking and UTM parameters
- Demonstrated understanding of various forecasting methods and their pros and cons
- Experience with analyzing and measuring results from A/B testing
- Experience with survey tools, i.e. SurveyMonkey and using qualitative data + sentiment to support a data story
- Bonus points for:
- Demonstrated proficiency with data extraction, cleaning, and visualization using R and ggplot2
- Creating dashboards in Tableau
- Querying data from a data warehouse (preferably experience with Snowflake or BigQuery)
- Managing source code via GitHub
- A deep-level of experience with a range of analytics tools, including:
- Storytelling:
- Proven ability to analyze and evaluate data, identifying the insights and takeaways that inform top-of-mind content and business decisions
- Proven success shaping reporting and deliverables with unique stakeholders’ needs in mind
- Experience with data visualization; ability to tell an engaging, clear and actionable story around data
- Exceptional communication + presentation skills
- Proven success informing strategy through data-driven recommendations and insights
- Understanding of a customer acquisition funnel, and familiarity with mapping KPIs and goals to each part of the funnel
- Ability to use qualitative data + sentiment to support quantitative data stories
- Inclusivity: Eagerness to understand the cultures, values, goals, and constraints of others, whether they are TED staff, partners, audience members, or beyond.