Insurance Data Engineer

· Work closely with a highly experienced team of P&C insurance executives to provide analytical data support for underwriting and actuarial analysis of the Company’s insurance programs and evaluate strategic opportunities

· Develop an in-depth knowledge of the data architecture and an understanding of the insurance lines of business.

· Perform data mining and reporting to generate data calls and assist the Senior Actuary and CFO to:

o perform actuarial analyses on underwriting performance including loss characteristic evaluations, pricing, catastrophe risk cost analysis, reserve analysis and ad hoc reporting; and

o evaluate profitability of existing lines of business.

· Contribute to data standards best practices; communicate standards to proprietary software development stakeholders.

· Bachelor’s degree in a technical or business discipline or equivalent expertise

· Knowledge in the following areas: IT concepts, strategies and methodologies; IT architectures and data standards; data design and tools

· Understanding of T-SQL and SSMS fundamentals: CTEs and window functions, stored procedures and views, multi-step staging logic, and troubleshooting of joins

· Ability to take ownership of existing production queries and stored procedures, trace data lineage from the policy administration system through staging to final reporting output, and validate results against control totals

· Broad knowledge of various insurance products and lines of business is a significant plus

· Comfortable with a network environment. Curious and capable of learning and applying knowledge to develop new IT processes to assist with business growth and efficiency improvements.

· Light coding for effecting constant improvements of existing processes through automation.

· Exceptional attention to detail with strong organizational and time management skills.

· Ability to set and achieve deadlines and objectives.

· Base salary: $95,000 to $115,000 per year

· Opportunity to earn an annual performance-based bonus

· 401(k) match

· Option to participate in the Company’s benefits plan, including health, dental and vision insurance coverage

· Company-funded life insurance coverage

· Hybrid work schedule

Continuing education reimbursement, including potential support for actuarial or technical certifications