Principal Business Intelligence Analyst

<p dir="auto"><span style="color: rgb(38, 38, 38);">At Carrum, we live and breathe the mission of transforming the healthcare system to create an unmatched experience for patients. 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.</span></p><p dir="auto"><span style="color: rgb(38, 38, 38);">In 2014 Carrum reinvented the Centers of Excellence (COE) category in digital health. Today, 90% 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 </span><a target="_blank" rel="noopener" href="https://www.carrumhealth.com/rand-corp-study-bundled-payments-save/"><span style="color: rgb(17, 85, 204);">RAND Corporation study</span></a><span style="color: rgb(38, 38, 38);"> and featured as a </span><a target="_blank" rel="noopener" href="https://www.hbs.edu/faculty/Pages/item.aspx?num=51867"><span style="color: rgb(17, 85, 204);">Harvard Business School (HBS) case study</span></a><span style="color: rgb(38, 38, 38);">.</span></p><p dir="auto"></p><p dir="auto"><span style="color: rgb(38, 38, 38);"><strong>The Role</strong></span></p><p dir="ltr"><span style="color: rgb(38, 38, 38);">We are seeking a detail-oriented Business Intelligence Analyst 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, support data-driven decision-making, and contribute to mission-critical automation efforts, specifically with our provider and commercial teams.</span></p><p dir="ltr"></p><p dir="auto"><span style="color: rgb(38, 38, 38);"><strong><em>The salary range for this role is $155,000 - $180,000 depending on geography and level of experience, plus equity and an annual bonus.</em></strong></span></p><p dir="auto"></p><p dir="auto"><span style="color: rgb(38, 38, 38);"><strong>You’re excited about this opportunity because you will...</strong></span></p><ul dir="auto"><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">You automate before you manually do it twice - If you find yourself running the same query or building the same report more than once, you build a pipeline and collaborate with engineers. Manual work at scale a a problem you fix, not a workflow you accept</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">You own accuracy personally - The analysis you produce informs employer decisions and executive strategy. You validate your work before it ships., document our logic, and flag uncertainty rather than hiding it</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">You think in systems, not outputs - A one-off analysis is the last resort. You collaborate to build data models and reporting infrastructure that answer categories of questions, not single requests</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">You are resourceful and self-directed - You do not wait to be fully briefed before making progress. You find the data, make reasonable assumptions, document them and deliver something useful while iterating towards perfect</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">You communicate what the data means, not what it says - You translate complex analytical outputs into clear business narratives for stakeholders who need to make decisions, not just consume numbers</span></p></li></ul><p dir="auto"><span style="color: rgb(38, 38, 38);"><strong>We’re excited about you because…</strong></span></p><ul dir="auto"><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">10+ years in business intelligence, analytics engineering, or data analytics, with a strong bias toward building automated, scalable solutions rather than one-off analysis.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Expert-level SQL: you write complex, optimized queries across large datasets, build reusable CTEs and modular logic, and think in terms of data models rather than query outputs.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Advanced Tableau skills: you build dashboards that people actually use, with attention to performance, usability, and visual clarity, not just technical correctness.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Hands-on experience with Snowflake and at least one other cloud warehouse or query engine such as Athena, BigQuery, or Redshift.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Real experience working with healthcare claims data: you understand CPT codes, diagnosis codes, episode structures, and the data quality challenges that come with claims, and you know how to work around them.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Python proficiency for analytics automation: you can write scripts to automate report generation, data validation, and pipeline orchestration without needing an engineer to do it for you.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">A strong instinct for data quality and a track record of building validation checks, anomaly detection, and documentation into your work rather than treating them as afterthoughts.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Exceptional attention to detail and ability to manage interconnected numerical datasets</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Strong organizational skills with ability to manage multiple projects simultaneously</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Bachelor's degree in Business, Analytics, Statistics, or related field</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Entrepreneurial and resourceful qualities — 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.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Experience handling deadlines, keeping many balls in the air, and prioritizing work in a fast-paced, dynamic environment.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Passion for collaborating cross-functionally with sales, operations, client success, data, and product teams to ideate, complete projects, and drive impactful results.</span></p></li></ul><p dir="auto"><span style="color: rgb(38, 38, 38);"><strong>Why you’ll love working with us...</strong></span></p><ul dir="auto"><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">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.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">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.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">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.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">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 connect with coworkers both virtually and in-person.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">We embrace our team’s diversity of thought, experience, and interests and know that doing so makes us stronger as a company. Carrum has an active employee-led Diversity, Equity, Inclusion, and Justice (DEIJ) committee and several employee resource groups (ERGs). Our ERGS help employees build stronger connections through social, educational, and community activities.</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">You’ll feel proud that the work you do each day directly impacts people’s lives in big and meaningful ways.</span></p></li></ul><p dir="ltr"><span style="color: rgb(38, 38, 38);">Other benefits:</span></p><ul dir="auto"><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Stock option plan</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Flexible schedules and remote work</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Chicago and San Francisco offices available</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Self-managed vacation days, within reason</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Paid parental leave</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">Health, vision, and dental insurance</span></p></li><li dir="ltr"><p dir="ltr"><span style="color: rgb(38, 38, 38);">401K retirement plan</span></p></li></ul><p dir="ltr"></p><p dir="ltr"><span style="color: rgb(38, 38, 38);"><strong>About Carrum</strong></span></p><p dir="ltr"><span style="color: rgb(38, 38, 38);">We’re a health tech company that brings value-based care to the masses. We help employers deliver a memorable patient experience, immediately lower healthcare costs, and drive better outcomes and achieve this through the power of technology and human-centered design. Since launching in 2014, we’ve partnered with Fortune 500 employers and top hospitals across the nation. We’ve been recognized by Harvard Business School and featured in TechCrunch, The Los Angeles Times, Washington Post, and Modern Healthcare. We believe we’re only scratching the surface of our opportunity and we’re looking for incredible people like you to help us realize our full impact.</span></p><p dir="ltr"><span style="color: rgb(38, 38, 38);">Carrum Health is an equal opportunity employer and encourages all applicants from every background and life experience.</span></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...