Actuarial Analyst - Overland Park, KS (66204)

Company Details Intrepid Direct Insurance (IDI) is a rapidly growing direct to consumer Property and Casualty insurance company. A member of the W. R. Berkley Corporation, a fortune 500 company, rated A+ (Superior) by A.M. Best, Intrepid Direct's vision is to make life better for business . The insurance industry has not evolved with innovation like other major industries. We're here to change that. We are making life better for our customers, shareholders, and our team members by leveraging data and technology as insurance experts for our targeted customers. You will be part of a highly collaborative team of talented and focused professionals. Join a group that enjoys working together, trusts each other, and takes pride in our hard-earned success. https : / / intrepiddirect.com / The Company is an equal employment opportunity employer. Responsibilities The Actuarial Analyst supports actuarial analyses required to estimate expected losses arising from insurance products. The Actuarial Analyst will primarily contribute to the pricing discipline as well as the data reporting needs of the company. Key functions include but are not limited to : Update and enhance processes as directed and support individual project research and analysis. Produce and deliver actuarial analysis inputs on individual accounts to support the insurance quote process, in-force book maintenance, and client service deliverables. Develop and maintain data queries in Microsoft SQL Server to transform relational data into reportable data as needed for analytic projects as well as annual, quarterly, and monthly state reporting needs. Collaborate with leaders across the organization to deliver business intelligence reporting using tools including Power BI, R, and Excel. Assist in improving data infrastructure from existing data sources. Conduct research and analyze competitor filings as needed to support development of new rating rules and monitor competitive market position. Assist in product rate and rule filings, including completion of transmittal documents, analysis of rate and rule changes, and development of proprietary rate support where needed. Qualifications A degree in the field of mathematics, statistics, actuarial science, or other similar quantitative field. Work experience in a professional office environment preferred. Pursuit of actuarial designation through the CAS or SOA preferred. Demonstrated interest in and ability to learn new concepts and tasks quickly. Keen attention to detail. Excellent active and reflective listener. Strong customer service orientation. Willingness to ask for help when needed. Advanced analytical and mathematical skills. Basic creative problem-solving skills. Knowledge of Actuarial principles, techniques, and procedures preferred. Knowledge of available industry data sources preferred. Intermediate knowledge of basic data analysis tools like Microsoft Excel. Knowledge of advanced data analysis tools such as SQL (including query writing) and / or Power BI preferred. Knowledge of predictive analytic / modeling techniques preferred. Knowledge of R, Python, or related modeling software preferred. Project management and financial reporting experience preferred. Strong interpersonal verbal and written communication skills. Experience collaborating in a team-oriented environment. Strong decision-making skills. Ability to communicate effectively in the English language. Ability to effectively prioritize and complete multiple concurrent assignments in a timely manner. Additional Company Details We do not accept any unsolicited resumes from external recruiting agencies or firms. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Sponsorship Details Sponsorship not Offered for this Role