First Chicago Insurance Company
Data & Reporting Analyst
First Chicago Insurance Company, Bedford Park, Illinois, us, 60499
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
QUALIFICATIONS:
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
Flexible Work Schedules
Remote and Hybrid
Commitment to your Training & Development
Medical and Dental
Telemedicine Benefit
401k with a generous company match
Paid Time Off and Paid Holidays
Tuition Reimbursement Training Programs
Wellness Program
Fun company sponsored events
And so much more!
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
QUALIFICATIONS:
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
Flexible Work Schedules
Remote and Hybrid
Commitment to your Training & Development
Medical and Dental
Telemedicine Benefit
401k with a generous company match
Paid Time Off and Paid Holidays
Tuition Reimbursement Training Programs
Wellness Program
Fun company sponsored events
And so much more!