This job has expired

This position was posted on October 15, 2025 and is likely no longer accepting applications. We've kept it here for historical reference. Check out the similar jobs below!

Senior Business Intelligence Analyst

ActiveCampaign, LLC

Job Overview

Location

Chicago

Job Type

Full-time

Full Job Description

📋 Description

• Own the end-to-end analytics lifecycle—from raw data in Snowflake to board-level insights—ensuring every metric is accurate, timely, and tied to ActiveCampaign’s strategic goals.
• Serve as the go-to strategic consultant for VPs and executives, translating open-ended business questions into rigorous analytical plans, then delivering crisp narratives that drive multi-million-dollar decisions.
• Design and maintain scalable, self-service dashboards in Looker/Tableau/QuickSight that democratize data across Sales, Marketing, Finance, and Customer Success, cutting ad-hoc request volume by 30% within your first six months.
• Engineer robust data models that power critical financial KPIs—ARR, net revenue retention, churn cohorts, GAAP revenue recognition—while instituting automated validation checks that raise data-trust scores above 95%.
• Lead exploratory deep-dives using statistical inference, predictive modeling, and emerging LLM techniques to uncover hidden levers for growth, cost savings, and customer experience improvements.
• Champion data governance: author clear documentation, set SLAs, and mentor junior analysts on SQL best practices, turning Snowflake into the single source of truth for 900+ global employees.
• Partner cross-functionally to define OKRs, design A/B tests, and measure experiment outcomes, ensuring every initiative has a quantifiable impact on pipeline velocity and customer lifetime value.
• Continuously integrate AI agents and automation into your workflow—think anomaly detection bots, natural-language query interfaces, and auto-generated executive briefings—freeing you to focus on higher-order strategy.
• Present findings in compelling visual stories that resonate with both technical and non-technical audiences, translating complex regressions into three-bullet takeaways that executives can act on immediately.
• Stay ahead of the curve: evaluate new tools, prototype in dbt or Python, and share learnings through lunch-and-learns, elevating the entire BI practice at ActiveCampaign.

🎯 Requirements

• 3–5 years in BI, analytics, or data science roles with a proven record of influencing executive decisions through data.
• Expert-level SQL (2+ years) and hands-on experience modeling data in cloud warehouses (Snowflake preferred).
• Advanced proficiency in at least one modern BI visualization stack: Looker, Tableau, or QuickSight.
• Demonstrated ability to simplify complex analyses into clear, actionable insights for non-technical stakeholders.
• Experience integrating AI/ML techniques or AI agents into analytics workflows is a strong plus.
• Familiarity with SaaS financial metrics—ARR, GAAP revenue, retention modeling—is highly desirable.

🏖️ Benefits

• Comprehensive health & wellness: fully-covered HDHP, free telehealth, and Calm subscription for mental fitness.
• Unlimited open PTO to recharge and maintain work-life balance.
• 401(k) with immediate vesting, quarterly commuter or remote-work stipends, and a four-week paid sabbatical after five years.
• LinkedIn Learning + internal development programs to accelerate your career in a hyper-growth environment.
• Collaborative, inclusive culture backed by active ERGs and a commitment to diversity, equity, and innovation.

Skills & Technologies

Senior

Remote

Ready to Apply?

Apply Externally

You will be redirected to an external site to apply.

ActiveCampaign, LLC

Visit Website

About ActiveCampaign, LLC

ActiveCampaign provides cloud-based customer experience automation software that unifies email marketing, marketing automation, sales automation, and CRM for small to mid-size businesses. Its platform enables personalized campaigns across email, web, SMS, and social channels, leveraging machine learning to segment audiences, trigger workflows, and score leads. Founded in 2003, the company serves over 180,000 customers in 170 countries, integrating with more than 870 third-party applications to consolidate customer data and automate engagement throughout the lifecycle.

View Company Profile