Our Firm

Careers

VIEW ALL APPLY NOW

Business Intelligence Analyst II

Entry Level

MINDBODY | Product Development

Job Family Summary:

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 operational reporting and business intelligence to enable the creation of dashboards, analyses, and insights for all MINDBODY. This is achieved through the cultivation and creation of high-quality data models, dashboards, and automation systems and processes through intentional and evolving strategic partnerships with the rest of Data Science and all other departments across the organization. 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.

 

JOB SUMMARY:

The successful Business Intelligence Analyst II will enable analytic insights that inform and influence operational strategies and business decisions across the MINDBODY organization. The ideal candidate will have a strong aptitude for CRM and billing system reporting, data visualization, and database querying. Working closely with other members of the Business Intelligence team and leaders across the organization, they will utilize analytic tools to process data, build complex datasets, develop reports to drive MINDBODY’s international organization. 

 

MINIMUM QUALIFICATIONS AND REQUIREMENTS:

·       Bachelor’s degree, quantitative field preferred

·       3-5 years of experience performing quantitative data analysis in SQL

·       Intermediate proficiency in two or more of the following tools, languages and platforms: Python, R, SSIS, Tableau, Looker, Alteryx

·       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

·       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 data sources 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 business intelligence platforms

·       Develop technological 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