OCC Logo

OCC

Associate Principal, Data Analytics Engineering

Posted 5 Days Ago
Hybrid
Chicago, IL, USA
124K-141K Annually
Junior
Hybrid
Chicago, IL, USA
124K-141K Annually
Junior
Designs and maintains OCC’s cloud analytics data warehouse, ETL pipelines, data models, ingestion frameworks, and supporting infrastructure. Uses AWS, Terraform, Ansible, Python, SQL, Docker, CI tools, Vault, and workflow orchestrators. Responsibilities include warehouse optimization, access controls, testing, documentation, data governance, analyst support, self-service enablement, and training. Collaborates with data platform, DBA, and business teams to deliver secure, reliable, business-oriented datasets.
The summary above was generated by AI

Duties:

Expand OCC’s analytics capabilities by making data accessible and usable to analysts throughout the organization. Act as an active contributor to the design and build of our internal analytics data warehouse and the maintenance of the supporting extract, load, and transform processes. Become an expert on OCC’s data sets and support teams across the organization in successfully harnessing this data. Drive the team responsible for gathering requirements and designing solutions that address the problem at hand while also anticipating yet-to-be-asked analytical questions, as well as collaborating with team members in defining and owning processes for developing and maintaining our analytics platform to meet the company’s security and IT standards. Design and implement cloud data warehouse infrastructure for internal facing analytics in collaboration with OCC’s Data Platform and other teams. Develop a batch process data ingestion framework for extraction from systems and loading to target location(s). Build data models to ensure information is available in our analytics warehouse for downstream uses, such as analysis and dashboard development. Maintain performance requirements of our analytics warehouse by tuning warehouse optimizations and storage processes. Collaborate with DBAs to design access controls around our analytics warehouse to meet business and internal governance needs. Create documentation and testing to ensure data is accurate and easily understandable. Use IaC tools like Terraform and Ansible to provision AWS cloud hardware and software, enabling teams to perform model development and run backtesting. Leverage Python frameworks, data modeling, shell programming and configuration as code to build SQL ETL (Extract Transform Load) pipelines to serve accurate business-oriented datasets to business users. Implement DevOps practices like containerizing app code with Docker and Continuous Integration pipelines with tools like Jenkins and JFrog Artifactory to ensure high quality code. Integrate services securely with HashiCorp Vault to manage secrets, and orchestrate data intensive applications with orchestrators like Automic UC4 and Apache Airflow. Promote self-service capabilities and data literacy for business users leveraging the platform through development of training presentations and resources. Discover and share best practices for data and analytics engineering with members of the team. Invest in your continued learning on data and analytics engineering best practices and evaluate them for fit in improving maintainability and reliability of analytics infrastructure. Assist analysts in solving their analytics questions/challenges. Up to 40% telecommuting permitted. OCC offers a standard benefits package.*This position qualifies for The Options Clearing Corporation’s Employee Referral Program.*

Education & Experience Required:

Master’s degree in data science, analytics, or related and two (2) years of experience as a data analyst, data analytics associate, or related

Special Skills Required:

Must have work experience with each of the following: 1) Use IaC tools like Terraform and Ansible to provision AWS cloud hardware and software, enabling teams to perform model development and run backtesting; 2) Leverage Python frameworks, data modeling, shell programming and configuration as code to build SQL ETL (Extract Transform Load) pipelines to serve accurate business-oriented datasets to business users; 3) Implement DevOps practices like containerizing app code with Docker and Continuous Integration pipelines with tools like Jenkins and JFrog Artifactory to ensure high quality code; and 4) Integrate services securely with HashiCorp Vault to manage secrets, and orchestrate data intensive applications with orchestrators like Automic UC4 and Apache Airflow. Up to 40% telecommuting permitted.

Salary

$124,400-$140,500

Apply:

OCC offers a standard benefits package. See a full list of benefits here: https://www.theocc.com/careers/thriving-together. Apply online at www.theocc.com. No calls. EOE.

About Us

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 19 exchanges and trading platforms. More information about OCC is available at www.theocc.com.

Benefits

A highly collaborative and supportive environment developed to encourage work-life balance and employee wellness. Some of these components include:

  • A hybrid work environment, up to 2 days per week of remote work
  • Tuition Reimbursement to support your continued education
  • Student Loan Repayment Assistance
  • Technology Stipend allowing you to use the device of your choice to connect to our network while working remotely
  • Generous PTO and Parental leave
  • 401k Employer Match
  • Competitive health benefits including medical, dental and vision

Visit https://www.theocc.com/careers/thriving-together for more information.

Compensation

  • The salary range listed for any given position is exclusive of fringe benefits and potential bonuses. If hired at OCC, your final base salary compensation will be determined by factors such as skills, experience and/or education.
  • In addition, we believe in the importance of pay equity and consider internal equity of our current team members as part of any final offer.
  • We typically do not hire at the maximum of the range in order to allow for future and continued salary growth. We also offer a substantial benefits package as noted on www.theocc.com/careers
  • All employees may be eligible for a discretionary bonus. Discretionary bonuses are based on various factors, including, but not limited to, company and individual performance and are not guaranteed.

Step 1
When you find a position you're interested in, click the 'Apply' button. Please complete the application and attach your resume.  

Step 2
You will receive an email notification to confirm that we've received your application.

Step 3
If you are called in for an interview, a representative from OCC will contact you to set up a date, time, and location. 

For more information about OCC, please click here.

OCC is an Equal Opportunity Employer

HQ

OCC Chicago, Illinois, USA Office

Adjacent to the Willis Tower, close to CTA, Metra and expressways with plenty of food and entertainment options nearby.

Similar Jobs at OCC

3 Days Ago
Hybrid
Chicago, IL, USA
137K-190K Annually
Senior level
137K-190K Annually
Senior level
Big Data • Cloud • Fintech • Information Technology • Financial Services
Leads enterprise infrastructure strategy and platform engineering across OpenShift, Kubernetes, automation, virtualization, networking, and cloud transformation. Designs highly available Kubernetes platforms, develops Infrastructure as Code and CI/CD automation, establishes GitOps deployment standards, and drives security, observability, disaster recovery, capacity planning, and cost optimization. Provides technical leadership and mentoring while partnering with development, security, networking, and infrastructure teams and communicating platform strategy to senior leadership.
Top Skills: Ansible Automation PlatformArgocdAWSBashGithub ActionsGitlab CiGitopsGrafanaHelmInfrastructure As CodeJenkinsKubernetesOpenshiftPrometheusPythonRed Hat Enterprise LinuxTektonTerraform
4 Days Ago
Hybrid
Chicago, IL, USA
119K-126K Annually
Mid level
119K-126K Annually
Mid level
Big Data • Cloud • Fintech • Information Technology • Financial Services
Analyzes complex business and technology problems across integrated financial technology platforms. Creates requirements documents, diagrams, user stories, acceptance criteria, and test plans; coordinates dependencies and delivery across agile product teams. Uses SQL, Tableau, R Studio, SAS, and integration tools to validate data, perform statistical modeling, document APIs and workflows, identify process gaps, and produce dashboards supporting operational improvements.
Top Skills: Automation AnywhereConfluenceDraw.IoJIRAOsi PiPostmanR StudioSASScaled Agile Framework (Safe)SQLTableauVisio
4 Days Ago
Hybrid
Chicago, IL, USA
87K-118K Annually
Senior level
87K-118K Annually
Senior level
Big Data • Cloud • Fintech • Information Technology • Financial Services
Develop and maintain test automation frameworks, create automated test plans, perform unit and end-to-end testing, diagnose defects, validate enterprise and SaaS systems, debug ETL and SQL processes, and improve delivery-control reporting. Collaborate cross-functionally within Agile teams using Python, Shell, Java, SAP ABAP, JUnit, and TestNG to improve testing efficiency and system quality.
Top Skills: AgileClarity PpmETLGitGCPHp NgqJavaJIRAJunitPythonSAPSap AbapShell ScriptingSQLTestng

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account