Note: The job is a remote job and is open to candidates in USA. SageSure is a leader in catastrophe-exposed property insurance, and they are seeking a Claims Analyst II to support their growing Claims department. In this role, you will develop operational reports and dashboards, analyze claims data, and collaborate with stakeholders to drive 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
Company Overview
Company H1B Sponsorship