Lead Content Analyst Jobs

About Shopify
Opportunity is not evenly distributed. Shopify puts independence within reach for anyone with a dream to start a business. Since 2006, we’ve grown to over 10,000 employees and generated over $496 billion in sales for millions of merchants in 175 countries.
This is life-defining work that directly impacts people’s lives as much as it transforms your own. This is putting the power of the few in the hands of the many, is a future with more voices rather than fewer, and is creating more choices instead of an elite option.
About The Role
The Content Management team is the bridge between our content production teams and teams that need content. A primary responsibility is reporting on the impact of what we produce, then using that data to inform planning.
The Lead Content Analyst uses technical skills—especially SQL—to build and manage reports to track the:

• Impact of each content type on merchant acquisition;
• Production costs for each type of content;
• Resultant ROI for each type of content.
• Revenue associated with those merchants;

This work includes close collaboration with:

• Data science, for performance measurement;
• Finance, for spend and revenue measurement;
• Growth Labs, for tooling.

Job responsibilities

• Serve as the primary point of contact for questions about content performance.
• Collaborate with analysts on data science and finance teams
• Conduct, refine, and develop analyses to identify ways to get more value from every type of content we produce.
• Use SQL and other programming languages to build always-on reports for the cost and revenue of all types of content produced.
• Connect funnel data (e.g., leads, customers) to finance data (e.g., spend, revenue) and content-performance data (e.g., impressions, rankings).
• Manage our framework for reporting, including recommending adjustments or improvements to our KPIs and targets.

Qualifications

• Naturally curious and a “learn by doing” mentality
• Estimate impact from content sources with limited or complex attribution (e.g., podcast, long sales cycles)
• Focus on improving, not just executing, processes
• Bizible, to manage enterprise performance data
• Nice to have:
• Ability to execute tasks independently and efficiently—and to find new efficiencies
• Knowledge of or Interest in content marketing and SEO
• Google Sheets, including advanced skills to move data in and out of sheets to other reporting software, and to manage complex formulas within Sheets (e.g., lookups, pivot tables, if statements)
• Strong analytical skills
• SQL, including advanced skills such as cross-table joins, subqueries, CTEs, and windows functions, to build and edit reports in Mode
• Essential:
• Technical skills to create and manage reports on content performance
• Google Data Studio, to visualize data from Google Tables and Sheets
• Translate complex data into concise, SLT-friendly reports

All your information will be kept confidential according to EEO guidelines.