Remote Insurance Finance Data Analyst — SQL & EDW

mission-us; United States; Remote; USD 90,000 - 140,000; Full time

Job summary

Mission-US is seeking a Finance Data Analyst to serve as the analytical and data-process partner to Finance. You will own day-to-day finance ETL, validate EDW outputs, and establish repeatable reconciliations for premium, taxes, fees, and other policy data.

The ideal candidate combines insurance accounting knowledge with strong SQL and data analysis skills, translating Finance requirements into reliable data processes for accurate reporting and ad hoc analyses.

Qualifications

• 4+ years in finance data analysis or related roles.
• Experience with commercial or specialty insurance transaction data.
• Strong SQL, data validation, and reusable query development.
• Ability to document definitions, calculations, and reconciliations.
• Experience in building recurring reports and KPI analyses.
• Excellent communication and collaboration with Finance and Data teams.

Responsibilities

• Run, monitor, and troubleshoot daily finance ETL processes for policy data.
• Compare EDW outputs with finance ETL, reconcile by grain and transaction.
• Investigate variances and root causes, including data defects and timing issues.
• Develop reusable SQL components for validation and reporting.
• Establish automated validation rules and exception reporting.
• Deliver accurate recurring data and schedules to Finance.
• Collaborate with data engineers to trace data lineage and fixes.
• Build knowledge of EDW data model and policy lifecycle.

Skills

SQL

ETL

Financial analysis

Insurance data

Education

Bachelor’s degree in finance or related field

Tools

Power BI

Databricks

PySpark

Azure

Job description

Mission-US is seeking a Finance Data Analyst to serve as the analytical and data-process partner to Finance. You will own day-to-day finance ETL, validate EDW outputs, and establish repeatable reconciliations for premium, taxes, fees, and other policy data.

The ideal candidate combines insurance accounting knowledge with strong SQL and data analysis skills, translating Finance requirements into reliable data processes for accurate reporting and ad hoc analyses.