Business Intelligence Analyst II

About the right team member

Mindbody is seeking a highly motivated Business Intelligence Analyst to support our team’s mission of creating and maintaining a world-class data environment. Our Business Intelligence team sits at the center of everything data-related at Mindbody, and works cross-functionally with stakeholders to understand business needs, build data models that support tracking critical metrics, and provide analytical insights that drive business strategy. This opportunity is an excellent fit for a candidate that is passionate about sitting on a centralized data team, is a systems thinker, and has a strong desire to contribute to the operational and strategic initiatives at the company. This role is predominantly focused on the ClassPass business, though sits on the centralized Business Intelligence team whose responsibilities span both Mindbody and ClassPass. 

About the role

• Write, QA, and maintain/update the SQL logic underpinning our core data models which power all business KPI reporting at the company
• Collaborate with business stakeholders to understand their reporting needs; leverage a combination of data insights and business acumen to advocate and build business cases for strategic initiatives
• Create and maintain reports, dashboards, and data sources that effectively communicate and surface business insights for our most critical KPI’s and can be easily understood by teams
• Monitor performance trends and identify areas of improvement; conduct ad hoc analysis and provide recommendations to teams for improving business processes and strategy
• Work closely with our technical engineering, product, and business teams throughout the development of new features or changes to third party business systems to anticipate and communicate data needs
• Create and manage a roadmap with primary business stakeholders to define goals, prioritize work, and communicate expected timelines and deliverables
• Develop BI best practices around our data warehouse and ETL pipelines, data architecture, documentation, and data visualization tools (e.g., Tableau, Looker) 

Skills & experience

• Bachelor’s degree, quantitative field preferred 
• Experience in Business Intelligence or similar role that involves developing data models and database as a nascent or rapidly scaling business; proven ability to transform messy or unstructured data into robust, well-organized data models
• Advanced SQL skills required (PostgreSQL, Snowflake)
• Experience developing data models and working with data warehouses (Snowflake, Postgres experience a plus)
• Familiarity with BI tools and platforms (Tableau, Looker, Fivetran, ETL pipelines, dbt, Excel)
• Has a strong interest in the business-side implications of work; is able to build positive working relationships with teams to “keep up” with what’s going on and feels comfortable collaborating with stakeholders of all seniority levels to understand data needs
• Ability to present complex analysis in a clear and understandable manner to both technical and non-technical stakeholders
• Strong problem-solving skills; has a logical mindset and can identify business challenges and propose data-driven solutions
• Detail-oriented; loves finding “edge cases” and ensures data accuracy by troubleshooting, testing, and carefully reviewing output
• Familiarity with road mapping or sprint cycles; is able to communicate priorities and meet deadlines