Data Analytics Analyst

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: Combined ratio Claim cycle time 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 to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times. ISO Knowledge – Demonstrated in-depth knowledge of ISO CLM Rates, Rules and Forms. Communication — Talking to others to convey information effectively; Using timely, clear and concise written and verbal communication. Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems. Use of Technology - Microsoft Word, Excel, PowerPoint, Project, Outlook, Business Intelligence, AS400 and Lawson. Basic proficiency in: SQL, Excel (advanced functions, pivot tables), Data visualization tools (Power BI, Tableau, or similar), Understanding of fundamental statistical concepts. Efficiency in keyboarding and data entry skills. Industry Knowledge - Knowledge of P&C insurance market, competitors, trends and updates, departmental regulations and policies, forms, filing procedures and coverage procedures. Exposure to P&C insurance concepts such as: Loss ratio & combined ratio, Underwriting profitability, Claims reserving basics, Rate indications, ISO or state filing data, Experience working with insurance core systems (Guidewire, Duck Creek, Majesco, etc.). Introductory knowledge of predictive analytics or forecasting methods, data mining and validation, dashboard development, statistical analysis, trend analysis, data quality management, insurance performance metrics, problem-solving and analytical thinking, cross-functional collaboration. Adaptability - Ability to work independently in a fast-paced environment; and manages changing priorities effectively. Detail Oriented - Ability to analyze data and to prepare accurate reports in a timely fashion. Accuracy - Ability to deliver well thought-out, accurate work products on deadline. Customer focused - Demonstrated customer service focus / superior customer service skills. Organized - Detail-oriented and exceptionally organized. Team member - Collaborative partner; ability to contribute to a positive work environment. Supervisory Responsibility This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, laptop, phones, photocopiers, filing cabinets and fax machines. Physical Demands Position requires sitting 90% of the day in an environmentally controlled environment. Position Type/Expected Hours of Work This is a full-time position. Flexible scheduling and telecommuting are at Management discretion. Travel No more than 5% travel anticipated. Required Education and Experience MINIMUM Education Requirement: Master’s Degree in Finance, Business Analytics, Risk Management or related. MINIMUM Experience Requirement: 3 years of experience in Insurance, Finance, Quantitative, or related field. Preferred Education and Experience ALTERNATE Education/Experience Requirement: Bachelor’s Degree in Finance, Business Analytics, Risk Management or related, and 5 years of experience in Insurance, Finance, Quantitative or related field. #J-18808-Ljbffr