CAT Modeling Technical Systems Analyst

At Fireman's Fund, you’re building a challenging career at the same time as bringing a sense of stability to people's lives. You’re also contributing to our success and our reputation as a leader in the field with your skills and expertise. For this you are appreciated, acknowledged, and rewarded. We believe that if you hold on to great people, everyone wins. Just more proof that a career with Fireman’s Fund isn't just a good idea. It's a smart move.A CAT Modeling Technical Systems Analyst for the Corporate Catastrophe Management group will provide modeling assistance and technical support as needed by Corporate Cat Mgmt, Risk Office, Reinsurance, Actuarial and the various Businesses. They will become an expert in the catastrophe modeling technology utilized by the company, and will develop new reports, analytic tools and database files needed to facilitate detailed analyses of modeled exposure and loss information. They will perform modeling system updates, and produce and maintain summary and detailed information for quarterly simulations, financial reports, regulatory and rating agency reporting, and ad-hoc requests. Responsibilities:Researching, developing and managing policy and location data related to an environment for use in software models of natural hazards, making use of Excel, Access, SQL Server, relational database architecture and techniques, and relevant geographic (GIS) technologiesDesigning relational models and developing SQL/VBA scripts for data transfer across Excel and Access, in order to resolve data/process requirementsDeveloping and assisting with establishing and communicating data standards, measures and conventions, and auditing data quality and capture processesAssisting in developing, delivering and administrating catastrophe-related Underwriting tools Database programming/development in support of analytical studies and presentations to support projects as directed by managers within FFIC and the Allianz groups, including reinsurance renewals, strategic planning and organizational/systems integration Providing modeling support for development of regional loss targets, across business segments and geographical locations, needed for planningProviding quarterly monitoring and reporting of exposure accumulations, modeled loss results and performance against plan metricsDeveloping documentation and presentations to support various business casesProviding support for assessing and reporting on potential impacts of model updates and calibrationsWorking directly with vendors on enhancements, or the development of new technologies and techniques with value-added potentialFurther developing the FFIC Center of Knowledge and Expertise for modeling technology, documenting established processes and procedures, and providing expert interpretation of modeled results as requiredRequirements:Experience with database management systems (MS Access, MS SQL Server, etc.), their management and designStrong knowledge of MS Excel, PowerPoint, Access, SQL and VBA requiredFamiliarity with catastrophe modeling concepts, perils, and metrics. Exposure to catastrophe vendor models (RMS, AIR, EQE) or predictive modeling a plus. Bachelor's degree High level of problem solving aptitudeAbility to work on multiple projects with short time frames for implementation in a fast paced, challenging environment Ability to work independently while maintaining high levels of motivation and enthusiasm in a team environment 3+ years work experience in an analytical roleKnowledge and/or experience in insurance, underwriting and actuarial environments is strongly preferredStrong verbal and written communication skills, with the ability to communicate effectively with technical and nontechnical employeesMore information about Fireman's Fund, our privacy policy, and our relationship with Allianz Group can be found at www.firemansfund.jobs An equal opportunity employer. Education: Bachelors DegreeJob Level: 0-2 years