MINDBODY | Jobs | Business Intelligence Analyst I | BigDataKB.com | 02-04-22

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 Analyst will enable analytic insights that inform and influence operational strategies and business decisions across the organization. Working closely with other members of the Business Intelligence team and stakeholders across the organization, they will utilize analytic tools to process data, build complex data models, develop reports and provide actionable recommendations based on first-hand analysis.

QUALIFICATIONS AND REQUIREMENTS:

• Bachelor s degree, quantitative field preferred

• 1-3 years of experience performing quantitative data analysis

• Strong experience in SQL is a must

• Beginner proficiency in the following tools, languages, and platforms: Excel, Any BI Tool (Looker, Tableau, Power BI)

• Good to have skills: Python, SSIS / Informatica / Alteryx / Knowledge of ETL, Snowflake, DBT

• Experience quantifying and prioritizing projects that require heavy data modeling and 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

PRINCIPAL DUTIES AND RESPONSIBILITIES:

• Work with stakeholders to design, create, and operationalize SQL queries for creating source of truth data models in Snowflake and surface them through self-service tools like Looker

• 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 using Enterprise Data Warehouse

• Work closely with business to align on business logic and build data models in Enterprise Data Warehouse

• Create source of truth data models to enable analysts to answer key business questions

• Produce technical documentation of data models, 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

SCOPE OF SUPERVISION/AUTHORITY:

• Duties for this position are performed under limited supervision

• You will be responsible for planning and organizing their own work, which may or may not be directly related to general business operations of the company or its customers

• You will receive training and guidance from manager as needed

• Individual contributors may be required to regularly exercise discretion and independent judgment with respect to matters of significance depending on the nature of the position

• There is no direct management responsibility for the position

WORK ENVIRONMENT AND PHYSICAL DEMANDS:

• You will need dexterity of hands and fingers to operate a computer keyboard

• This position is mostly stationary and will be required to remain stationary for extended periods of time

• Specific vision abilities required by this position include close vision, color vision, and the ability to adjust focus

• The noise level in the work environment is usually moderately quiet