Description
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-month end/Post-month end 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:
o Reconcile cash to accounting ledgers
o Create financial reporting for reinsurance partners (e.g. excess layer / quota share)
o Support reporting for captive partners
o Settlement reporting
o Detail premium and claims reporting
o Create pipeline adjustments to source system data to reflect correct values and assist in system programming bug fixes
o Manage exception reporting for cross-functional workflows (e.g. collaborative work with policy issue teams)
o Build data health and process control reports
o Develop and report on key business operational and KPI performance metrics.
o Provide reporting for downstream corporate processes (e.g. captive reporting for CRAS, reinsurance platform)
o 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:
o Data to segment profitability and trend analysis for Pricing Actuarial
o Data to support financial projections and analysis team (FP&A)
o Data to support Reserving Actuarial process
o Data to support Actuarial Control analysis
o Data to support year-end Accounting audit
o Data to support internal audit requests
o Data to support statutory regulatory reporting
o Data to support A&H LoB management steering
o Data to support A&H Underwriting performance metrics
o Data to support A&H Sales team producer partner analysis
Education
Any Graduate
- Posted On: 30+ Days Ago
- Experience: 10+ years of experience
- Openings: 1
- Category: Senior Financial Analyst
- Tenure: Full-Time Position