Data & Analytics Consultant

| Chicago

Aptitive is a Chicago-based data & analytics consulting firm that helps companies to uncover the power of their data. As an Aptitive consultant you’ll work closely with our clients, technology partners, and team to develop tech-forward solutions for our clients’ unique business challenges. Typical projects focus on areas such as:

  • Data Strategy

  • Data Modernization and Warehousing

  • Analytics & Business Intelligence

  • Application & Data Integration

  • Data Science & Machine Learning

Why Aptitive

At Aptitive, you’ll have the freedom to use your technical background and creative problem solving skills to make a direct impact on our clients. Exceptional client work is rewarded with fast-paced growth opportunities. Our biannual review process and mentorship program ensures that top performing consultants are recognized and promoted. We also offer a generous training stipend to further support our employees’ growth. 

Local projects and flexible schedules are just the tip of the iceberg when it comes to our commitment to work-life balance. Aptitive offers unique benefits, like our helping hand program and unlimited PTO, that help you to do what you love.

What You’ll Do

  • Provide data and analytics solutions to local clients throughout the Chicagoland area.

  • Collaborate with a team to help design and architect robust data and analytical solutions for our clients.

  • Learn and work with cutting-edge technologies and gain knowledge about industries such as Healthcare, Retail, Insurance, Manufacturing, and more.

  • Work directly with clients to understand and document their business & technology requirements Design, code, & test data-centric solutions.

  • Be involved from the beginning to the end of the system development life cycle (SDLC).

  • Mentor and help grow the careers of others.

  • Contribute significantly to the growth of Aptitive and our clients.

Our Ideal Candidate

General Attributes- Who You Are

  • You are curious and love to explore new technologies

  • You have strong analytical thinking and creative problem solving skills

  • You’re an effective communicator that’s comfortable presenting to executive clients

  • You have the ability to think independently while working in a collaborative environment

  • You have a passion for personal growth and continuous learning

  • You can quickly adapt to new situations and get comfortable being uncomfortable

  • You’re excited to share knowledge and expertise with other Aptitive software innovators and architects


  • Bachelor’s Degree or higher

  • Experience working with clients or customers

  • Can be productive independently and/or in a team

  • Diverse technology background or willingness and desire to learn new and unfamiliar technologies

  • Polished written and oral communication skills

  • Willing to commute to client sites within Chicagoland

  • Authorized to work in the United States

Desired Experience

  • Proven ability to develop a technical solution to a business problem

  • Ability to bridge the gap between a technical team and a business stakeholder

  • Familiarity with SQL and database development fundamentals

  • Experience in a team setting

  • Consulting, technology, or related experience a plus  

Select Technology Skill Sets

  • Has designed / built data models (dimensional, data vault, third normal form, etc.)

  • Database and SQL Development

  • Dashboard and Report Development

  • Cloud ETL Orchestration and Development

  • Custom Application Development using object oriented techniques

  • Knowledge of AWS and/or Azure Technologies, Architecture, and PaaS design patterns

  • Has written complex SQL statements to transform data from its raw format into a new data model format

  • Can identify discrepancies in data and raise concerns / findings

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • ASP.NETFrameworks
    • SparkFrameworks
    • TensorFlowFrameworks
    • TableauFrameworks
    • PowerBIFrameworks
    • LookerFrameworks
    • QlikFrameworks
    • AttunityFrameworks
    • FivetranFrameworks
    • AloomaFrameworks
    • AWSFrameworks
    • AzureFrameworks
    • GCPFrameworks
    • SSISFrameworks
    • InformaticaFrameworks
    • TalendFrameworks
    • AlationFrameworks
    • Data RobotFrameworks
    • PaxataFrameworks
    • DB2Databases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • TeradataDatabases
    • SnowflakeDatabases
    • AsanaManagement
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • WordpressCMS
    • MailChimpEmail


20 N. Wacker Drive Suite 4000, Chicago, IL 60606

An Insider's view of Aptitive

How would you describe the company’s work-life balance?

Work life balance is simple at Aptitive. Do what it takes to get the job done and do what you need to keep yourself happy and healthy. Work schedules allow the team the flexibility to do their work without sacrificing friends, family, or the things they love.


Director of Marketing

What kinds of technical challenges do you and your team face?

We work full end-to-end data solutions; everything from ingestion to advanced analytics! Great atmosphere for building your technical chops.



What makes someone successful on your team?

The most successful people at Aptitive simultaneously strive to better themselves and lift others up along the way. We are a team of people that gives constructive, real feedback privately and never shies to share credit for our successes publicly.


Managing Consultant

What is your vision for the company?

We founded this company based on the idea that people are our greatest asset. You want talent? These people are incredibly smart, but they are also nice to work with and a ton of fun. That kind of talent is hard to find.



What does your typical day look like?

Every single day is different which is what excites me most about my job. Most days include a status call with clients but a regular day could include technical code development, debugging, data modeling or meeting with business users.


Consultant I

What are Aptitive Perks + Benefits

Aptitive Benefits Overview

We bring you a career in technology consulting without the typical life trade-offs found in the industry.

Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Health Insurance & Wellness Benefits
Dental Benefits
Our dental plan covers 100% of premiums.
Vision Benefits
Our vision benefits plan covers 100% of premiums.
Health Insurance Benefits
Our health insurance policy covers 100% of premiums.
Onsite Gym
Team workouts
Aptitive's team fitness initiatives include Sponsored race teams.
Retirement & Stock Options Benefits
401(K) Matching
Aptitive provides employees with a 401(k) matching plan. We match 100% of contributions up to 4% of an employee's annual gross pay. 401(k) matches are vested on day one.
Child Care & Parental Leave Benefits
Flexible Work Schedule
Aptitive provides employees with a flexible work schedule that includes Flexible start and end times.
Remote Work Program
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Eligible employees get 20 days of paid sabbatical after their first 5 years of working at the company.
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Aptitive hosts quarterly company outings with your significant other or a +1. Examples: Rock Climbing, Brewery Tour, Top Golf, Cooking Class, Baseball game, etc.
Stocked Kitchen
Some Meals Provided
Happy Hours
Happy hours are hosted Once per month.
Professional Development Benefits
Job Training & Conferences
Aptitive offers employees professional development opportunities and provides a $3,000 annual stipend for training and continuous learning.
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Our mentorship program includes 1-to-1 mentoring for all employees.
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications
We cover 100% of expenses toward certifications in our industry.
More Jobs at Aptitive3 open jobs
All Jobs
Data + Analytics
Data + Analytics
Data + Analytics