Job Information
ACE American Insurance Company Senior Financial Analyst - 10412 in Philadelphia, Pennsylvania
Senior Financial Analyst - 10412
DESCRIPTION/RESPONSIBILITIES: JOB DESCRIPTION
Senior Financial Analyst The Global Casualty Home Office Finance team is a dedicated group of professionals who provide actionable information to executives and senior managements on a timely basis. We currently have an excellent, unique opportunity in our Philadelphia office for an experienced MIS professional in the role of MIS/Financial Reporting.
In this key role, the selected individual will work within Global Casualty and Alternative Risk Solutions business units for their reporting needs and develop and implement solutions. This individual is responsible for designing and maintaining reports, processes, defining business requirements for new information, plus interact with the supporting units Chubb Receivables and Collections Management (CRCM), Program Adjustment Unit (PAU), Richmond Operations Center (ROC), and IT. This position will require SQL Server and VBA programming to support all reporting aspects of MIS which includes financial, underwriting, actuarial, account service, and claims related databases for this multi-billion-dollar group of property and casualty insurance companies.
This is an excellent programming and reporting opportunity to experience and learn all facets of insurance operations.
Major Duties & Responsibilities: * Define, update, and maintain business requirements for new and existing information processed through the financial, underwriting, actuarial, account service, and claims databases. * SQL Server and/or VBA programming at the end-user interface to support all MIS reporting for CGC and CARS; aspects of MIS reporting include financial, underwriting, actuarial, account service, and claims data reporting. * Design and maintain the monthly financial reporting process; ensure that all results are recorded accurately. * Support the finance organization in the budgeting, planning, and forecasting processes. * Support the Claims organization in reporting and oversight. * Provide program specific loss reporting, loss registration and loss monitoring. * Assist in data gathering and extrapolation for certain actuarial exercises. * Provide premium reporting for certain product lines. * Support Claims Service Fees Reporting. * Perform other ad-hoc reporting in support of individuals in the business unit.
QUALIFICATIONS Minimum Requirements: * Develop, and modify SQL Queries to extract data from SQL Server database. * Knowledge of writing advanced queries, stored procedures, and functions in SQL. * Understand SQL data tables and structures to efficiently extract, load and transform multiple datasets. * Identify, evaluate, and resolve data quality issues. * Proficient in MS Access database development and VBA programming. * Develop, modify, and maintain advanced MS Excel VBA modules. * Knowledge of MS Excel functions * Knowledge of object-oriented programming. * Must be eager to learn all aspects of the insurance business.
Desired Qualifications: * Understanding of Commercial Property & Casualty Insurance, especially Workers' Compensation, and Risk Management business processes and Risk Management. * Experience with Qlik. * Proficient in Python.
At Chubb, we are committed to equal employment opportunity and compliance with all laws and regulations pertaining to it. Our policy is to provide employment, training, compensation, promotion, and other conditions or opportunities of employment, without regard to race, color, religious creed, sex, gender, gender identity, gender expression, sexual orientation, marital status, national origin, ancestry, mental and physical disability, medical condition, genetic information, military and veteran status, age, and pregnancy or any other characteristic protected by law. Performance and qualifications are the only basis upon which we hire, assign, promote, compensate, develop and retain employees. Chubb prohibits all unlawful discriminati n, harassment and retaliation against any individual who reports discrimination or harassment.