Vagaro is seeking a Business Analyst to bridge the gap between Finance and Data Intelligence, ensuring accurate and actionable reporting across the business.
Requirements
- Advanced SQL proficiency, including window functions, CTEs, joins, and performance optimization.
- Strong expertise in Power BI, including data modeling, DAX, relationships, and visualization best practices.
- Solid understanding of SaaS and payments KPIs (ARR, MRR, churn, NRR, cohorts, GPV, take rate, approval rate, etc.).
- Experience with forecast modeling or FP&A processes is a plus.
- Workday experience is a plus.
- Advanced proficiency in SQL
- Strong Power BI development skills
Responsibilities
- Serve as the liaison between Finance and Data Intelligence, converting business questions into clear data requirements and ensuring insights directly inform decision-making.
- Define, validate, and refine SaaS and payment processing KPIs for forecasting, board reporting, and performance tracking.
- Build, automate, and manage Power BI dashboards for ARR, MRR, churn, retention, NRR, LTV/CAC, GPV, take rate, funnel analytics, and other SaaS and payments metrics.
- Develop scalable data models and automated reporting used by executives, Finance, and cross-functional leaders.
- Write advanced SQL to extract, clean, transform, and validate data across production systems, data warehouses, and payment systems.
- Partner with Data Engineering to enhance data pipelines and ensure accurate, reliable inputs for financial and operational reporting.
- Conduct deep-dive analytics on customer behavior, cohorts, churn drivers, revenue movements, and other key business levers.
Other
- 3 to 5 years of experience in business analytics, data analysis, data engineering, FP&A analytics, or a related field.
- Strong preference for candidates with backgrounds in management consulting (Deloitte, Accenture, Bain, McKinsey, etc.) or investment banking (TMT, fintech, M&A, or similar groups).
- Ability to present complex data clearly and confidently to executives.
- Comfortable operating cross-functionally in a fast-paced, high-growth environment.
- Authorized to work for any U.S. employer
