Purpose:
The Finance Data Analyst will serve as the primary analytical and data-process partner from the data team to the Finance team, ensuring that financial data from Mission's enterprise data warehouse (EDW) is accurate, complete, timely, and usable for accounting, reporting, and ad hoc analysis. This role will assume day-to-day responsibility for the existing finance ETL process while it remains in use, compare EDW output with this process, investigate and explain differences, and establish repeatable validations for premium, commissions, taxes, fees, payments, and other policy transaction data.
The ideal candidate combines insurance accounting knowledge with strong SQL and data analysis skills, sound judgment about whether financial results make sense, and the ability to translate Finance requirements into reliable data processes.
Essential Duties/Functions:
- Assume day-to-day responsibility for running, monitoring, and troubleshooting the existing daily finance ETL accounting process while it remains in use, producing policy transactions and monetary amounts across premium, taxes, and fees.
- Compare financial data produced by the EDW with the current finance ETL outputs; reconci