Scott McPherson

About Scott McPherson

I’m a data analytics professional with over a decade in the Property & Casualty insurance industry, spanning sales, management, underwriting, claims, and analytics. This cross-functional background allows me to bridge the gap between business goals and data strategy — ensuring analytics directly support performance, efficiency, and profitability.In my current role, I lead initiatives that automate ETL pipelines, modernize reporting, and deliver clear, actionable insights across the enterprise. I’m skilled in Alteryx, SQL, Python, Power BI, Tableau, and Excel — tools I use not just to process data, but to enable smarter business decisions and scalable analytics frameworks.I’m passionate about developing data culture, mentoring analysts, and designing solutions that help organizations move from data collection to true data intelligence. My next step is to lead an analytics team where I can guide both strategy and execution — aligning data operations with organizational priorities and measurable outcomes.

Experience

1. Senior Analyst

   NFP, an Aon company

   Mar 2024 — Present

   Mentored and trained new analysts on workflow automation, reducing onboarding time from six months to a single project cycle (3–4 months).• Initiated and led process improvement initiatives to increase efficiency across ETL and reporting workflows, including integration into new systems for other company verticals.• Led adoption of API-based data automation within analytics workflows, providing a scalable, repeatable framework that decreased manual data manipulation and freed analysts to focus on higher-value insights.

Education

• William & Mary

  MS

  2019 — 2021

• University of Florida - Warrington College of Business

  BA

  2003

Skills

• Sales Management
• Customer Service
• Property
• Microsoft Office
• Sales
• Marketing
• Property
• Strategic Planning
• Management
• Underwriting
• Insurance
• Property & Casualty Insurance
• Selling
• General Insurance