Job title : Financial Analytics Engineer
Location : Noida, UP | Bangalore, KA
Experience : 7 to 8 years
Mandatory skill: SSIS, SSRS, (Python or PySpark) Good to have
Job Description :- Experience with strong IT technical skills, low to medium level regarding Accounting/Financial Reporting & Insurance knowledge
- Requires strong skills in: SQL, SSIS/SSRS Reporting, Python/Spark SQL
- Good communication skills (both oral and written).
- Understand that having all three skills (IT, Accounting & Insurance) is more difficult to find, so resumes can be stronger on one side or other.
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