Data Analyst, Information Engineer

| Chicago

Job Description Summary

The Enterprise Analytics team at CCC is seeking a Data Analyst, Information Engineer that turns healthcare claims data into business information that creates high business value from the business.
The Enterprise Analytics team provides analytical solutions for all CCC’s customers from insurance carriers, repair shops, parts manufacturers, and vehicle manufacturers. CCC’s software for these clients captures vehicle property damage and repair; medical claims, and telematics data that the analytics team turns into business relevant information for our internal CCC consultants and external clients.

Analytical solutions provided by the team range include operational analytical solutions for productivity, cost management, process cycle time, organizational productivity and financial performance; and advanced analytics with industry benchmarks to measure performance against competition.

As a Data Analyst, Information Engineer, you will be working with CCC’s customers and internal stakeholders to create data sets for self service to be used by others for reporting and also some reports. Your business, communication, and technical skills will enable you to be successful in understanding and providing data that will assist the user in making decisions to improve performance for their responsibilities. Your will be enabling CCC to have a robust data environment to assist in helping users determine the right auto repair costs, medical treatment costs, and other important outcomes such as process time, productivity and consumer satisfaction.

Job Duties

Duties & Responsibilities

  • Work with auto damage & healthcare claims data
  • Engage internal and external clients for developing and solutioning analytical requirements
  • Build data sets and reports using Big Data Technology such as Hive and Spark SQL, and using Tableau and MicroStrategy
  • Work closely with a self service product manager to identify data and business rule requirements that require data engineering resources
  • Validate accuracy of reports and data provided
  • Train internal and external users on how to perform self service reporting with the report templates and data sets that you created
  • Bachelor’s Degree in Computer Science, Information Systems, Engineering or other related field.
  • Medical claims or Auto insurance industry experience
  • Minimum 2-3 years’ experience in developing user reporting with BI tools such as Tableau or MicroStrategy
  • Proficiency in Dimensional Data Models and Data Warehouse concepts 
  • Strong SQL and scripting skills
  • Ability to quickly understand business concepts by demonstrating mastery of a business and industry area and the analytics that create business value
  • Understanding of databases, ETL tools, and best practices in creating and delivering useful information
  • Technical aptitude and problem-solving skills, cooperative approach
  • Self-motivated and self-managed with a high degree of analytical and intellectual curiosity
  • Ability to be a strong agile team member, mentor others, and communicate effectively
  • Capability to prioritize and multi-task, and reasonably estimate work effort for tasks

Qualification

  • Bachelor’s Degree in Computer Science, Information Systems, Engineering or other related field.
  • Medical claims or Auto insurance industry experience
  • Minimum 2-3 years’ experience in developing user reporting with BI tools such as Tableau or MicroStrategy
  • Proficiency in Dimensional Data Models and Data Warehouse concepts 
  • Strong SQL and scripting skills
  • Ability to quickly understand business concepts by demonstrating mastery of a business and industry area and the analytics that create business value
  • Understanding of databases, ETL tools, and best practices in creating and delivering useful information
  • Technical aptitude and problem-solving skills, cooperative approach
  • Self-motivated and self-managed with a high degree of analytical and intellectual curiosity
  • Ability to be a strong agile team member, mentor others, and communicate effectively
  • Capability to prioritize and multi-task, and reasonably estimate work effort for tasks
  • Demonstrated capability to understand business needs and translating these needs into a user experience and visualizations that enable effective decision making with data
  • Complex SQL building including temp or intermediate tables
  • Report data modeling skills to build data sets
  • Experience with big data tools (Hadoop, Hive, Spark, etc.)

 

Why Choose CCC:

We promote a healthy work-life balance and offer generous benefit plans and resources designed with employee satisfaction in mind.
What we value is simple - customers, employee commitment, collaboration and clear communication.

We hire people who will embrace the company’s goals and productively contribute in ways that help us serve the customer, innovate, and stay strong.
We make it a priority to keep employees healthy, happy and enriched.

  • Healthy - Wellness programs, competitive medical benefit offerings
  • Happy – Recognition programs, a confidential employee assistance program, Perkspot/employee discount program and potentially flexible work arrangements such as staggered start times
  • Enriched – Tuition reimbursement, training and learning programs, and leadership development opportunities

Our corporate headquarters is located in downtown Chicago within the historic Merchandise Mart—a certified LEED (Leadership in Energy and Environmental Design) building.

Please Note: Contingent Workers, Field Inventory Representatives and Interns are not eligible for the benefits above.

CCC Information Services was recognized by Forbes as one of America’s Best Mid-Sized Employers in 2018 and ranked #17 in the Top 100 Digital Companies in Chicago in 2017 by Built In Chicago.

CCC is ready to help you shift your career into high gear. Let's get started!

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • DjangoFrameworks
    • SpringFrameworks
    • HadoopFrameworks
    • HBaseDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • NoSQLDatabases
    • SparkDatabases
    • Google AnalyticsAnalytics
    • PhotoshopDesign
    • JIRAManagement
    • WordpressCMS

Location

Two city blocks and twenty-five stories of innovation and culture. theMART is interwoven into the fabric of Chicago’s history as an innovator in tech

An Insider's view of CCC

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

I've been here 5 years, and I learn something new everyday. I have the opportunity to grow my skill set, the flexibility to spend time with my family, and the support to accomplish my professional goals.

Prasanthi

Manager, Quality Assurance

How do you collaborate with other teams in the company?

There is a strong focus on learning and progressing from missteps, with the ultimate goal of making sure we meet
business needs. I have the flexibility to talk directly to people outside of my immediate team which speeds up the delivery process, and aids in responsiveness.

Jennifer

Services Delivery Manager - Austin, TX

How has your career grown since starting at the company?

When I started as an intern at CCC, I was trusted to work with extraordinary technology. Now, as a DevOps Manager, I get to work on those technologies and new ones with other pioneers - that type of innovation ignites my creativity.

Amin

Manager, DevOps

How do you empower your team to be more creative?

Our teams are technically adept and highly capable. Equally, if not more importantly, they have a passion and desire to learn. We're not satisfied just cranking out code, there is a strong desire to learn about our customers and be creative

John

Director, Product Development

How does the company support your career growth?

Employees get to learn about multiple products across our entire customer base. This allows employees to figure out what area aligns best with their strengths and interests, and where they are looking to grow.

Susanne

Manager, Operations

What are CCC Perks + Benefits

CCC Benefits Overview

Perks are fun, but they should also be highly functional. So we offer more than just free coffee and gym membership benefits (though we've got those, too). We offer comprehensive and well thought-out benefits for your health, happiness and bank account.

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
CCC's Flexible Spending Accounts (FSA) help employees cover out-of-pocket expenses with pre-tax contributions for medical, dental, vision, prescription drug, and dependent care expenses.
Disability Insurance
CCC provides short-term and long-term disability insurance.
Dental Benefits
CCC provides two dental plans with Aetna, PPO and DMO.
Vision Benefits
CCC provides two vision plans with VSP.
Health Insurance Benefits
CCC offers four medical plans offered through BCBSIL (PPO, Health Savings Account [HSA], Health Care Account [HCA], and Kaiser Permanente HMO.
Life Insurance
Pet Insurance
Wellness Programs
CCC's wellness programs includes bio-metric screenings, financial wellness, and weight loss programs. All of these are provided free of charge.
Onsite Gym
Retirement & Stock Options Benefits
401(K)
CCC offers ROTH and/or pre-tax contributions.
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Flexible Work Schedule
Remote Work Program
CCC allows employees to work remotely pending their team and manager's discretion.
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Happy Hours
Monthly in-house happy hours organized by our CCC employees. Often these have themes for each month depending on time of year. March Madness, Cubs vs White Sox, Mardi Gras, and more!
Parking
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
CCC offers tuition reimbursement to an accredited academic institution for all full-time employees up to $5,250 annually.

Additional Perks + Benefits

We know that investing in employee development is crucial. Employees have access to the CCC Learning Academy. The CCC Learning Academy was created as an internal platform for you as an employee. You come here to learn new skills such as time management, cooking, financing a home or career and business development. We empower our employees to learn within these four walls, but then go out and collaborate on these ideas with friends and family

More Jobs at CCC32 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Internships
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Product
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Project Mgmt
new
Chicago
Design + UX
new
Chicago
Project Mgmt
new
Chicago