Business Intelligence Analyst II - Sales at Mindbody
San Luis Obispo, CA, US

MINDBODY’s Data Science department makes sense of our data world through meaningful and actionable insights, identifying trends, delivering reports, informing product and infrastructure advancements, and promoting a culture of data-driven decision making.

The Business Intelligence branch of MINDBODY’s Data Science department leads data stewardship and business intelligence to enable the creation of dashboards, analyses, and insights for all of MINDBODY. This is achieved through the cultivation and creation of high-quality datasets, dashboards, and automation systems and processes through intentional and evolving strategic partnerships with the rest of Data Science, the Project Management Office, and the Data Management department. Products created by the Business Intelligence team will be guided by data quality, be of high value to the company, and follow project management best practices to ensure all outcomes are repeatable, improvable, and actionable.

A successful Business Intelligence Analyst II – Sales will enable analytic insights that inform and influence operational strategies and business decisions across the MINDBODY Sales organization. The ideal candidate will have a strong aptitude for Salesforce, SQL, Tableau, Alteryx, Excel, Access, and working with data. Working closely with other members of the Business Intelligence team and Sales leaders across the organization, they will utilize analytic tools to process data, build complex datasets, develop reports to drive MINDBODY’s international Sales organization.

 

MINIMUM QUALIFICATIONS AND REQUIREMENTS:

  • Bachelor’s degree, quantitative field preferred
  • 3-5 years of experience performing quantitative data analysis
  • Experience with Sales performance and operational reporting
  • Intermediate proficiency in any of the following tools, languages and platforms: MS SQL, Python, R, SSIS, Excel, RedShift, Azure, Tableau
  • Experience quantifying and prioritizing projects that require heavy data analysis
  • Aptitude for numbers and a curiosity about information and data
  • Ability to present data in a simple, clean, concise visual and written manner
  • Strong attention to detail, analytical mindset, and highly organized
  • The desire to work in a fast-paced, potentially ambiguous, start-up-like atmosphere
  • Strong technical aptitude and demonstrated ability to quickly evaluate and learn new technologies
  • Strong interpersonal skills, with the ability to work independently and within a team environment

 

PRINCIPAL DUTIES AND RESPONSIBILITIES:

  • Align business logic needs with data warehouse team’s technological solutions to surface consumable data products
  • Provide business and technological expertise in such areas as payments volume and profitability reporting
  • Cultivate, organize, surface, and maintain Universal Data Sources (UDS’) to enable analysts to answer key business questions
  • Bridge the gap between business systems and production data to push the universal data source strategy to fruition
  • Work with stakeholders to design, create, and operationalize SQL queries for creating universal data sources surface through Tableau Server
  • Develop technical solutions to modify, aggregate, and surface payments data through dashboards that answer key business questions
  • Develop SQL queries used to audit, automate, and report on subscriber data across production, business system, and historically isolated processes
  • Translate business questions, processes, and initiatives into SQL queries against MINDBODY’s data lake
  • Produce technical documentation of data sources, metrics definitions, and key initiatives
  • Attain a high degree of knowledge about MINDBODY’s data infrastructure
  • Consult with management to understand current and future business goals and strategies, and ensure that high-visibility reporting and analysis is aligned
  • All other duties as assigned