- Salary
- $120k – $130k/yr
- Location
- Washington, DC
- Type
- Full-time
- Department
- Engineering
- Education
- Master
- Source
- Pinpoint
Description
Analytics Engineer
Department: Sales & Marketing
Employment Type: Full Time
Location: Washington, DC
Compensation: $120,000 - $130,000 / year
Description
About the Role
What You'll Do
- Establish the foundations, metrics, and reporting standards that will shape how the company uses data as we continue to grow.
- Establish best practices for analytics, documentation, and data governance that enable our analytics capabilities to scale alongside the business.
- Build and maintain integrations between Snowflake and third-party platforms to ensure reliable, scalable access to business data.
- Audit existing data sources and ingestion pathways across Snowflake, Substack, web/app analytics, financial systems, and marketing platforms.
- Design and maintain a source-of-truth schema spanning subscriber, engagement, revenue, and product data.
- Build and refine ingestion and transformation pipelines using Snowflake SQL (and adjacent tooling).
- Partner with Growth, Finance, Editorial, and external platform partners to answer the company’s highest-priority business questions.
- Analyze subscriber acquisition, retention, churn, engagement, and lifetime value to identify opportunities for consumer revenue growth.
- Design measurement frameworks and analytics to support pricing strategy, promotional campaigns, subscription offers, and experimentation.
- Build the reporting and data architecture needed to evaluate A/B tests, pricing changes, and new growth initiatives.
- Measure the effectiveness of marketing campaigns, promotional offers, lifecycle programs, and acquisition channels.
- Develop dashboards and executive reporting that provide timely visibility into business performance and key growth metrics.
- Perform ad hoc analyses that uncover opportunities to improve revenue, engagement, and operational efficiency.
- Develop scalable audience and content taxonomies that improve targeting, personalization, reporting, and subscriber experiences across our products.
About You
- 6+ years of hands-on experience across analytics engineering, data engineering, or analytics, ideally within subscription media, digital media, or B2C businesses.
- Strong SQL skills and experience working with Snowflake.
- Experience with modern ELT tools such as dbt, Fivetran, or equivalent technologies.
- Experience building dashboards and self-service reporting in Metabase or similar BI platforms.
- Experience designing subscriber attribution, cohort analyses, and LTV, retention, or churn models.
- Experience supporting consumer revenue growth through pricing, experimentation, lifecycle marketing, or subscription optimization.
- Demonstrated ability to leverage AI tools to automate analytics workflows, accelerate insight generation, and improve the efficiency and quality of reporting and decision-making.
- Excellent communication skills and the ability to translate complex data into actionable insights for technical and non-technical stakeholders.
- A builder’s mindset, an entrepreneurial spirit, and excitement about establishing the analytics foundation for a fast-growing business.
What We Offer
- Full employer-sponsored health plans
- 401(k) plan with employer match
- Generous vacation and paid time off
- Commuter benefits and Employee Assistance Program