About this role.
Carrot is hiring a Business Intelligence Analyst to deliver reliable analytics, dashboards, reusable SQL data models, and ad hoc reporting for cross-functional stakeholders. The role requires advanced SQL, BI visualization experience, basic statistical knowledge, and the ability to translate business questions into clear technical deliverables. The analyst will work with modern tooling such as SQL, dbt, and enterprise BI platforms while contributing to data quality, documentation, and self-service analytics. Success involves independently owning recurring and ad hoc reporting, improving reporting consistency, and becoming a trusted analytics partner across the organization.
Role DNA
A quick view of the complexity, pace, ownership and collaboration implied by the job description.
Job Complexity
3/5Pace & Pressure
4/5Autonomy Level
4/5Communication Load
5/5Salary analysis
Estimated compensation compared with the broader US market for similar roles.
Core skills
Skills and capabilities most closely associated with this opportunity.
Sample interview questions
I would first clarify the decision the dashboard must support, define the intended audience and key metrics, and document metric definitions and data sources. I would then build or validate the underlying model, create an initial dashboard prototype, review it with stakeholders, and add documentation and monitoring before broader rollout.
I validate grain, joins, filters, and metric logic against source systems and known totals. I use reusable modeled tables, automated tests where available, peer review for complex logic, and clear documentation so stakeholders understand definitions and limitations.
I would use window functions when I need calculations across related rows without collapsing detail, such as ranking customers, calculating running totals, identifying the most recent record per member, or comparing a value to a prior period with LAG or LEAD.
I would explain that statistical significance helps us judge whether an observed difference is likely a real result rather than random variation in the sample. I would pair that explanation with effect size, sample size, confidence intervals, and practical business impact rather than presenting a p-value alone.
I would compare the definitions, source tables, time windows, filters, and aggregation levels used by each team. After identifying the discrepancy, I would align stakeholders on a governed metric definition, document it, and update the relevant data model or dashboard to establish a single trusted source.
About Carrot:
Carrot is the leading global fertility and family care platform, built on intelligent care orchestration: the right clinical guidance, at the right moment, in the context of each member’s life. More than a thousand multinational employers, health plans, and health systems trust Carrot to support millions of members across 195 countries – from pre-pregnancy through menopause and major life moments in between. Carrot’s comprehensive clinical program delivers industry-leading cost savings for plan sponsors and award-winning experiences and improved outcomes for millions of people worldwide.
Carrot is widely regarded as a defining force in healthcare innovation as a recipient of several top-tier awards, including Fast Company’s ‘Most Innovative Companies’ and CNBC’s ‘100 Barrier Breaking Startups’. The company is regularly cited by leading global outlets — including The Economist, Bloomberg, The Wall Street Journal, NPR, ABC News, and Harvard Business Review — as a leading voice on digital health, the future of work, and family health. Learn more at get-carrot.com.
The Opportunity 🚀
Carrot is seeking a Business Intelligence Analyst to join our BI function as it scales to meet, and anticipate, the needs of the organization and its clients. This is an executional role providing essential analytics support across the company: you will gather requirements, field ad hoc and recurring data requests, and build the reporting dashboards that leaders across Carrot rely on to make decisions.
You will work hands-on with modern data tooling, including SQL, dbt, and enterprise BI platforms, and partner with teams across the business to translate their questions into clear, trustworthy answers. The BI team is highly cross-functional and sits alongside Data Engineering, making this a strong opportunity to sharpen technical skills while building broad business context in a mission-driven environment.
What You’ll Own 💼
In this role, you will:
- Design and build data models in SQL with a focus on correctness, clarity, and reusability
- Build and maintain dashboards and reports that track key business metrics and inform decision-making across the company
- Conduct ad hoc analyses to answer high-priority business questions from stakeholders across the organization
- Collaborate with teams across Carrot to understand their data domains, reporting needs, and success metrics
- Contribute to data quality, documentation, and self-service BI capabilities as the function scales
What Success Looks Like 📈
In your first 12–18 months, you will have:
- Delivered accurate, well-documented dashboards and reports that stakeholders across the company trust and use regularly
- Fully ramped on Carrot’s data stack and core data domains, independently owning recurring and ad hoc reporting requests
- Built strong working relationships with cross-functional partners and established yourself as a reliable analytics resource
- Improved turnaround and consistency of reporting by creating reusable data models and reducing manual work
About You ✨
You likely have:
- A Bachelor’s Degree
- Intermediate-to-advanced SQL experience: ability to write advanced queries using joins, common table expressions, and window/analytic functions
- Experience with data visualization software (e.g., Tableau, Looker, DOMO, or Power BI) to bring data insights to life for broad audiences
- Basic statistics proficiency: experiment design, hypothesis testing, statistical significance, probability, and distributions
- Ability to translate business intelligence needs from a variety of stakeholders into technical execution and clear presentation
- Strong communication skills, with the ability to explain complex technical information to non-technical audiences
Nice to Have ⭐
While not required, we would be especially excited if you bring:
- Experience using dbt to transform, test, and document data
- Experience working with healthcare industry data or in other complex, regulated data environments
- Experience in a high-growth environment
- Familiarity with version control systems (Git preferred)
- Understanding of effective data modeling strategies and implementations
Why This Role Matters 🧡
Data is central to how Carrot operates and grows. Leaders across the company depend on accurate, timely reporting to serve members, support customers, and make sound business decisions. As a Business Intelligence Analyst, you will be the connective tissue between raw data and those decisions, ensuring the organization runs on insights it can trust.
Your work directly supports Carrot’s mission of expanding access to fertility and family-building care worldwide. Better data means better decisions for the members and customers who rely on Carrot every day.
Interview Process 🤝
We believe in a thoughtful and transparent interview process designed to create alignment for both candidates and our team.
For this role, candidates can expect:
- Recruiter Screen — 30 minutes
- Hiring Manager Interview — 45 minutes
- Cross-Functional Panel Interviews — 45 minutes
- Performance Task — 60 minutes
Throughout the process, we will share additional context about the team, business priorities, customer landscape, and what success looks like in this role.
Why Candidates Join Carrot 🌍
Carrot offers the opportunity to do meaningful work in service of a deeply human mission.
Highlights include:
- A mission-driven company focused on expanding access to fertility and family-forming care globally.
- A high-growth environment where leaders are empowered to shape strategy and drive impact.
- Competitive compensation, equity, and comprehensive benefits.
- Flexible Time Off and a culture that actively encourages employees to recharge.
- Comprehensive parental leave and family-forming benefits.
- A collaborative, inclusive, and values-driven culture.
- The opportunity to work alongside passionate, thoughtful teammates committed to improving healthcare outcomes worldwide.
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 $98,000.00- $125,000.00. Actual compensation may vary from posted base salary depending on your confirmed job-related skills and experience.
Fraud and Security Notice: Please note that all communication regarding job opportunities at Carrot will come exclusively from an @get-carrot.com email address. If you receive messages from any other domain, please disregard them and report the incident to: securityreporting@get-carrot.com
A Note on AI
At Carrot, we believe AI can help us work smarter, move faster, and create more meaningful experiences for our members, customers, and each other. While not every role requires deep technical AI expertise, we value people who are curious, eager to learn, and excited to thoughtfully incorporate AI into their day-to-day work.
For some roles, AI fluency is a core requirement—and we’ll call that out clearly in the qualifications. For everyone else, we’re looking for people who embrace new ways of working, use AI responsibly to improve quality and efficiency, and continue to learn as the technology evolves.
Why Carrot?
Carrot has received national and international recognition for its pioneering work, including Fast Company’s Most Innovative Companies and World Changing Ideas, Inc. Power Partners, and Modern Healthcare’s Innovators. Carrot’s global workforce has been acknowledged with several accolades, including Fortune’s Best Workplaces in Healthcare, Great Place to Work, and Age-Friendly Employer certifications. Carrot is regularly featured in media reporting on issues related to the future of work, women in leadership, and healthcare innovation, including MSNBC, The Economist, Bloomberg, The Wall Street Journal, CNBC, National Public Radio, Harvard Business Review, and more. Learn more at carrotfertility.com.
Upload your resume now
- To unlock remote work opportunities and be discovered by global employers.
This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.
