Data & Analytics Senior Consultant at Aptitive

| Chicago
!Sorry, this job was removed at 11:48 a.m. (CST) on Wednesday, February 12, 2020
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 Senior 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 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 bi-annual review process and mentorship program ensures that top performing consultants are recognized and promoted. We also offer a generous training stipend to further support employee growth. 

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

What You’ll Do

  • Provide data and analytics solutions to local clients throughout the Chicagoland area.
  • Learn and work with cutting-edge technologies.
  • Gain knowledge about industries such as; healthcare, retail, insurance, manufacturing, etc.
  • Lead 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 needs 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.
  • Assist in the sales process and help develop new business.
  • 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 have architected and implemented data solutions
  • You’re excited to share knowledge and expertise with other Aptitive software innovators and architects

Requirements

  • Bachelor’s degree or higher
  • 5+ years of experience providing data solutions in a client/customer facing role
  • Diverse technology background
  • Willingness and desire to learn new and unfamiliar technologies
  • Polished written and oral communication skills
  • Experience guiding junior developers
  • Designed ETL and/or analytical architectures
  • Ability to bridge the gap between a technical team and business stakeholders
  • Have experience in the design of data vault and/or dimensional models
  • Can be productive independently and in a team environment
  • Experience mentoring and developing junior employees
  • 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

  • Earned a Masters Degree in a related field
  • Proven ability to develop a technical solution for a business problem
  • Experience with the System Development Life Cycle (SDLC)
  • Ability to lead internal initiatives in addition to client work

Technology Skills

  • Understand and have successfully implemented cloud architectures
  • Have designed and 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
  • Have 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
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 Aptitive6 open jobs
All Jobs
Data + Analytics
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
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