Job Description
Position: Data Analytics Analyst Reports to: VP, Commercial Lines Company Value Statements In the performance of their respective tasks and duties, all employees are expected to demonstrate the following: · Acting with the highest level of honesty, trust, character and transparency. · Making a unified effort to achieve the goals of the organization; embracing accountability for exceptional performance every day. · Commitment to excellence in reaching our full potential as individuals and as an organization, surpassing the ordinary and the expectations of our stakeholders. · Approaching every challenge with creative energy, discovering unique solutions to maximize success; focus on creating and delivering compelling customer value. · Belief in the power of a diverse workforce and in creating a positive impact on both the environment and our community. Summary/Objective The Data Analytics Analyst position supports data-driven decision-making across Bankers’ P&C insurance operations, including underwriting, claims, actuarial, finance, and risk management. This entry-level role assists in analyzing insurance data, developing reports and dashboards, and ensuring data integrity to improve pricing accuracy, loss performance, operational efficiency, and regulatory compliance. Essential Functions · Support data analytics initiatives related to underwriting performance, loss trends, claims severity/frequency, premium growth, and expense ratios. · Extract, clean, validate, and transform data from policy administration systems, claims platforms, reinsurance systems, and financial databases. · Assist in building dashboards and reports for KPIs such as: o Loss ratio o Combined ratio o Claim cycle time o Policy retention o Rate adequacy · Monitor data quality and resolve discrepancies to ensure accuracy in actuarial, underwriting, and regulatory reporting. · Develop recurring operational and management reports using BI tools. · Utilize SQL, Python, R, or similar tools to perform data queries and statistical analysis. · Assist with predictive modeling efforts related to claims trends, fraud indicators, or underwriting risk segmentation. · Support rate filing analysis and state regulatory data requests, as needed. · Collaborate with stakeholders across underwriting, claims, actuarial, finance, and compliance to understand reporting needs and translate business questions into analytical outputs. · Document data definitions, standards, and processes to support governance and consistency. · Coordinate and lead reinsurance modeling work to monitor catastrophe reinsurance spends and proactively recommend actions to control the cost. · Reviews work prepared by product management team and external consultants to ensure accuracy and consistency of data. · Perform multivariate analysis of underwriting variables for adequacy, correlation, loss propensity and makes recommendations accordingly for profitable growth. · Perform numerous statistical methods ranging from multivariate linear models to non-parametric models for predicting uncertainties and understanding statistical inferences. · Forecast premium growth based on the initiatives taken and keep track of changes as implemented, to assess success and create next steps. · Review budget variances and recommend actions with support of business use cases to improve top line revenue. · Analyze premium and loss trends on calendar year, accident year and policy year basis. · Applies knowledge of mathematics, probability, statistics, principles of finance and business analysis. · Proactively communicating with Management, Peers and others; important competitive information, knowledge, and makes interpretation of strategic implications as it is gathered and analyzed. · Review and monitor rate filings to identify changes in competitor’s rate plans, rate level and rating structure. · Prepare rate comparisons for segments/states/new programs. · Working with the Product Manager to create IT documentation of business rules as these impact system developments. Provides technical input and support for the development and implementation of product revisions, price setting and state rate/rule/coverage form filings. · Works with the Product Manager, Business Development Manager, Sales and Corp Marketing in promoting products to improve sales and revenue. Identifies product marketing ideas and opportunities based on industry trends, current market environment and competitive trends. · Works with IT to ensure that the delivered system is properly tested and meets the product requirements. Desired Skills · Active Listening — Giving full attention to what other people are saying, taking time