Senior BI & Marketing Analyst

Essential Duties & Responsibilities

• Analyze customer acquisition performance across paid search, display, affiliate, and organic channels — spend efficiency, conversion rates, cost per acquisition, and cost per subscriber — and recommend optimizations to the performance marketing team.
• Build and maintain reporting on subscription funnel economics: trial starts, trial-to-paid conversion, rebill/retention, churn, and customer lifetime value by channel and campaign.
• Analyze A/B and pricing test results to guide decisions on page content, UX, offers, and pricing.
• Investigate anomalies in traffic, conversion, and revenue data; distinguish real business changes from tracking or attribution artifacts before findings reach stakeholders.
• Reporting & BI Development
• Retrieve and aggregate data from multiple sources (web analytics, ad platforms, billing/subscription systems, internal databases) into clear, actionable reporting for stakeholders at all levels.
• Design, build, and maintain automated dashboards and reporting solutions in our BI platform (Domo), migrating existing manual and legacy reporting into governed, automated pipelines.
• Automate and optimize existing manual data workflows, reducing time-to-insight and error risk.
• Partner with leadership to define key metrics, KPIs, and dashboards that measure business performance; maintain clear metric definitions and a single source of truth.

Collaboration & Planning

• Plan the reporting and analytics roadmap at a high level with business owners, then prioritize and execute the work individually and with BI contractors.
• Work with cross-functional teams (marketing, product, engineering, finance) and external agency partners on day-to-day execution of analytics projects and initiatives.
• Over time, coordinate work with BI contractors supporting platform development, reviewing output for quality and consistency.

Basic Qualifications & Skills

• 3+ years of experience in business intelligence, marketing analytics, or a comparable analytical role.
• Strong SQL skills, with experience querying and aggregating large datasets from multiple sources; experience with cloud data warehouses (Snowflake preferred).
• Hands-on experience building dashboards and automated reporting in a modern BI platform; Domo experience strongly preferred (Power BI, Tableau, or Looker also relevant).
• Advanced Excel skills, including complex functions, pivot tables, and linked, multi-source workbooks.
• Demonstrated ability to ramp quickly on a new business, industry, and unfamiliar datasets — investigating, mastering, and documenting them with minimal guidance.
• Ability to operate at both altitudes: shape analytics priorities with leadership, then personally deliver the work end to end.
• Strong communication skills — able to present complex quantitative findings in a simple, intuitive format to executive audiences.
• Self-starter with high standards for quality, performance, and accuracy.