Data and Reporting Analyst Intern

About Allstate and National General

National General, a proud part of The Allstate Corporation, leads with innovative drive to meet evolving customer needs. We offer comprehensive home, auto, and accident & health insurance, alongside specialty niche products, distributed through independent agents and directly to consumers.

The Data and Reporting Analyst Intern Role

This fully remote internship at National General is tailored for junior and senior undergraduates pursuing degrees in Data Analytics, Data Science, Business Analytics, or Management Information Systems. It offers hands-on experience with real business data, dashboard creation, SQL-based analysis, and enterprise reporting. Interns will gain exposure to cutting-edge Microsoft cloud technologies including Power BI, Power Apps, and Power Automate, learning directly from seasoned data analysts. This is an exceptional opportunity to strengthen technical skills and build a robust foundation for a career in analytics, providing real-world experience across the entire data analytics workflow. You will receive mentorship and skill development, expanding technical ability, business acumen, and confidence with enterprise data systems.

What You’ll Do

• Collect, clean, validate, and organize data from multiple sources to support recurring and ad‑hoc reporting needs.
• Build and update dashboards, reports, and visualizations using Power BI and Excel.
• Use SQL to query, manipulate, and analyze data for insights and reporting accuracy.
• Run basic analyses to identify trends, measure performance, and highlight improvement opportunities.
• Assist with preparing summary insights and communicating key findings to team members or leadership.
• Support documentation of data processes, reporting standards, metadata, and recurring workflows.
• Learn and apply best practices in data retrieval, transformation, quality assurance, and reporting.
• Collaborate with senior analysts on project‑based assignments, gradually taking on more independent work as skills expand.

What You’ll Gain

• Hands-on experience with enterprise data, analytics tools, and SQL-based reporting.
• Direct mentorship from experienced data analysts with opportunities for skill-building and professional development.
• Exposure to real business challenges and cross-functional collaboration.
• Experience presenting data-driven insights and contributing to decision-support reporting.
• A strong technical foundation to accelerate your early career in data analytics or business intelligence.

Qualifications

• Currently a junior or senior pursuing a bachelor’s degree in Data Science, Business Analytics, Economics, Computer Science, Management Information Systems, or a related field.
• Proficiency in SQL for data querying, transformation, and reporting.
• Familiarity with Microsoft cloud technologies, including the Power Platform (Power BI, Power Apps, Power Automate).
• Strong foundational skills in analytical thinking, problem‑solving, and data interpretation.
• Exposure to Excel functions, formulas, pivot tables, and basic data modeling concepts.
• Strong written and verbal communication skills with the ability to clearly summarize findings.
• Comfort using Microsoft 365 tools such as OneDrive, SharePoint, Teams, Lists, and Forms.
• Curiosity, eagerness to learn, and enthusiasm for working with data and technology.

Key Skills/Competency

• Data Cleaning
• Reporting
• Dashboard Development
• SQL Analysis
• Data Visualization
• Performance Measurement
• Insight Communication
• Data Quality
• Workflow Documentation
• Cross-functional Collaboration