Entry Level Excel Data Analyst Jobs in Madison, WI

Lantern is the specialty care platform connecting people with the best care when they need it most. By curating a Network of Excellence comprised of the nation's top specialists for surgery, cancer care, infusions and more, Lantern delivers excellent care with significant cost savings to employers and their workforces. Lantern also pairs members with a dedicated care team, including Care Advocates and nurses, for the entirety of their care journey, helping them get back to good health, back to their families and back to work. With convenient access to specialists nationwide, Lantern means quality care is within driving distance for most. Lantern is trusted by the nation's largest employers to deliver care to more than 6 million members across the country. Learn more about us at lanterncare.com. 

About You:

• You use LOGIC in your decision making and understand that progress is critical to making change. You focus on the execution of your content while balancing a fast-paced environment and you take the time to celebrate both the small & big wins. 
• INCLUSION is a core tenant of your personal beliefs. A diverse and inclusive environment is incredibly important to you. You understand and desire to be a part of a diverse team with different experiences and perspectives & you cherish the differences in each individual that you interact with.
• You have the GRIT, drive and ambition to tackle big problems. Big problems require big ideas and a team that supports new ideas. 
• You care deeply for your customers are driven to keep HUMANITY in all decisions. Your customers aren’t just the individuals using your product. They are the driving factor in your motivation to make a change.
• Integrity guides you in life. Focusing on the TRUTH vs. giving people the answers they want to hear. 
• You thrive in a Team Environment. Collaboration is key in innovation and creating change.

These pillars of LIGHT are a reminder to our team that we are making a difference by providing guidance and support in navigating the often complex and confusing landscape of healthcare. We hope that through this LIGHT, individuals can find their way to the best care, resources, and support they need to get back to life. 

If this sounds like you, we would love to connect to speak further about career opportunities at Lantern.

Please apply to our role & someone from our Talent Acquisition Team will reach out to help you navigate our interview process.

Job Overview

The Strategy Analyst / Associate is a high-visibility, hands-on, and dynamic role within Lantern’s Emerging Products Team. The role will support daily operations, drive operational improvements, identify growth opportunities, and contribute to strategic planning to enable high-impact business decisions during an exciting chapter of Lantern’s growth. The ideal candidate is intellectually curious and entrepreneurial with a strong bias to action – with 1-3 years of experience at a top-tier consulting firm (McKinsey, BCG, Bain, or similar) or a high-growth startup. This is a remote-first role with occasional (~1x month) travel. 

Responsibilities and Duties:

• Build out processes and own the development of deliverables end-to-end to support emerging product lines  
• Analyze claims and cost savings data to drive insights for reporting and product improvement
• Conduct market research and competitive analysis to identify industry trends and business opportunities
• Develop financial models and data-driven insights to support strategic initiatives and business performance
• Evaluate potential partnerships and new business opportunities
• Assist in the preparation of presentations and reports for senior leadership and stakeholders
• Work cross-functionally with commercial, analytics, operations, and product teams to execute strategic projects
• Support strategic planning, reporting, and forecasting processes

Qualifications:

• Bachelor’s degree in Business, Economics, or a related field
• 2-3 years of experience in top management consulting, strategy, tech, and/or startup Operation or Product roles 
• High-performing self-starter and independent contributor with strong analytical and problem-solving capabilities
• Exceptionally detail-oriented and organized, with a strong sense of ownership over deliverables
• Comfortable operating in ambiguity and flexing between high-level strategic thinking and execution
• Demonstrated ability to work in a fast-paced, dynamic environment with a high level of end-to-end accountability and autonomy
• Excellent interpersonal, relationship development, and verbal communication skills
• Required: High proficiency in Excel and PowerPoint; bonus if you have other technical / data visualization skills (e.g., Python, Power BI, Tableau, SQL)
• Bonus: Experience or interest in healthcare 

Benefits

• Medical Insurance
• Dental Insurance
• Vision Insurance
• Short & Long Term Disability
• Life Insurance
• 401k with company match
• Paid Time Off
• Paid Parental Leave