Data Analyst-Intern at Superior Insurance Partners in Chicago, IL

Summary: Superior Insurance Partners is a rapidly growing insurance brokerage platform, focused on providing commercial lines, personal lines, and employee benefit solutions. They are seeking a Data Analyst Intern for an 8-week summer internship to work on high-impact projects related to data accuracy and reporting. Responsibilities: - Cleaning and standardizing insurance carrier data for reporting accuracy - Identifying and analyzing duplicate client records across systems - Reconstructing historical revenue using financial and operational data - Building organized, reliable datasets used in internal and investor reporting Required Qualifications: - Rising junior, senior, or recent graduate in a quantitative or analytical field (Finance, Accounting, Data Analytics, MIS, Economics, etc.) - Strong Excel skills (pivot tables, formulas, data organization) - High attention to detail and accuracy - Ability to work through ambiguity and incomplete datasets - Clear written communication and documentation skills Preferred Qualifications: - Basic SQL knowledge - Prior coursework or experience in accounting, finance, or data analysis Required Skills: Excel, SQL, Data cleaning, Data analysis, Data reconciliation, Financial data analysis, Operational data analysis