Data & Analytics Consultant Intern - Summer 2027 (Hybrid in Chicago)

Posted 3 Days Ago
Be an Early Applicant
Chicago, IL, USA
Hybrid
Internship
Database • Analytics • Consulting
The Role
Supports consulting projects by gathering and preparing data, conducting foundational analysis, creating visualizations and reports, documenting requirements, mapping processes, assisting with testing, and communicating findings to clients and stakeholders. The intern uses SQL, spreadsheets, Python or R, BI tools, collaboration platforms, and AI-assisted methods to deliver data-driven insights and solution designs.
Summary Generated by Built In
Company Description

Resultant is an outcomes-focused consulting firm committed to helping clients make technology a strategic asset and use data to guide better decisions. But we’re not just data and tech experts; we are problem solvers and industry experts who work alongside our clients to help them achieve their mission. 

We don’t solve problems for our clients. We solve problems with them.

We take the time to deeply understand goals and roadblocks to drive toward outcomes that serve organizations, people, and communities. Through outcomes driven by data analytics, technology solutions, digital transformation, and beyond, our team works with clients in both the public and private sectors to solve their most complex challenges. We start by learning as much as we can about who they are, how they work, and what they’re striving for so we can feel their problems as our own. Partnering with our clients means their desired outcomes are always top of mind, their challenges and strengths guiding our efforts. We build client-focused relationships before we build unique solutions that blaze past expectations.

Originally founded in Indianapolis in 2008, Resultant now employs more than 300 team members who operate remotely and from offices and hubs around the United States including Indianapolis, IN; Chicago, IL; Fort Wayne, IN; Denver, CO; Atlanta, GA; and Dallas, TX.

We’re Resultant. Clients partner with us to see a difference. People join us to make one.

What to Expect from Your Summer at Resultant
Spend 10 weeks learning, contributing, and making connections at Resultant. You’ll work alongside Rezzers on meaningful projects, gain exposure to client work, and see firsthand how data and technology help our clients make a difference. Beyond your day-to-day work, you’ll connect with Rezzers across the organization through coffee chats, client spotlights, and interactive sessions covering topics like AI, consulting, communications, data, sales, and more. You’ll also collaborate with your intern cohort on a group project—giving you the opportunity to build new skills, solve a real business challenge, and make an impact of your own.

Job Description

Launching your career at Resultant means more than just a job title — it means becoming a catalyst for change. As a Data & Analytics Consultant Intern, you will:

  • Collaborate with cross-functional teams to support client projects and move work forward.
  • Engage with clients and stakeholders by asking thoughtful questions, synthesizing feedback, and presenting findings. 
  • Identify, gather, and prepare data using structured, reproducible methods — including SQL, spreadsheets, basic scripting, and AI-assisted data prep tools.
  • Apply foundational analytical and statistical techniques, including AI-assisted pattern discovery and hypothesis generation, to uncover insights, trends, and patterns that address client needs.
  • Build clear data visualizations or reports using tools such as Power BI, Tableau, or spreadsheets, incorporating AI-assisted features where applicable to accelerate development.
  • Document business and functional requirements and translate insights into actionable plans and solution designs — including identifying opportunities where AI or automation can streamline manual processes.
  • Create process maps, workflow diagrams, and supporting documentation to clarify complex concepts.
  • Participate in testing activities by assisting with test scenarios, validating results (including outputs from AI-assisted tools), and ensuring solution quality.
  • Use AI copilots and prompting techniques to accelerate research, documentation, and analysis — while critically evaluating outputs for accuracy and applicability.
  • Use project and collaboration tools to stay organized and support team workflows.
  • Communicate status, risks, and insights clearly with teammates, clients, and stakeholders to maintain alignment and ensure project momentum.
  • Gain hands-on exposure to Resultant's AI-native delivery methodology and modern data platform practices.

Qualifications

Some of the qualifications and skills we are expecting include the following:

  • Rising Senior enrolled in a Bachelor's degree program in a relevant field of study, preferably graduating in the Spring of 2028.
  • Please note, this internship has a start date in June 2027.
  • Must live in the Chicago IL, area during the summer of 2027.
  • Expectation of 3 days in office per week at a minimum.
  • Must be legally authorized to work in the United States for any employer without sponsorship.

Core Skills & Competencies

  • Exceptional written, verbal, and interpersonal communication skills.
  • Demonstrated ability to problem-solve, think creatively, and deliver results.
  • Strong organization, prioritization, and time-management abilities.
  • Ability to work independently and collaboratively within diverse, cross-functional teams.
  • Deep intellectual curiosity and a willingness to learn new tools, methods, and domains.
  • Comfortable interacting professionally with stakeholders including executives, managers, subject matter experts, and technical teams.
  • Experience working in deadline-driven environments.

Technical & Analytical Skills

  • Understanding of relational database concepts, such as tables, keys, and simple normalization.
  • Ability to write basic SQL queries (SELECT, JOIN, WHERE, GROUP BY) to explore and analyze data.
  • Foundational knowledge of data structures and statistical concepts, including descriptive statistics and simple inferential ideas.
  • Exposure to ETL/ELT concepts, such as data cleaning, transformation, and preparing datasets for reporting or analysis.
  • Understanding of data modeling basics, including fact vs. dimension tables and star schema concepts.
  • Introductory experience with Python or R, especially for data manipulation or exploratory analysis.
  • Familiarity with data visualization tools (Power BI, Tableau, or similar) to build simple dashboards or charts.
  • Experience working with spreadsheets (Excel or Google Sheets) for analysis, formulas, pivot tables, and lightweight modeling.
  • Exposure to version control systems such as Git or GitHub, even at a basic level (e.g., cloning, committing, branching).
  • Exposure to project/collaboration tools such as Jira. Azure DevOps. Google Workspace, Office 365, etc.

Additional Information

What you should know about Resultant:  

  • Rezzers are humble, hungry, and smart. We solve big problems, serve lots of clients, and are entirely committed to delivering transformative outcomes.  
  • Rezzers are team players, deeply dedicated to the mission of the organization and to helping everyone around us be successful.  
  • Resultant compensates well, rewarding performance that delivers positive outcomes for our clients and ensuring incentives are aligned to achieve our goals.  
  • Resultant leaders work hard, serving as a shining example of what it means to be a great Rezzer. They are servant leaders, helping their team to be successful in all possible ways.  
  • We have a great benefits package including unlimited vacation, significant 401k contributions, and several opportunities to develop yourself.  
  • We pride ourselves in having the best talent in the industry and hope that you’re up for the challenge!  

What our team members say about us… 

  • “I love our true empathy and concern for our clients, it's very rare and appreciated. It is a pleasure to be a part of an organization like Resultant.” 
  •  “I learn something new every single day, and I feel like I'm a part of building an organization that has legs. I appreciate that I'm consistently humbled by the talent and caliber of our team.” 
  • “The culture of the company is amazing, and the climate of my team is great. The benefits that employees are offered are better than competitors, and the one-on-one presence that my team lead gives is extremely beneficial to me.”

All qualified applicants will receive consideration for employment without regard to age, color, sex, disability, national origin, race, religion, or veteran status. 

Equal Opportunity Employer 

We embrace AI across everything we do, and that includes how you prepare for this interview. Feel free to use AI tools to research the role, practice your responses, and put your best foot forward. What matters to us is getting to know the real you — how you think, how you communicate, and what you genuinely bring to the table. Our interviews are designed to go deeper than any polished answer, so come curious and come as yourself without the support of an AI tool during our conversation.

Skills Required

  • Rising senior enrolled in a bachelor's degree program in a relevant field
  • Preferably graduating in Spring 2028
  • Available to start in June 2027
  • Must live in the Chicago, Illinois area during summer 2027
  • Must work in the office at least three days per week
  • Legally authorized to work in the United States for any employer without sponsorship
  • Exceptional written, verbal, and interpersonal communication skills
  • Problem-solving, creative thinking, and ability to deliver results
  • Strong organization, prioritization, and time-management skills
  • Ability to work independently and collaboratively with diverse, cross-functional teams
  • Intellectual curiosity and willingness to learn new tools, methods, and domains
  • Comfort interacting professionally with executives, managers, subject matter experts, and technical teams
  • Experience working in deadline-driven environments
  • Understanding of relational database concepts, including tables, keys, and simple normalization
  • Ability to write basic SQL queries using SELECT, JOIN, WHERE, and GROUP BY
  • Foundational knowledge of data structures and statistical concepts
  • Exposure to ETL/ELT concepts, data cleaning, transformation, and dataset preparation
  • Understanding of data modeling basics, including fact tables, dimension tables, and star schemas
  • Introductory experience with Python or R for data manipulation or exploratory analysis
  • Familiarity with Power BI, Tableau, or similar data visualization tools
  • Experience with Excel or Google Sheets, including formulas, pivot tables, and lightweight modeling
  • Basic exposure to Git or GitHub, including cloning, committing, or branching
  • Exposure to Jira, Azure DevOps, Google Workspace, Office 365, or similar collaboration tools
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Indianapolis, IN
490 Employees
Year Founded: 2008

What We Do

We are a passionate team of engineers, mathematicians, data analysts, project managers, and business consultants. But more importantly, we are active listeners, deep thinkers, and courageous problem solvers. The Resultant team purposefully comes together to produce a positive outcome. Our name symbolizes our commitment to empathy and collaboration—of not just delivering our clients with the best solutions, but to deeply listening to them, understanding their needs, and learning from each other in the process. The force of Resultant comes from the combined knowledge, passion, and innovation of our team and partners. Together, we partner with clients in the public and private sectors to help them overcome their most complex challenges, empowering our clients to drive meaningful change in their organizations and communities. In everything you do, you’ll help your clients, colleagues, and communities thrive. Resultant was founded as KSM Consulting in 2008.

Similar Jobs

IMC Trading Logo IMC Trading

Verification Engineer

Fintech • Machine Learning • Software • Financial Services
Hybrid
Chicago, IL, USA
1954 Employees

IDeaS Logo IDeaS

Sr Manager Accounting

Software • Analytics • Hospitality
Hybrid
Chicago, IL, USA
747 Employees

Wells Fargo Logo Wells Fargo

Counsel

Fintech • Financial Services
Hybrid
Chicago, IL, USA
205000 Employees
215K-355K Annually

MetLife Logo MetLife

Site Reliability Engineer

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
111K-180K Annually

Similar Companies Hiring

Northslope Thumbnail
Artificial Intelligence • Information Technology • Software • Analytics • Consulting • Generative AI
London, GB
100 Employees
Scotch Thumbnail
Artificial Intelligence • eCommerce • Fintech • Payments • Retail • Software • Analytics
US
35 Employees
Milestone Systems Thumbnail
Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account