PySpark Data Engineer, Analytics

| Chicago

Job Description Summary

The Enterprise Analytics team at CCC has an open position for a Big Data Engineer. The team builds platforms to provide insights to internal and external clients of CCC businesses in auto property damage and repair, medical claims and telematics data. Our solutions include analytical applications against claim processing, workflow productivity, financial performance, client and consumer satisfaction, and industry benchmarks.

Our data engineers use big data technology to create best-in-industry analytics capability. This position is an opportunity to use Hadoop and Spark ecosystem tools and technology for micro-batch and streaming analytics. Data behaviors include ingestion, standardization, metadata management, business rule curation, data enhancement, and statistical computation against data sources that include relational, XML, JSON, streaming, REST API, and unstructured data. The role has responsibility to understand, prepare, process and analyze data to drive operational, analytical and strategic business decisions.

The Big Data Engineer will work closely with product owners, information engineers, data scientists, data modelers, infrastructure support and data governance positions. We look for engineers who start with a base of big data skills but who also love to learn new tools and techniques in a big data landscape that is endlessly changing.

 

Job Duties

* Build end to end data flows from sources to fully curated and enhanced data sets. This can include the effort to locate and analyze source data, create data flows to extract, profile, and store ingested data, define and build data cleansing and imputation, map to a common data model, transform to satisfy business rules and statistical computations, and validate data content.
* Produce data building blocks, data models, and data flows for varying client demands such as dimensional data, data feeds, dashboard reporting, and data science research & exploration
* Modify and maintain complex SQL and PL/SQL for Oracle ETL and BI/DW data flows * Produce automated tests of data flow components
* Use knowledge of the business to automate business-specific tests for data content quality
* Automate code deployment and promotion
* Build automated orchestration and error handling for use by production operation teams
* Provide technical expertise to diagnose errors from production support teams
* Collaborate with team members in an Agile team (e.g., Scrum)
* Participate as both leader and learner in team tasks for architecture, design and analysis
* Coordinate within collocated on-site teams as well as with work plans for off-shore resources

 

Qualifications

Qualifications  
* Bachelor’s Degree or Two Year Technical Program with a Programming Specialization
* 3+ years’ experience with complex data flows
* Unix commands and scripting
* Hadoop fundamentals and architecture: HDFS, map-reduce, job performance
* Open source big data tools such as Hive, HBase, parquet, Spark SQL
* Advanced SQL for data profiling and data validation

* Programming in a language such as Python (preferred), Scala, etc.

 

Preferred Requirements:

* Familiar with open source monitoring and orchestration tools such as Ambari, Oozie
* Advanced transformations and statistical computations using Spark-SQL and Hive programming
* Experience with development of metadata-driven and fully parameterized data processing tools
* Programming in streaming-data tools such Spark-Scala, NIFI and Stream Analytics Manager

 

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.

 

 

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!

  • 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
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
222 Merchandise Mart, Chicago, IL 60654

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 an Architect, I get to work on those technologies and new ones with other pioneers - that type of innovation ignites my creativity.

Amin

Engineer, Architecture and 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

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
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
CCC's wellness programs include Interactive Health, SmartDollar, and Naturally Slim. All of these are provided free of charge
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Flexible Work Schedule
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
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement

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 CCC35 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
Marketing
Operations
Product
Project Mgmt
Data + Analytics
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Finance
new
Chicago
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Product
new
Chicago
Project Mgmt
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago