Claims Analyst II
SageSure
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
About the role
- 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.
Requirements
- 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
- Health benefits
- Tuition reimbursement
- Wellness allowance
- Paid volunteer time off
- Matching 401K plan
- More
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data analyticsdata visualizationSQL programmingETL workflowsdata cleaningdata validationdata analysisdashboard developmentKPI trackingdata storytelling
Soft Skills
organizational skillscommunication skillsproblem-solvingmentoringcollaborationindependencerequirement gatheringproject managementanalytical thinkingattention to detail