Business Intelligence Analyst

MAIN AREA OF RESPONSIBILITY:

The primary responsibility of the BI Analyst is to transform data (from marketing, sales and customer success) into insight that can help to improve the value of Sprout. He or she will be responsible for managing data retrieval and analysis within the organization including organizing data points, communicating between upper management and stakeholders, and analyzing data to determine Sprout’s needs and strategies.

TASKS:

• Identify trends that can help other departments, managers and executives make business decisions to modernize and improve processes in Sprout

• Analyze business requirements and processes and recommending them to the management and executives for implementation

• Develop and manage business intelligence solutions

• Discover areas of revenue loss and identify ways to increase revenue and profits by mining complex data using BI software and tools, comparing data to competitors and industry trends, and creating visualizations that communicate findings in the organization

• Monitor analytics and metrics results

• Provide reports through office applications to improve business processes

• Implement new data analysis methodologies

• Review customer files to ensure integrity of data collection and utilization

• Perform data profiling to identify and understand anomalies

• Perform other duties as assigned by the company

QUALIFICATIONS | COMPETENCIES:

• Extensive knowledge in data visualization best practices

• Experience with BI tools (e.g. PowerBI)

• Experience with Azure

• Experience with SQL

• Experience with HubSpot CRM, MarketingHub and SalesHub a plus

• Experience reading and building data models

• Background in data warehouse design and data mining

• Strong problem-solving and analytical skills

• Excellent interpersonal, communication, listening and presentation skills

• Must be self-motivated and able to work with minimal supervision

• A good team player and willingness to learn

• Strong innate desire and proven track record of continuous self-improvement (in learning, job expansion, extracurricular activities, etc)