Health Benefits Data Analyst

Job Description Health Benefits Data Analyst (SP 000000CE) Are you passionate about delivering trusted advice that improves lives and using healthcare data analytics? Do you enjoy digging into complex medical and pharmacy claims data, building SQL analyses, and translating results into client-ready insights? Our opportunity may be for you. Join Segal’s Benefit Audit Solutions Practice as a Health Benefits Data Analyst. The Health Benefits Data Analyst is a key contributor within a fast-growing segment of Segal’s employee benefits business and an integral part of our client value proposition. In this role, you will perform extensive health claims data analytics using SQL and directly support client audit projects. Success requires comfort working across multiple client engagements at once and collaborating closely with consultants, auditors, client relationship managers, vendors, and clients to deliver high-quality, actionable results. Essential Functions Perform extensive health claims data analytics utilizing SQL, including technical review of medical and health insurance contracts, financial arrangements, plan documentation, and evaluation of program effectiveness. Collaborate with project teams to manage client assignments and service delivery initiatives (e.g., proposals, audits, negotiations, contract reviews) with a focus on quality, accuracy, and timeliness. Support the growth of Segal’s Benefit Audit Solutions Practice by contributing to business development initiatives, including proposal writing and service innovation. Qualifications 1–3 years of financial experience within a PBM and/or benefits consulting environment, including technical review and analysis of data, contracts, financial arrangements, and program effectiveness (highly preferred). Bachelor’s degree in business, actuarial science, mathematics, public healthcare, or a related discipline. Master’s degree in healthcare informatics or another graduate-level health or data science discipline (highly preferred). SQL coding (or other large data set manipulation experience) is required. Knowledge of Python is a plus. Advanced knowledge of Microsoft tools including Excel, Word, and PowerPoint is required. Strong analytical and problem-solving skills; demonstrated project management and multi-tasking ability; strong organizational and attention-to-detail skills; and effective written/oral communication and relationship-building skills. Previous internships and general industry knowledge are a plus. Knowledge of providers, products, services, data reporting, and contracting/negotiating elements and processes is preferred. Intellectual curiosity and the aptitude to stay current as trends and technologies evolve. If your qualifications align closely with what we have described, we encourage you to apply. Your unique background and skills matter because at Segal, we believe that different experiences and perspectives drive innovation and excellence. We are committed to creating a fair and transparent hiring process and all hiring decisions will be merit driven. If you require accommodation during the interview, please let us know. About Segal and its Total Rewards Program Segal is a privately owned, leading North American employee benefit, human resources and investment management consulting firm with over 80 years of history providing trusted advice that improves lives. Clients include public and private corporations, multiemployer trust funds, public sector entities, higher education institutions, institutional advisors, among many others. Segal’s total rewards are part of what makes Segal a special place to work. The current salary range for this position is $62,500 - $75,000. Primary Location US-IL-Chicago Other Locations US-NY-New York, US-AZ-Tempe, US-TX-Addison, US-DC-Washington, US-CA-Glendale, US-CA-San Francisco, US-GA-Atlanta #J-18808-Ljbffr The Segal Group, Inc