Data & Reporting Analyst

About The Company First Chicago Insurance Company is a reputable and growing insurance provider committed to delivering comprehensive insurance solutions across various lines of business. With a focus on innovation, integrity, and customer satisfaction, the company has established a strong presence in the insurance industry. Our team is dedicated to leveraging advanced analytics and data-driven insights to enhance our products, services, and operational efficiency. We foster a collaborative and inclusive work environment that encourages professional growth and continuous learning, ensuring our employees are equipped with the latest tools and knowledge to succeed.

About The Role We are seeking a highly skilled Data and Reporting Analyst to join our dynamic Product & Actuarial Department. In this role, you will operate independently while collaborating with cross-functional teams including Underwriting, Marketing, and Claims to develop comprehensive data reports and actionable insights. Your primary responsibility will be to enhance business performance reporting, improve data integrity, and support analytical initiatives that inform strategic decision-making. The ideal candidate will have a broad understanding of property & casualty insurance products, with experience in creating reports for diverse insurance lines such as Personal Auto, Commercial Auto, and General Liability.

This position offers an excellent opportunity to work in a fast-paced environment where your analytical skills and attention to detail will directly impact the company’s growth and success. You will be instrumental in streamlining reporting processes, automating data workflows, and developing innovative solutions to meet evolving business needs. The role requires excellent communication skills, a proactive approach, and the ability to manage multiple projects efficiently. Occasional travel up to 10% to our office in Bedford Park, IL, may be required.

Qualifications

• Bachelor’s degree in Computer Science, Mathematics, Actuarial Science, Information Systems, Business Administration, Business Analytics, Finance, or a related field
• Minimum of 3 years of experience working with property & casualty insurance products in a business or data analyst capacity
• Advanced proficiency in Microsoft Excel and Access
• Experience with relational databases such as Microsoft Access, SQL, Redshift, Netezza, Oracle, or DB2
• Strong analytical skills with keen attention to detail and problem-solving capabilities
• Ability to work under tight deadlines and manage multiple projects simultaneously
• Proficiency in data analysis, trend identification, and data visualization tools such as SAS, R, Tableau, Power BI, or QlikView
• Experience with data mapping, automation, and scripting languages is preferred
• Excellent communication and stakeholder management skills
• Knowledge of insurance products, underwriting, and claims processes is advantageous

Responsibilities

• Collaborate with stakeholders across departments to understand their reporting needs and translate requirements into effective data reports and visualizations
• Conduct detailed data analysis, interview business partners, and provide actionable recommendations
• Support the automation and streamlining of recurring and ad-hoc reporting functions on a weekly, monthly, quarterly, and annual basis
• Coordinate with management, IT teams, and end-users to ensure timely delivery of accurate and user-friendly reports
• Identify key performance metrics to monitor trends and measure business performance
• Gather requirements and design new reports aligned with current business initiatives
• Enhance existing reporting capabilities and suggest innovative solutions to meet future needs
• Develop strategies to increase automation, improve data accuracy, and implement quality controls
• Utilize automation tools to schedule, execute, and monitor data jobs regularly
• Maintain comprehensive documentation of reports, procedures, and processes
• Leverage technology to improve reporting efficiency and explore alternative delivery methods
• Assist in developing dashboards and metrics that incorporate financial and operational data
• Communicate analysis results effectively to management and relevant teams
• Participate in continuous improvement initiatives to optimize data workflows and reporting solutions

Benefits

• Competitive salary packages
• Comprehensive medical, dental, and vision insurance
• Short-term and long-term disability coverage
• Life insurance benefits
• Flexible Spending Account options
• Telemedicine services
• 401(k) plan with a generous company match
• Paid time off and holidays
• Tuition reimbursement program
• Wellness initiatives and programs
• Participation in fun, company-sponsored events
• Ongoing training and professional development opportunities

Equal Opportunity

First Chicago Insurance Company is an equal opportunity employer. We are committed to fostering an inclusive workplace that values diversity and equal employment opportunities for all applicants and employees. We do not discriminate based on race, color, religion, gender, sexual orientation, gender identity, age, disability, or any other protected class under applicable laws. We encourage individuals from diverse backgrounds to apply and join our team.