Analytics Associate

At Carrum, we are transforming how we pay for, deliver and experience healthcare. If you are passionate about changing healthcare and want to finally get rid of surprise bills, poor quality, and high prices, while thriving in an entrepreneurial, cutting-edge environment, we would love to connect with you.

In 2014 Carrum reinvented the Centers of Excellence (COE) category in digital health. Today, 95% of the US population lives within 50 miles of a Carrum COE and our providers rank in the top 10% nationally. Our team’s execution has been recognized by the venture community and we’ve raised more than $96M in aggregate from investors like OMERS, Tiger Global Management and Wildcat Ventures. Our impact has been externally proven in a 2021 RAND Corporation study and featured as a Harvard Business School (HBS) case study.

We are seeking a detail-oriented Analytics Associate to join our Analytics team to help unlock additional commercial analytics and reporting capabilities. In this role, you'll work with complex datasets to derive meaningful insights and support data-driven decision-making across the organization, specifically with our provider and commercial teams.

This is a full time position, the salary range for this role is $105,000 - $125,000 depending on level of experience and geographic location.

You’re excited about this opportunity because you will...

• Develop and maintain complex analytical models and dashboards using Tableau to visualize key business metrics and trends
• Create sophisticated Excel models to support financial analysis and business planning
• Conduct in-depth data analysis to identify patterns, trends, and areas for improvement
• Write and optimize SQL queries in Athena to extract, transform, and analyze large datasets
• Collaborate with stakeholders to understand business requirements and translate them into analytical solutions
• Ensure data accuracy and integrity through rigorous validation processes
• Document technical processes and maintain data dictionaries

We’re excited about you because…

• 5-8+ years of experience in business intelligence, data analytics, or related field
• 2+ years of experience in a consulting or investment banking environment preferred
• Master-level expertise in Excel, including complex formulas, pivot tables, and VBA
• Advanced proficiency in SQL, particularly with Amazon Athena
• Strong experience with Tableau, including dashboard development and data visualization best practices is preferred
• Exceptional attention to detail and ability to manage interconnected numerical datasets
• Strong organizational skills with ability to manage multiple projects simultaneously
• Bachelor's degree in Business, Analytics, Statistics, or related field
• Entrepreneurial and resourceful — As an early member of a startup, we need people who can find creative ways to make a big impact quickly and without much direction.
• Experience handling deadlines, keeping many balls in the air, and prioritizing work in a fast-paced, dynamic environment.
• Passion for collaborating cross-functionally with sales, operations, client success, data, and product teams to ideate, complete projects, and drive impactful results.

Why you’ll love working with us...

• We’re a hard-working, humble, and compassionate group motivated to solve the hard problems in healthcare today. You’ll work with talented, experienced co-workers from companies like Booz & Company, Livongo, 98point6, Google, and Optum. We believe in using data to inform decisions, technology to make our jobs easier, and creative thinking to pave the future.
• We are working with some of the most recognized and esteemed names in the country. Top hospitals like Johns Hopkins, Mayo Clinic, Stanford Health Care, Scripps Health, and Rush Health have joined our platform. Employers who use our benefit include US Foods, United Airlines, and large public sector organizations like the self-insured schools of California, and the State of Maine.
• We empower team members to be autonomous and provide a collaborative environment where you get support and healthy feedback. You can bring your authentic self to work every day and are encouraged to help others do the same.
• We carve out time to let go of work to celebrate our successes and have fun. We’re a remote-first company with employees all over the United States and two office locations in San Francisco and Chicago. We support our employees during the work day and beyond with flexible working hours, generous time off, paid parental leave, and opportunities to co