Actuarial - Modeling Data Engineer (Small Business)

Cincinnati Financial Corporation Fairfield, OH
The Cincinnati Insurance Companies' Pricing and Predictive Analytics department has an opening in our corporate headquarters located in Fairfield, Ohio, for two modeling data engineers.

Responsibilities:

* support predictive analytics efforts in small business, loss control, premium audit, claims, commercial lines and personal lines

* produce actuarial/modeling analyses related to premium adequacy, rate adequacy, competitive market position, model bias, residual lift, etc.

* design and implement data cleansing processes

* understand the data needs of predictive modelers and work with them to determine appropriate data sources; and to construct appropriate queries, code and/or databases to obtain, scrub, aggregate and deliver the relevant data

* establish and maintain periodically updated data sets from a variety of internal and external sources

* gain high-level knowledge of actuarial techniques for rate-making and insurance modeling (recommended but not required)

* study and pass actuarial exams (recommended but not required)

* explore new data systems as they become available and document the contents and limitations of each

* develop, maintain, improve, and document code, macros, and databases used within the Predictive Analytics unit

* contribute to discussions with IT regarding architectural design of data systems, representing the needs of Predictive Analytics

* gain expertise in all data systems available to Predictive Analytics and understand the contents and limitations of each

* establish and maintain libraries of optimized code for common tasks

* re-engineer low-efficiency processes through the practice of continuous improvement

* develop prototype reports to meet the needs of various departments for modeling output, and work with Business Intelligence to transition reports to production

* assist with the evaluation of external data sources

* serve as an advisory resource for modelers to learn about data sources

* plan and facilitate working sessions with cross-functional teams to accomplish goals

* help to support modelers' use of modern modeling tools such as R and Python, and modern data storage and acquisition systems such as Hadoop and Spark

Qualified candidates will possess many, but not necessarily all, of the following:

* three-five years of highly technical experience at a property/casualty insurance company

* desire to learn about the business of insurance, actuarial science and predictive analytics

* proficiency with Microsoft® Excel

* experience with: VBA, SQL and writing SAS code; other programming languages, such as Java or C#; R and/or Python; Hadoop file system; CFC data sources, such as Reporting Systems, eCLAS, Diamond, AMPS, CMS, BW, PAD

* ability to: quickly understand and assess data structures; work both independently and as part of a team; solve problems systematically and creatively; research data contents, evaluate data quality, scrub data and validate results; write business requirements and to relate business and actuarial needs to data construction and coding requirements; articulate complex technical concepts to non-technical clients

* have a thorough understanding of insurance concepts and P/C insurance products

* have excellent documentation standards and communication skills

Education: bachelor's degree in a quantitative field (e.g. economics, finance, mathematics, statistics, etc.)

The Cincinnati Insurance Company, a subsidiary of Cincinnati Financial Corporation, stands among the nation's top 25 property casualty insurer groups, based on net written premiums, and has earned an A rating from A.M. Best. Our commitment to the independent agency system began in 1950 and is our company's core strength and competitive advantage. We excel by offering agents and policyholders a local presence, unparalleled claims service, loss control consultation services, work-saving technology initiatives, and competitive products, rates and compensation. Selected associates receive a comprehensive salary and benefits package, including a matching 401(k). Equal Opportunity Employer. Best's ratings are under continuous review and subject to change and/or affirmation. To confirm the current rating, please visit www.ambest.com.