LighthouseAI · 17 hours ago
Senior Business Intelligence Analyst
United States
Full-time
Remote
Mid, Senior Level
$90K/yr - $110K/yr
3+ years expLighthouseAI provides pharmaceutical state licensing software and services to various stakeholders in the pharmaceutical industry. The Senior Business Intelligence Analyst will own and scale reporting and analytics, delivering insights to drive operational improvements and strategic decision-making across the Professional Services organization.
Artificial Intelligence (AI)MedicalPharmaceuticalSoftware
Responsibilities
Own 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
Build 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
Develop reporting frameworks
Establish quality reporting and measurement standards
Track progress against 2026 operational and financial targets
Deliver insights that drive proactive operational improvements
Build 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
Partner closely with Professional Services leadership, Finance and Customer Success
Deliver executive-ready reporting for leadership decision-making
Translate data into actionable insights that drive operational planning and business outcomes
Qualification
Required
Advanced 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
Experience supporting professional services, consulting, SaaS, or operations teams
Proven ability to translate business problems into analytical solutions
Strong understanding of cost modeling
Strong understanding of resource utilization
Strong understanding of revenue and margin analytics
Strong understanding of operational efficiency frameworks
Experience building scalable analytics and reporting systems
Ability to streamline and automate manual workflows
Strong documentation, training, and standardization skills
Exceptional 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
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 PowerPoint
Staying 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
Benefits
Health, Dental, Vision Insurance
STD, LTD, Life Insurance
401(k)
PTO and Paid Holidays
Company
LighthouseAI
LighthouseAI provides software solutions to pharmaceutical manufacturers.
51-200 employees
H1B Sponsorship
LighthouseAI has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (2)
Funding
Current Stage
Growth StageTotal Funding
$5.6M2023-10-24Seed· $4.6M
2022-08-08Seed· $1M
Leadership Team
Sumeet Singh
Founder & CEO
Rick Braddy
CTO
Recent News
2025-02-10
2024-10-29
Company data provided by crunchbase