Demo

Data & Reporting Analyst

First Chicago Insurance Company (FCIC)
Bedford, IL Full Time
POSTED ON 4/2/2025
AVAILABLE BEFORE 3/31/2030

At First Chicago Insurance Company, our employees are our biggest asset! It is our mission to attract and retain intelligent, motivated, ethical employees who strive for excellence and growth, and to keep those employees happy and engaged. We provide the tools and the support our employees need to grow both professionally and personally. We encourage self-improvement and celebrate success by rewarding ideas and results. We realize the strength of teamwork and its ability to join individuals together and push and pull each other, with a synergy that can only be found in groups of good people sharing ideas.  Join in on the excitement and become part of our thriving organization!

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 Accounting Department while collaborating with various other business departments (e.g. Product, Actuarial, Underwriting, Marketing, 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.



THE IDEAL CANDIDATE WOULD BRING:

  • 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.



Salary : $61,500 - $162,500

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Data & Reporting Analyst?

Sign up to receive alerts about other jobs on the Data & Reporting Analyst career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$97,729 - $131,248
Income Estimation: 
$121,246 - $165,092
Income Estimation: 
$97,729 - $131,248
Income Estimation: 
$121,246 - $165,092
Income Estimation: 
$121,246 - $165,092
Income Estimation: 
$152,894 - $210,289
Income Estimation: 
$76,293 - $101,657
Income Estimation: 
$97,729 - $131,248
Income Estimation: 
$62,090 - $81,673
Income Estimation: 
$76,293 - $101,657

Sign up to receive alerts about other jobs with skills like those required for the Data & Reporting Analyst.

Click the checkbox next to the jobs that you are interested in.

  • BI Analytics/Reporting Tools Skill

    • Income Estimation: $67,290 - $90,141
    • Income Estimation: $68,745 - $88,154
  • Business Analytics Skill

    • Income Estimation: $66,414 - $85,036
    • Income Estimation: $68,139 - $88,275
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at First Chicago Insurance Company (FCIC)

First Chicago Insurance Company (FCIC)
Hired Organization Address Chicago, IL Full Time
Are you an experienced Litigation Specialist looking to join a growing company where you will be rewarded for your hard ...
First Chicago Insurance Company (FCIC)
Hired Organization Address Bedford, IL Full Time
We are seeking an Underwriting Supervisor to join our team! The Underwriting Supervisor will be responsible for overseei...
First Chicago Insurance Company (FCIC)
Hired Organization Address Bedford, IL Full Time
Are you unhappy at your present job? Are you going nowhere in your current position? Is it time for a change? Are you an...
First Chicago Insurance Company (FCIC)
Hired Organization Address Bedford, IL Full Time
We are seeking Claims Call Center Specialists for our growing insurance company! The Claims Call Center Specialist will ...

Not the job you're looking for? Here are some other Data & Reporting Analyst jobs in the Bedford, IL area that may be a better fit.

Data & Reporting Analyst

Warrior Insurance Network, Bedford, IL

Data Reporting Analyst

Robert Half, Chicago, IL

AI Assistant is available now!

Feel free to start your new journey!