Senior Business Intelligence Analyst
ActiveCampaign
Operations, Data Science, IT
Chicago, IL, USA
Posted on Sep 20, 2025
Are you a data storyteller passionate about transforming complex information into strategic assets that drive a business forward? ActiveCampaign is seeking a Senior Business Intelligence Analyst to be a pivotal force in our Central Operations team. Your mission is to deliver critical insights that directly improve operational efficiency across the organization. You won't just be running queries; you'll be a strategic partner and internal consultant, empowering teams at every level with the clarity needed to make smarter, faster decisions. If you have a proven track record of leveraging data to create tangible business impact, this is your opportunity to shape our company's future.
On a typical day, you might:
- Act as a strategic consultant, using your analytical prowess to answer critical business questions and guide decision-making for stakeholders, including VPs and executives.
- Design and build compelling visualizations, dashboards, and reports that distill complex quantitative analyses into clear, actionable insights for audiences at every level.
- Dive deep into data exploration, leveraging cutting-edge analytical techniques—from statistical inference to machine learning and LLMs—to uncover hidden patterns and opportunities.
- Champion data integrity by owning the validation, cleanup, and governance of core datasets in our Snowflake data warehouse, ensuring accuracy and reliability across the organization.
- Collaborate cross-functionally to understand reporting requirements, define key metrics, and deliver analytical solutions that meet the evolving needs of our business units.
The ideal candidate will bring:
- 3-5 years of hands-on experience in a business intelligence or analytics-focused role, with a strong ability to answer unstructured business questions.
- At least 2 years of SQL experience, coupled with a strong understanding of data modeling concepts and data warehouse architecture.
- Proven experience with a modern data visualization tool such as Looker, Tableau, or QuickSight to build impactful reports and dashboards.
- Exceptional analytical skills, with the talent to simplify complex data into clear, actionable insights and concise recommendations.
- A forward-thinking approach to analytics, including experience integrating AI tools into daily workflows or building AI agents to automate data insights.
- Experience building complex data models for financial metrics (e.g., ARR, GAAP accounting, revenue retention) is a significant asset.
- A proactive mindset and a willingness to learn new skills and technologies on the job to stay at the forefront of the analytics field.
About ActiveCampaign:
ActiveCampaign is an AI-first, end-to-end marketing platform for people at the heart of the action. It empowers teams to automate their campaigns with AI agents that imagine, activate, and validate–freeing them from step-by-step workflows and unlocking limitless ways to orchestrate their marketing.
With AI, goal-based automation, and 950+ app integrations, agencies, marketers, and owners can build cross-channel campaigns in minutes–fine-tuned with billions of data points to drive real results for their unique business.
ActiveCampaign is the trusted choice to help businesses unlock a new world of boundless opportunities–where ideas become impact and potential turns into real results.
As a global multicultural company, we are proud of our inclusive culture which embraces diverse voices, backgrounds, and perspectives. We don’t just celebrate our differences, we believe our diversity is what empowers our innovation and success. You can find out more about our DEI initiatives here.
Perks and benefits:
At ActiveCampaign, we prioritize employees’ well-being and professional growth by cultivating a culture centered on collaboration and innovation. When you join our team, you’ll not only have the opportunity to make a significant impact, but also enjoy a range of benefits tailored to support your personal and career development.
Here are some of the benefits we offer:
-Comprehensive Health & Wellness: Top-tier benefits package that includes a fully-covered High Deductible Health Plan (HDHP), complimentary access to telehealth services, and a free subscription to Calm.
-Growth & Development: Access to LinkedIn Learning, professional development programs, and career growth opportunities in a fast-growing organization.
-Generous Paid Time Off: Recharge and take the time you need to maintain work-life balance with open PTO.
-Total Rewards: Generous 401(k) matching with immediate vesting, quarterly perks with commuter and lunch benefits for hub based employees or a stipend for remote workers, and a four-week paid sabbatical with bonus after five years.
-Collaborative Culture: Work alongside brilliant, passionate colleagues in an environment that values innovation, teamwork, and mutual support.
ActiveCampaign is an equal opportunity employer. We recruit, hire, pay, grow and promote no matter of gender, race, color, sexual orientation, religion, age, protected veteran status, physical and mental abilities, or any other identities protected by law.
Our Employee Resource Groups (ERGs) strive to foster a diverse inclusive environment by supporting each other, building a strong sense of belonging, and creating opportunities for mentorship and professional growth for their members.