About LighthouseAILighthouseAI provides pharmaceutical state licensing software and services to pharmaceutical manufacturers, wholesale distributors, logistics companies, and pharmacies. The LighthouseAI product suite includes LighthouseAI Intelligence®, which uses artificial intelligence to automate compliance requirement research, and LighthouseAI Management® which enables maintenance. LighthouseAI creates a stress-free and streamlined state licensing experience with support from our expert industry veterans and professional solutions.
We are seeking a highly analytical and technically skilled Senior Business Intelligence Analyst to own and scale reporting, analytics, and operational insights across our Professional Services organization. This role will be responsible for building a robust analytics foundation that enables data-driven planning, staffing, efficiency measurement, and strategic decision-making.
This role will eliminate manual data workflows, establish standardized metrics, and deliver actionable insights through high-quality dashboards and reporting frameworks. In addition, this position will serve as a strategic business partner to Professional Services leadership, Finance, and Customer Success teams.
This is a full-time remote position.
Working Hours: Monday-Friday 8am-4:30pm ET
Essential Duties and Responsibilities:Professional Services Reporting & AnalyticsOwn end-to-end professional services reporting and analytics strategy.Design, build, and maintain scalable dashboards and reporting solutions using
Power BI and SQL-based data models.Develop automated reporting pipelines that replace manual data processes.Ensure data integrity, consistency, and reliability across systems.
Operational & Financial Performance MetricsBuild and manage KPIs and metrics (i.e. cost per employee, cost per activity, Output vs. spend vs. revenue, Productivity and efficiency trends)Create normalized performance metrics (i.e. staffing models forecasting, budget planning, resource optimization)Partner with Finance to align operational metrics with financial performance and forecasting models.
Efficiency, Quality & Churn AnalysisDevelop reporting frameworksEstablish quality reporting and measurement standards.Track progress against 2026 operational and financial targets.Deliver insights that drive proactive operational improvements.
Data Infrastructure & Process OwnershipBuild scalable data foundations to support long-term reporting needs.Standardize processes for data collection, reporting, and documentation.Create training and documentation to ensure consistent use of reporting tools and dashboards.Establish accountability frameworks that drive operational efficiency.
Strategic Partnership & Stakeholder EnablementPartner closely with Professional Services leadership, Finance and Customer SuccessDeliver executive-ready reporting for leadership decision-making.Translate data into actionable insights that drive operational planning and business outcomes.
Work Experience Qualifications:Technical & Analytical ExpertiseAdvanced
SQL skills with demonstrated experience running complex queries across large datasets.Expert-level experience in
Power BI, including data modeling, dashboard creation, and automation.Strong experience building KPIs, operational dashboards, and performance metrics.Experience working with
QuickBooks or comparable financial/accounting platforms.Strong data visualization and storytelling skills.
Operational & Business AcumenExperience supporting
professional services, consulting, SaaS, or operations teams.Proven ability to translate business problems into analytical solutions.Strong understanding of:o Cost modelingo Resource utilizationo Revenue and margin analyticso Operational efficiency frameworks
Process & Systems ThinkingExperience building scalable analytics and reporting systems.Ability to streamline and automate manual workflows.Strong documentation, training, and standardization skills.
Collaboration & CommunicationExceptional communication skills, with the ability to present insights clearly to executives and cross-functional teams.Comfortable working cross-functionally across Finance, Customer Success, and Operations.Strong stakeholder management and influence skills
Other Qualifications:3+ years of experience in
SaaS, compliance, regulatory, healthcare, or professional services environments.3+ years of experience working with multi-source data environments (CRM, PSA tools, ERP, accounting systems).Familiarity with financial planning, forecasting, and workforce modeling.Experience building analytics frameworks from early-stage or scaling environments.Microsoft Office suite competency including Excel, Word, and PowerPointStaying organized while effectively prioritizing multiple projects at once.High attention to detail when completing projects.Strong time management skills to complete projects by deadlines.Self-motivated individual who takes ownership of their projects.
Compensation:Annual Salay: $90,000 - $110,000
Benefits:Health, Dental, Vision InsuranceSTD, LTD, Life Insurance401(k)PTO and Paid Holidays
PI4b5162cd7121-37437-39525356
