Senior Insurance Data & Analytics Analyst

Vantage Risk Companies; Chicago (IL); Hybrid; USD 150,000 - 175,000; Full time

Job summary

Vantage Group Holdings Ltd. is seeking a Senior Financial Data Analyst to support data analysis efforts across insurance systems, EDW, and general ledger processes.

You will partner with Finance to validate data, manage data quality, and ensure accurate premium calculations as part of the financial close. You will document source-to-target reconciliations, track variances, and support SOX/compliance while managing a backlog and collaborating with development teams.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 5–7 years in data analysis, business analysis, or financial systems support in P&C insurance preferred.
• Experience with data warehouses, GL systems, and financial close processes.
• Strong communication bridging finance, IT and development teams; knowledge of audit/SOX controls.
• Basic SQL skills and ability to read ETL code.

Responsibilities

• Supports the VP of Insurance Enterprise Data to ensure effective and timely development of new and/or enhanced systems/technologies.
• Provides deep technical and business analysis of data such that developers can effectively create solutions that assist leaders with data-driven decision making.
• Creates source-to-target mappings with support from functional business representatives.
• Owns the process of user and technical story writing for all work to be delivered.
• Maintains a groomed backlog, ensuring each story includes a clear, concise description, acceptance criteria, a developer point estimate, and an agreed-upon delivery expectation with the business.
• Owns the process of obtaining business sign off on all stories being deployed to production as well as ensuring the code is released to production on a timely basis.
• Completes the business analysis activities and helps the development team understand the analysis.
• Supports quality assurance efforts for assigned systems/technologies through vendors, system integrators, and internal development teams.
• Design test cases and testing scenarios working with QA engineers.

Skills

SQL

Data analysis

Business analysis

Financial systems

ETL

Agile

Cloud data

Stakeholder communication

Education

Bachelor’s degree preferred

Tools

SQL databases

Data warehouse platforms

General Ledger systems

Job description

Vantage Group Holdings Ltd. is seeking a Senior Financial Data Analyst to support data analysis efforts across insurance systems, EDW, and general ledger processes.

You will partner with Finance to validate data, manage data quality, and ensure accurate premium calculations as part of the financial close. You will document source-to-target reconciliations, track variances, and support SOX/compliance while managing a backlog and collaborating with development teams.