Insurance Systems Data Analyst
The Insurance Systems Data Analyst supports a 20-person insurance division within a financial services firm by ensuring data accuracy, completeness, and timeliness across multiple insurance software platforms. This role involves managing data integration, supporting system functionality, troubleshooting issues, and collaborating with vendors to adapt systems to evolving business needs. The analyst acts as a key liaison between the insurance division and corporate IT to optimize system performance and support business growth.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Financial Services.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
Role Overview
Confidential Client is seeking an experienced, hands-on Insurance Systems Data Analyst to support an in-house insurance business unit. This role will focus on ensuring data exchanged with carriers and between internal systems is timely, accurate, and complete. You will be the primary systems and data expert for the insurance team, working with vendors, operations, and IT to troubleshoot, enhance, and expand system functionality as the business grows.
What You’ll Do
- Ensure data integrity across insurance platforms: validation, reconciliation, and quality monitoring
- Map and transform data between carrier feeds and internal systems
- Troubleshoot application and data issues; perform root-cause analysis and drive corrective actions
- Support system configuration, user acceptance testing (UAT), and release validation
- Partner with vendors and escalate issues when necessary to restore or improve functionality
- Gather and document business requirements and workflows to drive system enhancements
- Build and maintain reports and analytics to support operations and leadership
- Support onboarding of new carriers and data sources into the ecosystem
- Provide day-to-day application support and act as the internal subject-matter contact for users
What We’re Looking For
- Proven experience in data management, data validation, reconciliation, and data quality programs
- Strong SQL skills and familiarity with database concepts
- Advanced Excel skills for analysis and reconciliation tasks
- Background in systems analysis, requirements gathering, and workflow documentation
- Experience with system configuration, UAT, and application support processes
- Strong vendor management and escalation experience
- Excellent written and verbal communication; able to work with technical and non-technical stakeholders
- Problem-solver with strong attention to detail and ownership mindset
- Bachelor’s degree (or equivalent experience) in a related field
Preferred Qualifications
- Prior insurance industry experience, especially supporting brokerage general agencies (BGAs), IMO/FMO organizations, or insurance distribution networks
- Experience in a financial services environment
- Familiarity with common insurance technology platforms and carrier integration patterns
- Reporting / BI tools experience (optional but helpful)
Skills & Tools
- SQL queries and database troubleshooting
- Excel (advanced formulas, pivot tables)
- Data mapping, ETL concepts, and data transformation
- Reporting and analytics
- User Acceptance Testing (UAT) and documentation
- Vendor escalation and application support processes
Engagement & Additional Notes
- Employment type: FULL_TIME
- This role partners closely with corporate IT and the insurance business unit.
- Note: source posting indicates independent consultants only; no third-party or subcontractor submissions are accepted.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range