SQL queries are critical components of KCC's innovative RiskInsight® platform (www.kcc.us.com/riskinsight). In this role, you will be responsible for ensuring SQL queries, indexes, views, stored procedures are optimized and work seamlessly with other components of the platform. Additional responsibilities include understanding and recommending any changes required to the configuration of SQL Server. Experience in the P&C industry, including experience working with EDM and CEDE data formats is a major plus.

About KCC

Karen Clark & Company (KCC) is the innovation and technology leader in catastrophe risk modeling. KCC professionals are globally recognized experts in catastrophe modeling and risk management. From our headquarters in Boston, Massachusetts, we provide advanced models, innovative software, and comprehensive consulting services to (re)insurance company executives nationwide. These services enhance business strategies, and the financial results put our clients at a competitive advantage. KCC catastrophe models currently cover tropical cyclones, extratropical cyclones, severe convective storms, floods, earthquakes, winter storms, and wildfires in over 50 countries. For more information, please visit www.kcc.us.com.

Responsibilities

  • Develop a thorough understanding of the architecture and inner workings of the RiskInsight® platform
  • Optimize SQL queries, indexes, views, and stored procedures
  • Recommend and lead implementation for improvements to SQL Server configuration
  • Collaborate with other members of the software development team to ensure SQL Server configuration remains compatible with RiskInsight® subsystems

Required Skills

  • Strong analytical and problem-solving abilities
  • Enterprise Software development experience
  • Ability to work with minimal supervision or assistance to complete tasks
  • Experience working with poorly documented source databases and understanding the source schema through examining the data itself
  • Demonstrates expert knowledge of T-SQL and stored procedure development
  • Demonstrates expert knowledge of performance topics including
    • Index/SP/View and query tuning
    • Understanding and overcoming poor execution plans
    • Experience setting up and operating SQL server with limited guidance
  • Expert level C# including WCF, ASP.Net, Webservices implementation
  • Building software that is resilient to unanticipated usage in client environments
  • Software testing (Unit, System, Integration, Functional, Performance)

Qualifications

  • Ability to learn quickly and adapt within a changing environment
  • Degree in computer science, math, engineering related field, or equivalent experience
  • Experience (3-5 years) working with large and complex databases using SQL
  • Experience with an object-oriented language such as C# or Java
  • Quantitative background (math/science/engineering) a plus