Ghost is looking for a Senior Data Analyst to help scale how data supports decision-making across the business, focusing on empowering the Revenue, Business Operations, and Finance & Accounting departments. The role will involve building core reporting frameworks, including forecasting and tiering models, to drive growth strategy and transform raw data into actionable insights.
Requirements
- Proven expertise in SQL and BI tools (Metabase, Looker, Tableau, or similar).
- Hands-on experience with modern data warehouses (Snowflake, BigQuery, Redshift).
- Strong track record of building data models, dashboards, and reports that directly inform business strategy.
- Write advanced SQL (joins, CTEs, window functions) across complex, multi-source and raw datasets.
- Design and model fact/dimension tables and presentation datasets and deliver models to Data Engineering.
- Design and model tables in Metabase’s semantic layer to be used by non-technical stakeholders for self-service (similar to LookML).
- Comfortable working with raw or loosely modeled data.
Responsibilities
- Build and own reporting frameworks for Revenue and Business Operations, including forecasting and tiering logic.
- Develop impactful dashboards in BI tools (Metabase) to surface insights.
- Write advanced SQL (joins, CTEs, window functions) across complex, multi-source and raw datasets.
- Design and model fact/dimension tables and presentation datasets and deliver models to Data Engineering.
- Design and model tables in Metabase’s semantic layer to be used by non-technical stakeholders for self-service (similar to LookML).
- Lead QA and validation processes to ensure trust and accuracy in reporting.
- Partner with Finance to reconcile and automate key reporting in Metabase and Google Sheets.
Other
- 5+ years in an analytics or data-focused role.
- Familiarity with revenue, sales, or finance analytics is a strong advantage.
- Strong communication and visual storytelling skills for business audiences.
- Ability to translate broad, ambiguous questions into structured analysis.
- High attention to detail, ownership mindset and thrives in a start-up environment
- This role will work out of our Los Angeles office, minimum 3 days per week
