Senior BI, Marketing Analyst

Stellenbeschreibung:

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.
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.
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.

Requirements

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.

Core Competencies

Expertise in business intelligence and marketing analytics, with strong SQL skills for data querying and aggregation. Proficient in building automated reporting solutions and dashboards using Domo, while effectively communicating complex data insights to stakeholders.