Data Engineering Consultant

| Chicago
Apply now

Job Summary

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

  • Data Strategy
  • Data Modernization & Warehousing
  • Analytics & Business Intelligence
  • Application & Data Integration
  • Data Transformation

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 bi-annual review process and mentor program ensures that top performing consultants are recognized and promoted. We also offer a generous training stipend to further support our employee’s growth. 

Local projects and flexible schedules are just small indications of our commitment to work-life balance. Aptitive offers unique benefits to help you do what you love, for example our helping hand program and unlimited PTO.

What You’ll Do

  • Work with local clients throughout the Chicagoland area.
  • Learn and work with cutting-edge technologies.
  • Gain knowledge about industries such as healthcare, retail, insurance, manufacturing, etc.
  • Collaborate with a team to help design and architect robust data and analytical solutions for our clients.
  • Work directly with clients to understand and document their business and technology requirements.
  • Design, code and 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

  • You’re 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 are comfortable being uncomfortable
  • You’re excited to share knowledge and expertise with other Aptitive software innovators and architects

Requirements

  • Bachelor's Degree or higher
  • Experience working with clients or customers
  • Diverse technology background
  • Willingness and desire to learn new and unfamiliar technologies
  • Polished written and oral communication skills 
  • Willing to commute to client sites within the Chicagoland area
  • Fun and enjoyable to work with
  • Authorized to work in the United States

Desired Experience

  • Previous consulting experience
  • 1-2 years experience working in technology
  • Ability to bridge the gap between a technical team and business stakeholders
  • SQL and database development fundamentals
  • Experience working in a team setting
  • Experience working with clients or customers
  • Experience with multiple phases of the System Development Life Cycle (SDLC)

Technology Skills

  • Dimensional and Relational Data Modeling
  • Database and SQL development
  • Dashboard and report development
  • ETL orchestration and development experience
  • Custom application development using object oriented techniques
  • Knowledge of AWS and/or Azure technology, architecture and design patterns
Read Full Job Description
Apply now

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

Location

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.

Bridgette

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.

Greg

Manager

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.

Cierra

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.

Paul

CEO

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.

Erin

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.

Culture
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
Open office floor plan
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)
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
Sabbatical
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.
Continuing Education stipend
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 Aptitive4 open jobs
All Jobs
Data + Analytics
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Apply now
Save jobView Aptitive's full profileSee more Aptitive jobs