Note: The job is a remote job and is open to candidates in USA. SageSure is a growing managing general underwriter focused on catastrophe-exposed property insurance. The Claims Analyst II will support the Claims Insights team by developing operational reports, dashboards, ETL workflows, and data pipelines, while analyzing claims data to provide actionable insights and support data-driven decision-making.
Responsibilities
- 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
Skills
- 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
Benefits
- Distributed workforce environment
Company Overview
Company H1B Sponsorship