Business Intelligence Engineer Internship Summer 2021
About CCC
CCC Information Services Inc. is the technology platform for the underwritten assets economy. CCC technology, insights, and support connect industries – insurers, automotive manufacturers, collision repairers, parts suppliers, lenders, fleet operators and more – to advance decision-making, productivity, and customer experiences for thousands of clients worldwide. Clients leverage CCC’s network management, data management, AI, operational workflows and customer experience solutions to efficiently scale, interact, transact and achieve their unique business objectives. CCC was ranked a best mid-sized company to work for by Forbes (2019). BuiltIn Chicago, Austin and LA named CCC a top place to work in 2020. Diverse perspectives and experiences are core to CCC’s success and award-winning culture of more than 2,000 employees worldwide. We hold inclusion as a core value and are committed to celebrating and cultivating the diversity of our team. With a 40+ year track record of innovation, CCC’s tenacious spirit and growth mindset turn next generation technology into real world solutions and empower team members to expand their knowledge and potential. Headquartered in Chicago, CCC has 11 locations worldwide. CCC’s principal PE investors are Advent International, Technology Crossover Ventures, and Oak Hill Capital Find out more about CCC Information Services by visiting cccis.com.
Job Description Summary
CCC Jumpstart Summer Internship Program Our program is designed to jumpstart your career! At CCC, you will work and learn alongside innovative and inspiring leaders and gain valuable experience working on real business solutions in a corporate setting. You will also have an opportunity to participate in unique events throughout the summer from professional development workshops to Lunch and Learn events with CCC colleagues and leaders. You will get to network, connect, and collaborate with other interns in your cohort. If located in Chicago, there is also the option to continue your internship after the summer.
Job Duties
The ideal candidate has a passion for data, storytelling, and analytics. You will be expected translate client needs into actionable dashboards that offer deep insight into data with app-like performance. Your work will be both technical and visual – straddling the divide of technology and art.
- Source data from a variety of Big Data sources including Oracle, Hive and Redshift
- Work with a development team to create exciting visual insights into tough business problems for both internal and external clients
- Work with various stakeholders to understand business requirements and translate them into creative solutions
- Collaborate with data engineers to understand the data architecture, gaps and logic, which you will translate into dashboard solutions
This opportunity is a paid, full time, summer internship. There will be two cohorts for the upcoming summer internship program:
May 17th, 2021—August 13th, 2021
June 21st, 2021—September 10th, 2021
Qualifications
- Pursing or completing a Master’s Degree a plus
- Basic to intermediate knowledge of Tableau desktop
- Basic to intermediate knowledge of SQL and database schemas
- Basic Python experience
- Basic Command Prompt experience
- Strong attention to detail
- Basic understanding of Quality Assurance (QA) and QA principles
- Good written language skills
- Innovative/outside of the box thinker
- Team player
Nice to Have
- Experience with Agile software development
- Visual design, visualizing information and UX aesthetics skills
- Adobe Photoshop and Illustrator a strong plus
- Understanding of design principles i.e. color theory or gestalt principles
- Experience with object management in Tableau Server a plus
- SQL development a plus
- Experience with SQL views a strong plus
- Presentation skills