Insurance Data Engineer

Insurance Accounting and Systems Associates; Troy (MI); On-site; USD 85,000 - 105,000; Full time

Job summary

Presurance Holdings, Inc. is seeking an experienced Data Analyst to join our analytics team in Troy, MI. The role combines IT data interfaces with data analytics to support underwriting, actuarial work, and reporting for insurance programs.

You will learn our IT data interfaces and collaborate with actuaries, accountants, underwriters, and claims personnel to improve data quality and drive business insights. A strong foundation in data management, SQL, and reporting is essential.

Qualifications

• Bachelor’s degree in a technical or business discipline or equivalent expertise.
• Knowledge in 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.

Responsibilities

• Provide analytical data support for underwriting and actuarial analysis.
• Develop knowledge of data architecture and lines of insurance business.
• Perform data mining and reporting to generate data calls and support actuarial and CFO analyses.
• Contribute to data standards and communicate them to software development stakeholders.
• Investigate new tools and techniques; collaborate on software evaluations.

Skills

Data analysis

IT concepts & data standards

Attention to detail

Deadlines & time management

Education

Bachelor’s degree in technical or business discipline

Tools

SSMS

T-SQL

Data mining tools

Job description

Presurance Holdings, Inc., a publicly traded property & casualty insurance holding company, currently has an open position for an experienced Data Analyst with strong data management, analysis and reporting skills. This role would incorporate a combination of insurance IT systems knowledge data analytics experience. The candidate is expected to learn the various Presurance IT Data Interfaces and will work closely with other IT data analysts, actuaries, accountants, underwriters and claims personnel.

Job Responsibilities

• 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:
  • perform actuarial analyses on underwriting performance including loss characteristic evaluations, pricing, catastrophe risk cost analysis, reserve analysis and ad hoc reporting; and
  • evaluate profitability of existing lines of business.
• Contribute to data standards best practices; communicate standards to proprietary software development stakeholders.
• Investigate new tools and techniques; collaborate on software evaluations.

Candidate Qualities & Skills

• 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.