Claims Analyst II

Overview: 

If you're looking for the stability of a profitable, growing company with the entrepreneurial spirit of a startup, we’re hiring. SageSure, a leader in catastrophe-exposed property insurance, is seeking a Claims Analyst II to support our growing Claims department. You will join our Claims Insights team, and in this role, you will help develop operational reports and dashboards that will support the team's continued scaling and growth and gain valuable insights into the processes and tools necessary to build and sustain a complex claim function. 

What you’d be doing: 

• Identify operational reporting opportunities with Claims department leadership.
• Develop data and visual dashboards that can be used to identify needed actions quickly.
• Work with leaders to incorporate operational data and dashboards into daily and weekly management processes. 
• Analyze Claims data in Domo, AWS Redshift and Excel to provide actionable insights to stakeholders.
• Perform data cleaning, validation, and quality checks within visualization tools to ensure accuracy, reliability, and consistency of datasets.
• Translate business requirements into scalable business intelligence solutions to track KPIs for senior leadership and operational teams.
• Build complex dashboards and automated reporting systems that serve as operational controls.
• Establish a framework for understanding and efficiently using currently available operational claims data. 
• Mentor other analysts.
• Develop, test, and optimize complex ETL workflows in Domo for performance and efficiency.
• Maintain and monitor data pipelines to support operational and strategic reporting needs.
• Work closely with business stakeholders to understand data needs and collaborate with cross functional teams to troubleshoot issues, and support data-driven decision-making. 

We’re looking for someone who has: 

• 3+ years of experience in data analytics role.
• 1+ years of Property Insurance or Claims experience.
• Bachelor’s degree in Mathematics, Statistics, Computer Science, or a related field.
• Advanced proficiency using data and visualization tools (eg Tableau, Domo, PowerBI, etc).
• Advanced SQL programming skills required.  
• Demonstrated ability to work with large datasets and tell a story using data visualization techniques.
• Understanding of database structure and ETL process.
• Excellent organizational skills for handling multiple projects simultaneously.
• Proven ability to gather requirements and develop custom reporting solutions.
• Advanced proficiency in Excel, AWS Redshift, and Microsoft SQL Server.
• Collect, validate, and analyze data to identify trends, patterns, and insights.
• Excellent verbal and written communication skills
• Advanced problem -solving and data validation skills.
• Proven ability to work independently and as a team member. 

About the Claims team at SageSure:  

On SageSure’s Claims team, you’ll be doing more than investigating and resolving losses. From the ground up, you’ll be pioneering a best-in-class claims handling approach that leverages transformative technology to support our customers, agents and employees. As a part of this customer-focused, process-oriented team you will be the face of SageSure, helping our policyholders through some of their most trying times. Whether you hold a formal leadership role or are a key team player, you’ll coach, mentor and engage with those around you in ways that bring out the best in people and effect change.  

You can easily distill complex processes in ways those outside the industry can understand and know the importance of aligning communication tools to customer preferences.