The primary responsibility is to develop, modify and maintain databases and analytical programs that collect and analyze actuarial, statistical and economic data. The position is responsible for data integrity, security, and relevance and must be able to independently implement analytical programs involving actuarial, statistical, and economic data analysis techniques working directly with the analytical team as well as the intended end user or external vendors.
Additional responsibilitites include:
Responsible for the accuracy, thoroughness and integrity of all work including thorough investigation of data sources and the accuracy and integrity of data received by documenting and quantifying any inherent weakness that would impact conclusions drawn from the databases. Adequately inform management of limitations of work and data constraints. Work with database suppliers to ensure accuracy and ease of translation to personal computer formats. Implement enhancements as needed. Keep abreast of current technological resources and tools including vendors of data, computer hardware and software as well as actuarial and statistical techniques that improve the collection, analysis and use of data.
Develop the databases and reports necessary to support in the development of special reports such as lender performance reports, rating agency reports, reinsurance treaty reports, and other management information systems as requested.
Develop databases and reports necessary to support pricing adequacy, new products, new product features, product performance trends, performance by market segments and risk characteristics.
Develop the databases and reports necessary to support special studies of commissions, expenses, delinquency, frequency or severity trends or any other aspect of the company's operations as requested to assist company management.
Develop the databases and reports necessary to support models to predict the runoff of the company's in force business to assist in strategic planning, budgeting, and special projects.
Perform other ad hoc and quarterly analyses as needed. Assist with pricing or other actuarial and data reporting functions as time permits Develop the databases and reports necessary to support annual updates of key parameters used in various pricing, reserving and other models.
A Bachelors degree with a strong background in programming, mathematics, science, engineering or statistics.
1+ years of data manipulation using SAS or 3+ years in some other comparable complex programming language so that data manipulation, logical reasoning and joining relational databases can be demonstrated.
Proficiency in SAS or SQL, Windows Office (Excel / Word), VBA for Excel is a plus
Attention to detail and high level of accuracy in work product with creativity and independent problem solving.
Ability to build and query databases and design and create reports.
Ability to work on multiple projects simultaneously, anticipate necessary effort and difficulty and adhere to mutually agreed upon schedules.
Ability to work independently without close supervision. Ability to perform research on relevant topics and synthesize and incorporate findings.
Ability to achieve cooperation of others with little management intervention
Subsidiaries of United Guaranty provide mortgage guaranty insurance throughout the U.S. that protects lenders against mortgage credit losses. In addition, United Guaranty's comprehensive range of financial products and services to lenders and investors includes structured products, innovative pricing options, and comprehensive online support. United Guaranty’s international locations include operations in Hong Kong, Seoul, Tokyo, Sydney, London, Madrid, Milan, Budapest, and Mexico City.