Summer Intern - Data

theocc; Chicago (IL); Hybrid; USD 28,000 - 48,000; Full time

Benefits offered by this job

Paid sick leave

Job summary

OCC offers a 12-week Summer Internship Program open to undergraduate and graduate students, with interns working up to 40 hours per week in a hybrid environment. Interns contribute to analytics by building Tableau dashboards, writing SQL, and collaborating across teams to deliver data-driven insights.

OCC emphasizes real-world learning in financial services, with opportunities to expand internal analytics data warehouse capabilities and use on-premise and cloud-based tools.

Qualifications

• Pursuing an undergraduate or graduate degree in a related field.
• Experience with SQL for data analysis.
• Familiarity with Tableau or similar BI tools is preferred.

Responsibilities

• Develop and maintain interactive Tableau dashboards to visualize key metrics.
• Write and optimize SQL queries to analyze large datasets from multiple sources.
• Collaborate with cross-functional teams to gather requirements and deliver insights.
• Leverage AI-assisted development tools to accelerate feature development and documentation.

Skills

Tableau

SQL

Data Visualization

Team Collaboration

Claude Code

Education

Undergraduate or Graduate Student

Tools

Claude Code

Job description

About OCC:

The Options Clearing Corporation (OCC) is the world's largest equity derivatives clearing organization. Founded in 1973, OCC is dedicated to promoting stability and market integrity by delivering clearing and settlement services for options, futures and securities lending transactions. As a Systemically Important Financial Market Utility (SIFMU), OCC operates under the jurisdiction of the U.S. Securities and Exchange Commission (SEC), the U.S. Commodity Futures Trading Commission (CFTC), and the Board of Governors of the Federal Reserve System.

OCC has more than 100 clearing members and provides central counterparty (CCP) clearing and settlement services to 21 exchanges and trading platforms.

OCC also provides free and engaging educational resources about the benefits and risks of options through its Options Industry Council (OIC ).

OCC is building a culture that empowers continued learning, authentic innovation, and constant creativity.

About the Intern Program:

OCC is looking for interns who are eager to learn, humble enough to ask questions, and ready to think critically about complex problems.

The OCC Internship Program equips students with the real-world skills needed to transition successfully into a career in financial services.

As an intern, you will contribute to meaningful projects, applying your skills and knowledge to real challenges facing the business.

Your time with us is a real opportunity to make a genuine impact on the future of OCC!

OCC's Summer Internship Program is a 12-week opportunity running either May through August or June through September, and is open to undergraduate and graduate students who are actively enrolled at a college or university.

Interns work up to 40 hours per week in a hybrid work environment, and overtime is not permitted.

About the Team & Role

In this role, you will create solutions to complex technical challenges while coding, testing, troubleshooting, debugging, and documenting the systems you develop.

This role will drive a team responsible for expanding OCC's analytics capabilities by making internal corporate data accessible and usable to analysts throughout the organization.

This role will drive the design and building of our internal analytics data warehouse and the maintenance of the supporting extract, load, and transform processes. This role will also demonstrate expertise in OCC's corporate data sets and support teams across the organization in successfully harnessing this data.

This role will drive a team to collaborate with business users and technical teams across the organization to facilitate data-driven decision making by enabling exploration and analysis of historical and near real-time data access using on premise and cloud-based tools and technologies.

Job Summary & Responsibilities

• Develop and maintain interactive Tableau dashboards to visualize key business metrics and support data-driven decision making across departments
• Write and optimize SQL queries to analyze large datasets from multiple data sources to support reporting and analytics initiatives
• Collaborate with cross-functional teams to gather requirements, troubleshoot data issues, and deliver actionable insights through clear data visualizations
• Leverage AI-assisted development tools, including Claude Code, to accelerate feature development, test generation, code review, and documentation while building good engineering habits in a regulated environment.
• Collaborate with business users and technical teams across the organization to understand data needs, gather requirements, and co

INTERNS AND SEASONAL INTERNS ARE ELIGIBLE ONLY FOR PAID SICK LEAVE ACCRUED BASED ON HOURS WORKED. NO OTHER BENEFIT INCLUDING TECHNOLOGY STIPEND APPLY TO INTERNS OR SEASONAL INTERNS