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.