Analytics Associate

Summary

Join Carrum Health, a health tech company revolutionizing healthcare, as an Analytics Associate. You will contribute to unlocking commercial analytics and reporting capabilities, working with complex datasets to drive data-driven decisions. This full-time position offers a salary range of $105,000-$125,000, depending on experience and location. You will develop and maintain analytical models and dashboards, conduct in-depth data analysis, and collaborate with stakeholders. The ideal candidate possesses 5-8+ years of experience in business intelligence or a related field, expertise in Excel and SQL, and strong experience with Tableau. Carrum Health offers a supportive and collaborative remote work environment with various benefits.

Requirements

• 5-8+ years of experience in business intelligence, data analytics, or related field
• Master-level expertise in Excel, including complex formulas, pivot tables, and VBA
• Advanced proficiency in SQL, particularly with Amazon Athena
• 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

Responsibilities

• 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

Preferred Qualifications

• 2+ years of experience in a consulting or investment banking environment
• Strong experience with Tableau, including dashboard development and data visualization best practices
• 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

Benefits

• Stock option plan
• Flexible schedules and remote work
• Chicago and San Francisco offices available
• Self-managed vacation days, within reason
• Paid parental leave
• Health, vision, and dental insurance
• 401K retirement plan