Investigative Assistant Job in Hartford, Connecticut US
Investigative Assistant
Investigative Assistant Job Description Solid reputation, passionate people and endless opportunities. That's Travelers. Our superior financial strength and consistent record of strong operating returns mean security for our customers - and opportunities for our employees. You will find Travelers to be full of energy and a workplace in which you truly can make a difference. Summary Provide efficient and cost effective administrative and technical support to the Travelers Investigative Services (TIS) Specialty Operations. Advanced skill level is required to perform diverse and complex assignments. Ability to adapt to procedural processes to perform the more complex duties of the job. This position will be based in Hartford, CT. Job Responsibilities - Handles complex administrative assignments of a broad and varied nature to assist management with daily, weekly and monthly reporting details. - Run and produce quarterly and yearly operational reports - Run and produce remaining monthly MI reports the FAU creates - Creating financial exposure and billing reports to support Specialty/Cyber investigations - Access data to create ad-hoc reports for managers and leadership team as needed - Collect agenda items and information to be discussed at the bi-weekly TIS Specialty calls. - Provide assistance to the TIS Specialty Manager Team Meetings (as requested). - Database Research (including Internet Mining Investigations/Social Media Searches) - File and photo duplication/copying to the various state insurance departments or law enforcement, where necessary; and, as requested. - Coordinates inter-departmental or department-wide administrative projects. Complex scheduling, involves internal, external, and department-wide scheduling. - Manages and tracks/reports actual expenses versus budget for management's area of responsibility. - Maintains SharePoint site responsibility within Specialty Lines - Initiates, develops, decisions regarding practices/procedures within authority level. - Handles ordering of supplies/procurement for Specialty lines. - Utilizes basic change management skills. Education/Work Experience College education or equivalent. Advanced skill level required for various software applications, including advanced database queries, complex Excel spreadsheets, pivot tables, Access, PowerPoint, and word processing. Utilize multiple software packages to prepare highly confidential correspondence and complex documents. Independently designs advanced spreadsheets, graphics, presentations, and database applications. Other Professionally handle personal and confidential information; organizational skills, mathematical aptitude; customer service skills; multi-task abilities; analytical skills; problem solving skills with attention to details; and, expense management skills. Good attendance and clean background is required. Ability to work in an office environment (Hartford, CT based position), and occasionally able to work paid overtime. Investigative Assistant Job Appendix -Run and produce quarterly and yearly reports 1. Monthly Operating Review 2. Maintain and update ongoing initiatives data (i.e.: Fire Arson Reports - 2007-2012) 3. Operating Reviews, Management reporting and tracking 4. Create trending and staffing Pin maps (Skill Set: Host access and familiarity with JCL, datasets, IOF, Excel, Access, IOF) -Run and produce remaining monthly MI reports the FAU creates. These reports are not good candidates for off shoring based on complexity and time needed to create. 1. Staffing models 2. Trending 3. Underwriting Report 4 PMR report (Skill set: Host access and familiarity with JCL, datasets, IOF, Excel, Access, IOF) -Creating financial exposure and billing reports to support field investigations 1. Enterprise Guide 2. SAS 3. Excel 4. Access 5. Possibly Netmap 6. Accurint 7 Internet Searches 8 Government databases -Access data using SAS Enterprise Guide to create Ad-hoc reports for managers and leadership team as needed (Skill Set: Working knowledge of Enterprise Guide and SAS, Excel, Access, IOF) -Manage manual reporting and compile MI 1. National Fire Vendor List 2. Run ACE system (converting Northland Case numbers to a TIC). 3. Responsible for maintaining and updating SharePoint. 4. Responsible for the creation of PP and Adobe Presentations 5. Daily Management support 6. Enter Northland Fire Referrals 7. Photo Web- Burn and send CD¿s (of fire scene photos) to investigators/ attorneys. 8. Excel sheets, Charts; Trending projects. 9. Microsoft Access database work Pivot tables 10. Assemble and distribute surveys among investigators, vendors, and attorneys. Travelers is an equal opportunity employer. We actively promote a drug-free workplace. Job Requirements Please see description. About Travelers The Travelers Companies, Inc. (NYSE: TRV) is a leading property casualty insurer selling primarily through independent agents and brokers. The company's diverse business lines offer its global customers a wide range of coverage in the auto, home and business settings. A component of the Dow Jones Industrial Average, Travelers has more than 30,000 employees and generated revenues of approximately $25 billion in 2010. To learn more about careers at Travelers visit us at travelers.com/Careers .