Principal | Advanced Analytics - Product & Strategy Team

PTR Global; Addison (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

PTR Global seeks an experienced analytics professional in Addison, TX to manage internal systems and processes with a focus on underwriting, operational and financial analysis. You will use SQL to produce data exports and create executive visualizations to monitor KPIs, advising leadership based on findings.

Collaboration with business leaders is essential to drive data-informed decisions. Ideal candidates have 10+ years in related roles, strong SQL and Excel skills, and insurance industry

Qualifications

• 10+ years of experience in analytics/underwriting roles.
• SQL programming experience – 3+ years.
• Experience querying database systems, Microsoft Access, Microsoft Excel, and other reporting systems.
• Verbal and written communication skills including interpersonal skills.
• Experience collecting and communicating business requirements – 3+ years.
• Insurance background is required.

Responsibilities

• Project Management for internal systems and processes.
• Perform underwriting, operational, and financial analysis utilizing internal and external data sources.
• Utilize SQL to develop data exports for internal and external users.
• Develop intuitive visualizations for executive audiences to monitor key performance metrics.
• Advise business leaders based on analysis findings.
• Additional responsibilities may be assigned as directed by the Manager of the Company.

Skills

SQL

Underwriting analytics

Data analysis

Communication skills

Requirements gathering

Insurance industry knowledge

Microsoft Excel

Microsoft Access

Education

Finance/Mathematics/CS background

Tools

Salesforce

IMS

VBA

Microsoft Access

Microsoft Excel

Job description

• Project Management for internal systems and processes
• Perform underwriting, operational, and financial analysis utilizing internal and external data sources
• Utilize SQL to develop data exports for internal and external users.
• Develop intuitive visualizations for executive audiences to monitor key performance metrics
• Advise business leaders based on analysis findings

Additional responsibilities may be assigned as directed by the Manager of the Company.

Required Job Qualifications:

• 10+ years of experience
• SQL programming experience – 3+years
• Experience in querying database systems, Microsoft Access, Microsoft Excel, and other reporting systems
• Verbal and written communication skills including interpersonal skills
• Experience collecting and communication business requirements – 3+ Years
• Insurance background is required

Preferred Job Qualifications:

• Finance, Mathematics, or Computer Science path of study
• Direct report experience with business analyst resources.
• Experience with Salesforce
• Experience with IMS (Insurance Management System)
• Experience with Visual Basic for Applications
• Experience with insurance catastrophe modelling