[Hiring] Senior Power BI Reporting Analyst @Lexipol

Role Description

The Senior Reporting Analyst – GTM supports Lexipol’s Sales and Marketing teams by delivering reporting, analysis, and insights on pipeline performance, sales activity, and revenue trends within a subscription-based SaaS model. This role focuses on building reliable reporting, analyzing sales funnel performance, and helping stakeholders better understand key drivers of pipeline and revenue. You will work cross-functionally to provide visibility into performance and support data-informed decision-making.

What You’ll Do

• Reporting & Analysis (60%)
  • Build and maintain Power BI dashboards that provide visibility into:
    • Pipeline health and coverage
    • Sales performance and conversion rates
    • Deal velocity and stage progression
    • ARR contribution from new business
  • Analyze end-to-end sales funnel performance, from lead through closed-won
  • Develop reporting that connects pipeline activity to revenue outcomes
  • Conduct analyses on:
    • Conversion rates across sales stages
    • Sales cycle trends and bottlenecks
    • Pipeline quality and deal progression
    • Marketing contribution to pipeline
  • Support recurring reporting needs and help improve reporting accuracy and consistency
  • Enable self-service reporting for GTM teams
• Insights & Business Support (30%)
  • Collaborate with Sales and Marketing stakeholders to understand reporting needs and performance trends
  • Provide insights into pipeline performance, sales activity, and revenue trends
  • Support business reviews with data and reporting
  • Help identify trends, risks, and opportunities within pipeline and sales performance
  • Contribute to improving visibility into key GTM metrics and performance indicators
• Collaboration (10%)
  • Work with stakeholders to align on pipeline definitions, funnel stages, and reporting metrics
  • Partner with Data Engineering to ensure reliable and consistent data from Salesforce
  • Act as a bridge between business users and technical teams for reporting needs

Qualifications

• 5+ years of experience in analytics, business intelligence, or reporting roles
• Experience supporting Sales, Marketing, or GTM teams
• Experience working in a B2B SaaS or subscription-based environment
• Strong understanding of sales and pipeline metrics, such as:
  • Pipeline coverage
  • Conversion rates
  • Sales cycle length
  • Win rates
• Experience working with Salesforce data (Opportunities, Leads, Campaigns, Accounts)
• Strong SQL skills with experience querying data in AWS Redshift
• Proficiency in Power BI, including data modeling and dashboard development
• Ability to translate data into clear, actionable insights
• Strong communication skills and ability to work cross-functionally

Requirements

• Experience analyzing SaaS metrics such as ARR or MRR
• Experience working with cloud data environments
• Experience building scalable reporting solutions

Benefits

• Competitive base salary
• Monthly, quarterly, or annual incentive
• Comprehensive benefits package including 401(k) with Company match
• Flexible paid time off plan
• Base compensation of $115,000 plus an annual performance-based bonus