Job Description:
- Minimum 10+ years of experience in Data Engineering/Data Warehousing
- Microsoft skills required: SSIS/SSRS
- Programming Skills required: Python/Pyspark
- Cloud: Palantir Foundry
- Experience in Financial reporting managing
- Pre-monthend/Post-monthend process management
- ETL process from multiple data sources to transform and load data.
- Experience with SQL, Visual Studio, UC4, SSIS and SSRS (Microsoft Azure framework)
Building data pipelines that produce data assets in the accounting workflow to:
- Reconcile cash to accounting ledgers
- Create financial reporting for reinsurance partners (e.g. excess layer / quota share)
- Support reporting for captive partners
- Settlement reporting
- Detail premium and claims reporting
- Create pipeline adjustments to source system data to reflect correct values and assist in system programming bug fixes
- Manage exception reporting for cross-functional workflows (e.g. collaborative work with policy issue teams)
- Build data health and process control reports
- Develop and report on key business operational and KPI performance metrics.
- Provide reporting for downstream corporate processes (e.g. captive reporting for CRAS, reinsurance platform)
- Work with downstream data teams on reconciliation, integration and data flow alignment
Building data assets as the foundation for analysis performed by other business functions:
- Data to segment profitability and trend analysis for Pricing Actuarial
- Data to support financial projections and analysis team (FP&A)
- Data to support Reserving Actuarial process
- Data to support Actuarial Control analysis
- Data to support year-end Accounting audit
- Data to support internal audit requests
- Data to support statutory regulatory reporting
- Data to support A&H LoB management steering
- Data to support A&H Underwriting performance metrics
- Data to support A&H Sales team producer partner analysis