AVP - Data Engineer

  • Philadelphia, PA
  • Posted 60+ days ago | Updated 11 hours ago


Philadelphia, PA
Full Time


DesignFluency.NETFinanceRCommunicationCloud architectureGitClaimsMicrosoft Power BIManagementMigrationBudgetJenkinsAnalytical skillChange managementTechnical analysisAgile managementSarbanes-OxleyDataIBM CognosPythonProduction supportExtracttransformloadA+DevOpsActuarial ScienceWarehouseDatabaseData warehouseBusiness intelligenceAgileSoftware developmentMicrosoft SQL ServerProperty and casualty insurancePricing

Job Details


The Global Actuarial Systems team is a small, agile group of technology enthusiasts. We are tasked with solving the complex data needs of both US and International reserving and pricing actuaries. Our group is responsible for collating data from several disparate systems and platforms to provide analytic solutions for the world's largest publicly traded property and casualty insurer. Our systems are the foundation for the loss triangles which are reported externally and ensure we have the capital to pay future claims.

This position is for a full-time AVP Data Engineer in either our Philadelphia, PA or Whitehouse Station, NJ office.

  • Expanding our new claim data warehouse responsible for producing actuarial loss triangles
  • Implementing BI processes so end users can quickly and easily derive value from billion row datasets
  • Creating of new ETL process to accurately stitch data together
  • Helping to design the future cloud architecture and migration of the warehouse
  • Investigating, diagnosing, and actioning on business questions and requests
  • Direct handling of production support and maintenance of existing financial feeds
  • Delivering solutions on time and within budget, meeting both internal change management standards and external SOX controls

  • Microsoft SQL Server guru with strong data warehousing fundamentals
  • Fluency in other databases, coding languages (eg R, Python, .NET), and BI solutions (eg Shiny, Cognos, PowerBI)
  • Proficient in DevOps tools (GIT, Jenkins, Octopus)
  • Adept in Agile project management ideologies
  • Extensive technical analysis and investigative capabilities
  • Strong communication skills, comfortable interfacing with senior business users
  • Financial/actuarial data, application, or practical experience a plus