Actuarial - Modeling Data Engineer I to IV (Small Business)

Company: Cincinnati Insurance Company, Inc.
Location: Fairfield
Posted on: September 13, 2021

Job Description:

Description:

Make a difference with a career in insurance

At The Cincinnati Insurance Companies, we put people first and apply the Golden Rule to our daily operations. To put this into action, we’re looking for extraordinary people to join our talented team. Our service-oriented, ethical, knowledgeable, caring associates are the heart of our vision to be the best company serving independent agents. We help protect families and businesses as they work to prevent or recover from a loss. Share your talents to help us reach for continued success as we bring value to the communities we serve and demonstrate that Actions Speak Louder in Person®.

If you’re ready to build productive relationships, collaborate within a diverse team, embrace challenges and develop your skills, then Cincinnati may be the place for you. We offer career opportunities where you can contribute and grow.

Start your journey with us

The Cincinnati Insurance Companies' Pricing and Predictive Analytics department has an opening in our corporate headquarters located in Fairfield, Ohio, for a modeling data engineer.  

Be Ready To\:

• 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 
• 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

Be Equipped With\: 

• three-five years of highly technical experience, preferrably 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; Snowflake;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

You've Earned\: 

• bachelor’s degree in a quantitative field (e.g. information technology, economics, finance, mathematics, statistics, etc.)

Enhance your talents

Providing outstanding service and developing strong relationships with our independent agents are hallmarks of our company. Whether you have experience from another carrier or you’re new to the insurance industry, we promote a lifelong learning approach. Cincinnati provides you with the tools and training to be successful and to become a trusted, respected insurance professional – all while enjoying a meaningful career.

Enjoy benefits and amenities

Your commitment to providing strong service, sharing best practices and creating solutions that impact lives is appreciated. To increase the well-being and satisfaction of our associates, we offer a variety of benefits and amenities. Learn more about our benefits and amenities packages. 

Many departments at our Headquarters in Fairfield, Ohio, offer hybrid work options, empowering associates to work from home several days a week. Depending on your role and responsibilities, hybrid options may be available.  

Embrace a diverse team

As a relationship-based organization, we welcome and value a diverse workforce. We provide equal employment opportunity to all qualified persons without regard to race; creed; color; sex, including sexual orientation, gender identity and transgender status; religion; national origin; age; disability; military service; veteran status; pregnancy; AIDS/HIV or genetic information; or any other basis prohibited by law. Learn More.

Keywords: Cincinnati Insurance Company, Inc., Fairfield , Actuarial - Modeling Data Engineer I to IV (Small Business), Other , Fairfield, Ohio