Sr Business Intelligence Analyst
Aspen Technology
Houston, TX
Description
As a Senior Business Intelligence Analyst, you play a critical role in transforming data into actionable insights that empower our Sales, Customer Success and Customer Support and Training teams. You will leverage Power BI, Snowflake, and other analytics tools to create reports, dashboards, improve data quality, and drive strategic decision-making. Your expertise in business intelligence, data modeling, and visualization will help our teams optimize Sales and Customer Success performance, forecast revenue, reduce customer churn and uncover growth opportunities.
The ideal candidate will have a deep understanding of Sales & Customer Success strategy, key performance indicators (KPIs), and Objectives and Key Results (OKRs) to proactively identify opportunities for improvement. They will work cross-functionally to enhance processes, develop scalable solutions, and provide actionable insights that drive customer retention and growth. This role demands a high level of independence and thought leadership, operating as a strategic partner to leadership teams.
- Design, develop, and maintain Power BI dashboards and reports to provide real-time visibility into key sales and revenue metrics.
- Extract, transform, and analyze data from Snowflake and other sources to support business intelligence initiatives.
- Partner with Sales and Customer Success Leadership and Operational teams to define KPIs, track performance, and deliver insights.
- Build and optimize data models to ensure accuracy, efficiency, and scalability in reporting.
- Identify trends, forecast business outcomes, and provide recommendations to drive revenue growth.
- Collaborate with cross-functional teams to ensure seamless data integration and governance.
- Automate and streamline reporting processes to enhance efficiency and reduce manual efforts.
- Ensure data accuracy, integrity, and consistency across systems and reports.
- Perform complex ad hoc analysis as required in support of Sales and Customer Success Organization
- 4+ years of experience in Business Intelligence, Data Analytics, or a related field, preferably in a SaaS or sales-driven environment.
- Expertise in Power BI, including DAX, data modeling, and dashboard development.
- Experience with Snowflake (or similar cloud-based data warehouses) for data extraction and transformation.
- Familiarity with SQL for querying and analyzing large datasets.
- Deep understanding of sales performance metrics, pipeline management, customer success metrics (Customer Retention, Customer Lifetime Value, Net Promoter Score).
- Experience working with CRM data (Salesforce.com preferred)
- Strong analytical and problem-solving skills with the ability to translate data into strategic recommendations.
- Excellent communication and collaboration skills to work effectively with sales leaders and cross-functional teams.