5+ years of experience in analytics, business intelligence, or reporting roles.
Experience supporting Sales, Marketing, or GTM teams.
Experience in a B2B SaaS or subscription-based environment.
Strong SQL skills with experience querying data in AWS Redshift and proficiency in Power BI (data modeling and dashboard development).
Requirements:
Build and maintain Power BI dashboards that provide visibility into pipeline health, sales performance, conversion rates, deal velocity, and ARR contributions from new business.
Analyze end-to-end sales funnel performance from lead through closed-won, identifying bottlenecks and driving insights into revenue outcomes.
Support recurring reporting, enable self-service reporting for GTM teams, and contribute to business reviews with data and insights.
Collaborate with Sales, Marketing, and Data Engineering to align on definitions, ensure reliable Salesforce data, and translate business needs into reporting solutions.
Job description
Remote, US-based position. Candidates must already live in the United States. #LI-Remote “Must be authorized to work in the US”
No visa sponsorship. We are unable to sponsor or take over sponsorship of an employment Visa (H1-B, Student visa, or OPT visa) at this time.
At Lexipol, our mission is to create safer communities and empower the individuals on the front lines with market-leading content and technology. Our top-notch team works closely with law enforcement, fire, EMS, corrections, and local government professionals to tailor our solutions to better address today’s challenges and keep the first responders coming home safely at the end of each shift.
Working at Lexipol means making a difference – day in and day out.
The Work
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
What You Bring Required Experience
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
Preferred Experience
Experience analyzing SaaS metrics such as ARR or MRR
Experience working with cloud data environments
Experience building scalable reporting solutions
Why Join Lexipol
Support high-impact Sales and Marketing teams with meaningful analytics
Work with modern tools including Salesforce, AWS Redshift, and Power BI
Be part of a mission-driven organization making a real-world impact
Collaborate with a data-driven and supportive team
The Environment
Our team is highly productive and works with urgency every day to provide the expected high-quality software solutions to our public safety professionals. Individuals who seek out additional responsibilities and have an action-oriented mindset thrive on this team.
Dynamic, collaborative, and driven by a mission to make a difference. Our team enjoys the challenge of solving complex problems and implementing solutions that have a real impact.
We celebrate our success, give praise, want to learn from one another, and are dedicated to each member of the team maximizing their potential.
Our core values of Serve, Innovate, Collaborate, Empower, and Own It are not just words but the principles guiding every decision and action, fostering a culture of impact, growth, and mutual respect. Like the vital relationship between a ship and its crew, we prioritize our collective mission and the well-being of our teammates. This philosophy ensures we navigate challenges successfully and support each other in achieving personal and professional growth, reflecting our commitment to service and innovation.
Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Duties listed are not intended to be exhaustive or exclusive; other duties may be assigned. Management retains the discretion to add to or change the duties of the position at any time.
Compensation and Benefits Lexipol offers a competitive base salary, monthly, quarterly, or annual incentive and a comprehensive benefits package including 401(k) with Company match and a flexible paid time off plan.
The base compensation is $115,000 plus an annual performance-based bonus.
About Lexipol Lexipol is the leader in advancing total readiness for public safety agencies, helping leaders reduce risk, ease administrative burdens, and strengthen community trust. Trusted by more than 12,000 agencies nationwide, Lexipol delivers a unified platform that integrates policy, training, wellness, and reporting to simplify operations and support data-informed decisions. By equipping leaders and teams with the tools, insights, and support they need, Lexipol makes readiness possible—today and for whatever comes next. Learn more at www.lexipol.com.
Lexipol Is an Equal Opportunity Employer (EOE) Lexipol, LLC provides equal employment opportunities (EEO) to all team members and applicants for employment without regard to race, color, religion, gender, national origin, age, sex, pregnancy, disability, sexual orientation, gender identity or expression, veteran status, genetic information, or any other non-job-related characteristic. Lexipol complies with applicable federal, state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including hiring, placement, promotion, termination, layoff, recall, transfers, leave of absence, compensation, and training. #LI-KD1
