AI and BI Data Intern

NFP • Chicago, IL

9d • $18 - $24

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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.

Responsibilities

• 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.
• 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.
• 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
• 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.

Benefits

• 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.

What This Job Offers

• Career Level: Intern