Allstate

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

Data and Reporting Analyst, Intern

Business Intelligence AnalystBusiness Intelligence AnalystInternshipRemoteTeam 10,001+Since 1931H1B SponsorCompany SiteLinkedIn

Location

Illinois

Posted

24 days ago

Salary

Not specified

Bachelor DegreeEnglishCloudSQL

Job Description

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

Job Requirements

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

Benefits

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

Related Job Pages

More Business Intelligence Analyst Jobs

Senior Finance System Analyst

Mercyhealth Wisconsin and Illinois

At Mercyhealth, we don’t simply hire people, we empower employee-partners who are passionate about making lives better. As an integrated health system, we deliver exceptional, coordinated care across seven hospitals, 85 primary and specialty clinics, and a team of over 7,500 professionals serving northern Illinois and southern Wisconsin. #1 in the nation on AARP's Best Employers for Workers Over 50 One of Working Mother magazine's 100 Best Companies for Working Mothers A Top 50 Company and Top 10 Nonprofit for Executive Women

Business Intelligence Analyst24 days ago
Full TimeRemoteTeam 5,001-10,000

ESSENTIAL DUTIES AND RESPONSIBILITIES Serve as a member of the D igital & T echnology S olutions department partner ing with Finance areas to support the configur ation and mai ntenance of Workday Core Financials , B anking & S ettlement, B udget, B usiness A ssets, E xpenses, FD...

Workday FinancialsWorkday Core FinancialsWorkday Banking & SettlementWorkday BudgetWorkday AssetsWorkday ExpensesWorkday FDMWorkday GrantsWorkday Supplier AccountsWorkday ProjectsWorkday ReportingWorkday AnalyticsWorkday IntegrationsWorkday ConfigurationFinancial Data ManagementFinance Reporting
United States

Senior Revenue Cycle Integrity and Reporting Analyst

Twin Health

Twin Health invented the Whole Body Digital Twin™ to help reverse and prevent chronic metabolic diseases.

Business Intelligence Analyst24 days ago
Full TimeRemoteTeam 201-500Since 2018H1B Sponsor

Senior Revenue Cycle Integrity Analyst managing billing operations at Twin Health

ERPSQLTableau
United States
$95K - $120K / year

Federal Plans Reporting Analyst

CVS Health

Bringing our heart to every moment of your health.

Business Intelligence Analyst25 days ago
Full TimeRemoteTeam 10,001+Since 1963H1B No Sponsor

Analyst supporting Federal health benefit programs at CVS Health

Connecticut + 2 moreAll locations: Connecticut, Idaho, Texas
$47.0K - $122.4K / year
Business Intelligence Analyst27 days ago
Full TimeRemoteTeam 10,001

We are excited to bring on an Anaplan Model Builder Analyst to join our Finance team in a hybrid environment within our Radnor, PA; Fort Wayne, IN; Greensboro, NC; Charlotte, NC; Hartford, CT or Omaha, NE offices or remote if outside of one of these locations. The Financial Analy...

AnaplanSQLPythonPower BIAgile
United States
$69K - $124K / year