Combined Insurance Reinsurance Data Systems Engineer in United States
The Reinsurance Data Systems Engineer will support the data collection, processing and actuarial modeling needs of Chubb Life’s international reinsurance business. He/she will lead initiatives to enhance and expand the existing data infrastructure to support more robust actuarial analytical capabilities. The role requires the ability to strategically apply technical data skills to the business challenges of automating and improving data processing and decision-making. The Data Systems Engineer will participate in the evaluation and redesign of existing processes, tools and reports to create more efficient and accurate business intelligence analytics throughout the international life business.
Execute the department effort to automate existing processes for modernization, improved efficiency, and enhanced functionality.
Automate data transformation, reporting and administrative tasks using appropriate programming tools.
Collaborate with other members of the department to develop high performance data extractions and transformations .
Create and maintain stored procedures and SSIS packages, along with VBA procedures and VB.net programs, to move and transform data and allow user interaction based on specific requirements.
Assist in monthly data validation, ETL and reporting processes.
Create and augment SOX compliant reports and documentation
Work with TPA to provide support with TAI software, client data integrity and reports to management
Create new documentation and update existing documentation as processes require.
Work closely with actuarial and financial teams on special projects and ad-hoc requests from senior management
Bachelor’s degree in mathematics, statistics, computer science, economics or other quantitative field
Experience working with large, complex datasets including data transformation operations such as dataset merging, data cleansing, imputation of missing values, and other operations related to exploratory data analysis
Five (5) plus years programming in two or more of the following: SQL, SSIS, VB .net, C# .net, VBA.
Experience writing SQL queries, functions and stored procedures in an enterprise environment.
Experience writing new and debugging existing excel macros.
Insurance or financial services industry experience preferred, particularly in life insurance
Knowledge of basic database administration with SQL Server a plus
Experience with programming objects a plus.
Dynamic and enthusiastic with capacity to work independently and take initiative.
Ability to work as part of a team in an international environment and take onboard the requirements of key business partners.
Ability to prioritize between projects/tasks and utilize efficient working methods/solutions.
Ability to effectively present and explain complex concepts to a non-technical audience
Job: *Information Technology
Title: Reinsurance Data Systems Engineer
Requisition ID: 318630