AI and BI Data Intern

Who We Are:
NFP, an Aon company, is a multiple Best Places to Work award winner in Business Insurance. We are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit: https://www.NFP.com.

 

Job Summary:

NFP is seeking a Business Intelligence Data Engineering Intern to join our Enterprise Data & Analytics team for the summer. This internship provides an opportunity to work on real-world data engineering and analytics initiatives that support NFP’s national advisory business serving corporate clients across employee benefits, retirement, wealth management, and property & casualty insurance.

The intern will work closely with the Senior Data Architect and the Business Intelligence Engineering team to help build and enhance enterprise data models, data pipelines, and AI-powered tools that improve, how advisors’ access and utilize information.

This role offers hands-on experience with modern data platforms including Microsoft Fabric, Power BI Semantic Models, Python, and data pipelines, while contributing to innovative solutions such as an AI-powered advisor chatbot designed to improve service efficiency and customer experience.

 

Key Responsibilities:

Data Engineering & Analytics

• Assist in the development and maintenance of enterprise data models used across NFP’s reporting and analytics platforms.
• Support the implementation of data pipelines within Microsoft Fabric’s Medallion Architecture (Bronze, Silver, Gold layers).
• Assist in building AI-powered data agents that support enterprise data discovery, metadata exploration, and natural-language interaction with governed datasets.
• Integrate AI agents with existing data platforms, SQL sources, and semantic models.
• Assist in building AI-powered data agents that support enterprise data discovery, metadata exploration, and natural-language interaction with governed datasets.

Development & Data Processing

• Develop and run Python-based data processing workflows using notebooks.
• Assist with building and optimizing data ingestion and transformation pipelines.
• Support data validation, data quality monitoring, and documentation of data flows across the architecture.

AI & Advisor Enablement Project

• Collaborate on the design and development of an internal Chat Agent that enables advisors to quickly access relevant information.
• Help integrate enterprise data sources into the chat agent knowledge base to provide accurate responses to advisor inquiries.
• Contribute to improving advisor workflows by enabling faster access to product, client, and operational insights without navigating multiple systems.
• Help Validate Chat Agent response
• Help Document the Agent internal working

Collaboration

• Work closely with Data Architects, BI Engineers, Data Analysts, and Product Owners to deliver data-driven solutions.
• Participate in Agile team ceremonies such as sprint planning and standups.
• Document technical work and contribute to team knowledge repositories.

 

What You Will Learn:

This internship provides exposure to modern enterprise data platforms and real-world analytics development, including:

• Enterprise Data Architecture and Data Modeling
• Microsoft Fabric data engineering workflows
• Medallion Lakehouse Architecture
• Power BI semantic modeling and reporting
• Python-based data engineering using notebooks
• AI-driven knowledge retrieval and chatbot development
• Real-world application of analytics to support insurance advisory services and client experience

 

Qualifications:

Required

• Currently pursuing a degree/master in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related technical field.
• Proficiency in Python for scripting and application development.
• Understanding of generative AI and Large Language Model (LLM) concepts.
• Familiarity with structured enterprise data (SQL, tables, schemas).
• Strong an