Lead Business Intelligence Analyst

CirrusMD delivers a physician-first virtual care and guidance solution that connects patients with licensed physicians through a text-based or web application. The Lead Business Intelligence Analyst will partner across product, clinical, client success, finance, and engineering teams to derive insights from complex data, build measurement frameworks, and support data-informed decision-making. The role also owns data lifecycle management, semantic layer development, visualization, reporting, and strategic insight generation.

Responsibilities:

• Act as the primary data partner to product, clinical, client success, finance, and engineering teams to align cross-functional initiatives and build a unified, data-informed organizational ecosystem
• Architect robust measurement frameworks that transform product, clinical, and commercial initiatives into clearly defined performance metrics, directly demonstrating the economic value and ROI of CirrusMD’s solution to external stakeholders and clients
• Own the project data lifecycle - from initial ideation and feasibility assessment to building internal/client-facing reporting
• Collaborate with engineers to define data structures and build out the Looker semantic layer to ensure high-trust, reusable data
• Transform complex datasets into actionable insights that influence the strategic direction of the organization
• Build and maintain high-impact visualization solutions and reporting frameworks that drive awareness and understanding of key performance metrics
• All other duties assigned

Requirements:

• 5+ years of relevant analytics experience
• Proven experience translating business requirements into technical execution for cross-functional stakeholders
• Strong to advanced SQL skills; experience with Cloud Data Platforms (e.g., Snowflake) and BI reporting tools (e.g., Looker Cloud/On-Prem)
• Expert in building semantic layers (LookML), managing version control via GitHub, and applying data architecture best practices to ensure scalable, high-performance reporting environments
• Proven ability to manage the full data lifecycle, from greenfield modeling to refactoring and optimizing legacy technical debt
• Exceptional bi-directional communication skills that allow you to distill complex technical topics for non-technical stakeholders while also collaborating effectively with technical counterparts
• Proven ability to manage competing priorities, knowing when to dive deep and when to zoom out to meet deadlines
• Experience fulfilling complex, client-facing data requests while maintaining clear boundaries around data governance. You are highly adept at balancing stakeholder accommodation with a strict adherence to established organizational standards
• Experience owning high-integrity data processes (e.g., billing, invoicing, or clinical reporting) where accuracy is non-negotiable
• Knowledge and application of statistical methods and concepts such as incorporating confidence intervals, hypothesis testing, sentiment analysis, and anomaly detection
• Experience with data transformation tools (dbt, Airflow) and the ability to leverage toolsets (Python/R) for analysis beyond standard SQL
• Deep understanding of HIPAA/FedRAMP compliance, PII/PHI handling, and clinical metrics (HEDIS/NCQA/NQF)
• Knowledge of event-based tracking and Customer Data Platforms (e.g., Segment)
• A holistic understanding of modern data stacks, infrastructure dependencies, and how upstream engineering impacts downstream consumption
• Experience implementing AI-driven BI capabilities (such as Natural Language Querying or Looker Conversational Analytics) to democratize data access and enable intuitive, self-service exploration for business users