The Role:

Carrot is seeking a Business Intelligence Analyst to join our rapidly growing Business Intelligence function as it scales to meet - and anticipate - the needs of the organization and its clients: we solve mission-critical, complex data and analytics problems and we need your help. This is an executional role providing essential support across the organization: you will gather requirements, field ad-hoc and regular data requests, develop reporting dashboards and help us level-up our business intelligence capabilities. Specific job responsibilities will include:

• Designing and building data models in SQL with a focus on correctness, clarity and reusability
• Building dashboards and reports to track key business metrics and inform decision-making across the company
• Conducting ad-hoc analyses as needed to answer important business questions
• Collaborating with other teams to understand their data domains and reporting needs

The Team:

The Business Intelligence team is a highly cross-functional team that is central to Carrot’s long-term success. The team is led by the Senior Manager of Business Intelligence and sits alongside Data Engineering and Data Science.

Minimum Qualifications:

• Intermediate-to-advanced SQL experience: ability to write advanced SQL queries using joins, common table expressions, and window/analytic functions
• Basic statistics proficiency: experiment design, hypothesis testing, statistical significance, split- and multivariate testing, probability and distributions
• Knowledge of visualization techniques and when to apply them
• Experience working with data visualization software (e.g., PowerBI, Tableau, Looker, DOMO) to bring data insights to life for broad audiences
• Able to translate business intelligence needs from a variety of stakeholders into the technical execution and presentation
• Strong communication skills - able to communicate complex technical information to non-technical audiences

Preferred Qualifications:

• Experience using dbt to transform, test and document data
• Experience in a high-growth environment
• Experience working with healthcare industry data
• Working knowledge of Python for data analysis
• Experience working with version control systems (Git preferred)
• Understanding of effective data modeling strategies and implementations

Compensation:

Carrot offers a holistic Total Rewards package designed to support our employees in all aspects of their life inside and outside of work, including health and wellness benefits, retirement savings plans, short- and long-term incentives, parental leave, family-forming assistance, and a competitive compensation package. The starting base salary for this position will range from $90,000-$110,000. Actual compensation may vary from posted base salary depending on your confirmed job-related skills and experience.