Data Analyst – REMOTE

Role Overview

The Data Analyst will provide data and reporting support to the Data Analyst Team Lead, helping to drive data-informed business decisions. In this role, the team member will assist in identifying unprofitable risk segments and uncover opportunities to reduce premium leakage across all lines of business.

What You Will Do

The team member will assist in generating on-demand reports, creating standardized reporting templates, and ensuring data accuracy. They will also contribute to improving AIS processes and procedures by performing data analysis, creating reports, and supporting the monitoring of underwriting production and goals.

Why It Might Be a Fit

This position is ideal for someone eager to develop their skills in data analytics while supporting a lead analyst and contributing to the organization’s success.

Requirements

• Proficient in performing data analysis and reporting using Excel, SQL, and Power BI.
• Ability to collaborate with cross-functional teams to identify and address operational challenges and assist in the development of new dashboards and visualizations.
• Strong knowledge of VLOOKUP/XLOOKUP, pivot tables, charts, data sorting, and conditional formatting to analyze and present data effectively.
• Experience using Power BI (or similar tools like Tableau) to create compelling visualizations and metrics.
• Knowledge of SQL, including inner and outer joins, lag/lead functions, case statements, and basic data modeling/design.
• Ability to create complex queries and support data-driven decision-making.
• Basic experience with UiPath or Power Automate for automating repetitive tasks and improving data workflows.
• General understanding of the Property & Casualty Insurance industry, including specific product lines such as Home, Auto, and Commercial.
• Strong analytical and quantitative skills with experience in underwriting practices, procedures, and data analysis related to premium and loss ratio analysis.
• Excellent written and verbal communication skills, with the ability to present findings on underwriting data projects clearly and effectively to management and stakeholders.
• Capable of producing quality work within tight timeframes, managing multiple projects simultaneously, and working efficiently within a team setting.
• Ability to stay up-to-date with new industry tools and techniques.
• Ability to work a flexible schedule and travel as needed, including occasional overnight or weekend stays.
• Ability to adhere to the company’s privacy policies and ensure the secure handling of sensitive data.
• Required to learn SQL, SAS, and potentially R coding if not already familiar, to further enhance data analysis capabilities.

Benefits

• Competitive compensation
• Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
• Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
• Medical, dental, vision, life, and pet insurance
• 401 (k) retirement savings plan with company match
• Engaging work environment
• Promotional opportunities
• Education assistance
• Professional and personal development opportunities
• Company recognition program
• Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more

Tagged as: Data Analysis