First Chicago Insurance Company

Data & Reporting Analyst

First Chicago Insurance Company  •  $80k - $130k/yr  •  Hybrid  •  4 months ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

We are seeking the ideal candidate for our Data and Reporting Analyst opening for our growing insurance company.

The Data and Reporting Analyst will work independently within the Product & Actuarial Department while collaborating with various other business departments (e.g., Underwriting, Marketing, and Claims) to create multi-line front-end data reports and actionable insights utilizing data stored in a variety of systems. This position will develop and deliver business performance reporting, improve data integrity, and assist with analytical solutions to help the management team evaluate and drive business performance.

The ideal candidate is an experienced Business/Data Analyst with a broad understanding of property & casualty insurance products and reporting. The analyst will be involved with creating reports for a wide variety of insurance products across the following lines of business: Personal Auto (Non-Standard, Standard/Preferred), Commercial Auto and General Liability.

DUTIES & RESPONSIBILITIES:

  • Work with stakeholders across the organization to understand their business reporting needs and translate requirements into effective reporting, visualization and actionable insights.
  • Conduct analysis, interview business partners and contribute to recommendations and solutions.
  • Support the streamlining and automation of ad-hoc and standardized reporting functions on a weekly/monthly/quarterly/annual basis.
  • Interact with management, IT developers and users to ensure timely delivery of relevant and user-friendly reporting.
  • Assist in the identification of key performance metrics to analyze trends and measure performance.
  • Gather requirements and frame out new reports based on current business initiatives.
  • Provide suggestions to enhance current reporting capabilities to meet future business needs.
  • Develop strategies and processes to increase automation and accuracy, and implement quality controls.
  • Utilize automation tools to schedule, execute and monitor jobs on a recurring basis.
  • Maintain detailed documentation for reports and procedures.
  • Improve current processes through effective use of innovative technology, while leveraging alternative delivery solutions.
  • Assist with developing metrics and dashboards, incorporating financial and operational reporting, and working with various business units to capture processes, procedures, and specifications.
  • Communicate analysis, results, and outcomes to management.
  • Willing to travel up to 10% of time to home office in Bedford Park, IL.

QUALIFICATIONS REQUIRED:

  • Bachelor's degree in a related discipline (Computer/Mathematics/Actuarial Science, Information Systems, Business Administration, Business Analytics, Finance)
  • A minimum of 3 years of experience working with property & casualty insurance products in a business or data analyst capacity
  • Advanced Microsoft Excel & Access knowledge
  • Relational database experience. Knows one or more of at least (Microsoft Access, SQL, Redshift, Netezza, Oracle, DB2)
  • Keen attention to detail with the ability to solve complex problems by analyzing variables and applying appropriate data-driven solutions
  • Ability to work against tight deadlines and manage several projects simultaneously
  • Strong data analytic background with the ability to integrate, correlate and find trends within the data
  • Aptitude to collaborate with multiple department stakeholders and associates to design and deliver data insight requests and solutions
  • Business and financial acumen with experience in quantitatively and creatively developing reporting solutions
  • Ability to efficiently automate gathering and organizing of highly complex sets of data across multiple platforms
  • Experience with data mapping
  • Hands-on experience with software/programming languages and tools with key analytic applications and data visualization tools (SAS, R, MySQL, PL/SQL, Oracle, UNIX, OLAP, Tableau, Hadoop, Cognos, QlikView, MS Power BI, Hive, Impala)

First Chicago Insurance Company provides a competitive benefits package to all full- time employees. Following are some of the perks First Chicago employees receive:

  • Competitive Salaries
  • Commitment to your Training & Development
  • Medical and Dental and Vision Reimbursement
  • Short Term Disability/Long Term Disability
  • Life Insurance
  • Flexible Spending Account
  • Telemedicine Benefit
  • 401k with a generous company match
  • Paid Time Off and Paid Holidays
  • Tuition Reimbursement
  • Wellness Program
  • Fun company sponsored events
  • And so much more!

Estimated Compensation Range: $61,500/year-$162,500/year*

*Published ranges are estimates. Offered compensation will be based on experience, skills, education, certifications, and geographic location. In addition, starting salary may vary by position depending on whether the position is in-office, hybrid or remote.

First Chicago Insurance Company

About First Chicago Insurance Company

The company was founded on December 14, 1920 as the Chicago Ice Producers Mutual Liability Company. Originally organized as a mutual insurance company, its initial purpose was to insure the members of the Chicago District Ice Association for general liability, Workers Compensation, public liability for horses and wagons, and commercial vehicle insurance. Association members donated the $26,225 that was needed at that time to start insurance operations. The company was granted licenses to operate in the States of Illinois, Indiana and Wisconsin, which continue to be held today.

In the 1930’s, the company expanded into insuring the private passenger vehicles of the owners and employees of the ice companies. This business was later enlarged to include individuals referred by policyholders of the company. The company’s name was changed to Chicago Mutual Liability Company in 1961. During the 1970’s and 1980’s, the company evolved from its original focus as a commercial lines insurer to become an automobile insurer. At the end of 1994, the Board of Directors decided to exit the Workers Compensation and general liability lines and concentrate on the personal and commercial auto lines of business.

In 1991 the Board of Directors decided to change the company’s distribution system from direct writing to partnering with independent producers. The company had maximized its growth as a direct writer and needed to adopt a different strategy. The company’s name was changed again in 1996 to Chicago Mutual Insurance Company.

In 2006, the company was converted from a mutual form of governance to a stock company. It was renamed First Chicago Insurance Company, and became a subsidiary of J & P Holdings, Inc. Innovation is the company’s focus as the 100th anniversary of its founding approaches. Management continues to search for opportunities that will serve our current policyholders and contribute to the company's growth and profitability.

Industry
Finance & Insurance
Company Size
51-200 employees
Headquarters
Bedford Park, IL
Year Founded
1920
Social Media