AI and BI Data Intern

Posting Description:

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 analytical skills and attention to detail.

Ability to work effectively in a team-based, enterprise technology environment.

Preferred

Exposure to agentic AI frameworks such as Semantic Kernel, LangChain, or similar.

Familiarity with RAG architecture, embeddings, or vector search concepts.

Experience or coursework involving cloud platforms (Azure preferred).

Awareness of BI concepts such as semantic models, metrics, or reporting layers.

Interest in enterprise AI governance, security, and responsible AI practices.

What We Offer:

Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, at the end of the day, we exist to be there for others. The hourly rate for this position is $18.00 – $24.00.

NFP and You... Better Together!