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

Location: Chicago, IL, us Department: PS_Data Science Team Employment Type: {'id': 'permanent', 'label': 'Full-time'}

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.