Posting Description:
Who We Are:
NFP, an Aon company, has been recognized several times as one of the Best Places to Work in Business Insurance. We are a group of consultative advisors and problem solvers. We assist companies and individuals worldwide in tackling their most important risk, workforce, wealth management, and retirement challenges with tailored solutions and a people-first approach. To learn more, please visit: https://www.NFP.com.
About the Role
NFP, an Aon company, is looking for a Senior Business & Data Analyst to support data-driven decision-making throughout Blue Sky Risk (BSR), Insurance Specialty Group (ISG), and the wider Totalis Specialty platform.
The Senior Business & Data Analyst is a strategic individual contributor who drives data-informed decisions throughout Blue Sky Risk (BSR), Insurance Specialty Group (ISG), and the wider Totalis Specialty platform.
Acting as a trusted advisor to program leadership and business partners, this role converts complex business needs into scalable reporting, analytics, and data solutions. These solutions improve operational performance and back strategic growth initiatives. The position plays a meaningful role in modernizing and automating reporting processes, improving data quality and governance, setting reporting standards, and supporting enterprise integration efforts throughout the organization.
The ideal candidate blends strong analytical and technical abilities with business sense, insurance industry expertise, and a consultative style. Success in this role means prioritizing work independently, partnering effectively with interested parties at all levels, and developing balanced, well-documented solutions that invent long-term business value.
Operating with a high degree of autonomy, this individual will develop positive relationships across underwriting, operations, finance, claims, technology, and executive leadership teams. They will influence decisions and support data-informed outcomes throughout the business.
Bey Responsibilities
Business Intelligence & Reporting
- Lead the optimization, automation, and modernization of recurring reporting processes across BSR, ISG, and Totalis programs.
- Reduce manual reporting effort through improved data architecture, automation, and self-service reporting capabilities.
- Build, develop, and maintain business intelligence solutions using Power BI and Microsoft Fabric.
- Ensure reporting solutions offer reliable, timely, and useful business insights.
- Partner with collaborators to define targets, reporting requirements, and operational metrics.
- Continuously find opportunities to improve reporting efficiency and business value.
Data Enablement & Analytics
- Serve as a consultative partner to Program Managers, executives, and business leaders regarding data strategy and reporting capabilities.
- Analyze business processes and find opportunities for operational improvement through data and analytics.
- Convert business needs into data requirements, reporting specifications, and actionable recommendations.
- Support enterprise-wide data enablement initiatives across multiple business divisions and programs.
- Perform data discovery, validation, reconciliation, and analysis across various enterprise systems.
Data Governance & Documentation
- Build and maintain comprehensive documentation supporting all major reporting and analytical solutions.
- Build and maintain:
- Data lineage documentation
1. Source-to-target mappings
- Business rules documentation
1. Data dictionaries
- Metric definitions
1. Reporting process documentation
- Clearly identify source systems and document how data is transformed and conformed throughout analytical workflows.
- Ensure reporting solutions can be audited, replicated, and handed over to future team members.
- Support data governance initiatives by promoting consistency, transparency, and accountability.
Collaborator Management & Business Partnership
- Lead requirements gathering sessions, workshops, and solution-design meetings with Subject Matter Experts (SMEs).
- Drive discussions that establish alignment on requirements, priorities, and business outcomes.
- Build and maintain strong working relationships with:
- Program Managers
1. Underwriting Teams
- Claims Partners
1. Finance Teams
- Executives and Senior Leadership
- Effectively communicate technical concepts to non-technical audiences.
- Influence decisions through data, business context, and thoughtful recommendations.
Project Delivery & Execution
- Independently manage and prioritize 2-3 concurrent projects at varying stages of execution.
- Own projects from requirements gathering through implementation and adoption.
- Proactively identify risks, dependencies, and opportunities.
- Collaborate across business and technology functions to ensure successful solution delivery.
- Support enterprise integration initiatives through the standardization of reporting, metrics, and data management practices.
Required Qualifications
Experience
- Bachelor’s Degree or equivalent experience in Computer Engineering or a related technical field.
- Familiarity with Microsoft Fabric and automation tools powered by artificial intelligence (such as Copilot Studio), along with hands-on experience in SQL Server environments.
- Minimum 3 years of experience in enterprise Business Intelligence, Data Analytics, Business Analysis, or Data Enablement.
- At least 3 years of experience in the insurance sector.
- Direct experience supporting:
- MGA (Managing General Agent)
1. MGU (Managing General Underwriter)
- Wholesale Brokerage
1. Reinsurance Operations
- Surplus Lines / E&S Markets
- Proven experience leading reporting automation and operational improvement initiatives.
- Experience supporting executive and operational collaborators.
- Experience gathering and detailing business and technical requirements.
Technical Skills
Required
- Advanced SQL development and data analysis skills.
- Strong Power BI experience including:
- Data modeling
1. DAX or equivalent experience
- Dashboard development
1. Benchmark reporting
- Experience collaborating with Microsoft Fabric.
- Experience working in SQL Server settings.
- Understanding of:
- Data modeling
1. Data quality management
- Data governance
1. Data lineage
- Reporting architecture
- Experience integrating and analyzing data from multiple operational systems.
Business Proficiencies
- Strong business insight.
- Excellent analytical and problem-solving skills.
- Ability to navigate ambiguity and define actionable solutions.
- Effective oral, written, and presentation communication skills.
- Ability to influence collaborators without direct authority.
- Strong meeting facilitation skills.
- Demonstrated ownership and accountability.
- Ability to prioritize competing demands and manage multiple projects simultaneously.
Preferred Qualifications
- 5+ years of Business Intelligence or Data Analytics experience.
- Master’s Degree or equivalent experience in Information Technology, IT Management, Data Science, or a related quantitative field.
- Experience supporting insurance operations including:
- Underwriting
1. Premium reporting
- Bordereaux reporting
1. Claims operations
- Carrier reporting
1. Program business management
- Experience with enterprise integration projects.
- Familiarity with Master Data Management (MDM) concepts.
- Experience working within highly regulated reporting environments.
- Microsoft certifications such as:
- PL-300
1. dp-600
- DP-700
What We Offer:
We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture centers on building and nurturing lifelong relationships with our employees since our mission is to be there for others. The base salary range for this position is $100,000 to $122,000. Factors such as experience, credentials, education, certifications, skill level needed, role scope, and location influence the salary offered. Salary decisions are made on a case-by-case basis. Additionally, this role may qualify for performance-based incentives.
NFP and You... Better Together!
NFP is an inclusive Equal Employment Opportunity employer
#NFP