OCC Logo

OCC

Associate Principal, Quality Assurance

Posted 14 Days Ago
Be an Early Applicant
Hybrid
Chicago, IL, USA
102K-137K Annually
Mid level
Hybrid
Chicago, IL, USA
102K-137K Annually
Mid level
Design and implement quality metrics and ETL pipelines for reporting. Collaborate in Agile teams to analyze requirements, create test scenarios, validate data, monitor KPIs, optimize SQL performance, develop reusable ETL frameworks, integrate Tableau dashboards, recommend automation tools, and lead QA governance and team workload management.
The summary above was generated by AI

Duties:

Responsible for design and development of quality metrics implementation for Ovation Program Reporting. Attend high level design sessions, code walkthroughs and offer suggestions, and guidance on any topic that could have a negative impact. Work in an Agile team throughout Lifecycle to collaborate on the analysis, design, development and testing. Actively participate in the Sprint planning session and assist in creating stories with robust acceptance criteria while helping identify missing or incomplete requirements. Analyze the business requirements, understand the expectations from end user, review with SMEs and design test scenarios for report deliverables. Attend daily scrum standup and report testing issues. Provide key input during retrospective meetings. Create detailed reporting and tracking of quality KPIs. Clearly articulate the governance and compliance standards for testing artifacts and quality KPIs. Monitor and update quality reports as needed to ensure timely problem resolution.. Use Alteryx or Airflow DAG and SQL to design and implement ETL pipelines, automate ingestion and transformation workflows, and perform data validation and reconciliation for regulatory and analytics reporting.. Leverage MSSQL Server or Big-Query to write complex SQL queries and integrate Tableau dashboards to analyze large datasets and deliver governance metrics and executive reporting. Develop reusable ETL frameworks using Alteryx or Airflow DAG and SQL to standardize data onboarding, enforce audit controls, and improve processing efficiency across enterprise systems. Develop reusable ETL frameworks using Alteryx or Airflow DAG and SQL to standardize data onboarding, enforce audit controls, and improve processing efficiency across enterprise systems. Monitoring and optimizing SQL query performance across ETL pipelines, ensuring data integrity through automated quality validation checks, and iteratively updating query logic to meet with operational reporting standards. Participate in the communication and analysis of user behavior in recording test results and patterns, providing a feedback loop to quality assurance teams. Identify, evaluate, and recommend automation tools for testing reports. Provide accurate timelines for the stakeholders and make sure deadlines are met without affecting the quality of the product. Prioritize, assign and balance workload of the team as per the timelines. Responsible for continuously improving the QA governance process and technologies. Leverage AI to implement tools that enhance the efforts across Reporting. 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:

Bachelor’s degree in computer science or related and three (3) years of experience as a quality assurance engineer, software engineer, data engineer, or related

Special Skills Required:

Must have work experience with each of the following: 1) Use Alteryx or Airflow DAG and SQL to design and implement ETL pipelines, automate ingestion and transformation workflows, and perform data validation and reconciliation for regulatory and analytics reporting; 2) Leverage MSSQL Server or BigQuery to write complex SQL queries and integrate Tableau dashboards to analyze large datasets and deliver governance metrics and executive reporting; 3) Develop reusable ETL frameworks using Alteryx or Airflow DAG and SQL to standardize data onboarding, enforce audit controls, and improve processing efficiency across enterprise systems; and 4) Monitoring and optimizing SQL query performance across ETL pipelines, ensuring data integrity through automated quality validation checks, and iteratively updating query logic to meet with operational reporting standards. Up to 40% telecommuting permitted.

Salary

$102,100-$137,000

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
143K-228K Annually
Senior level
143K-228K Annually
Senior level
Big Data • Cloud • Fintech • Information Technology • Financial Services
The Lead Associate Principal in Cloud Engineering will oversee Kubernetes management, automation, and provide technical guidance, ensuring high availability and compliance in cloud-native environments.
Top Skills: AnsibleAWSChefCi/CdDockerGitGoHelmKafkaKubectlKubernetesPuppetPythonTerraform
6 Days Ago
Hybrid
Chicago, IL, USA
175K-283K Annually
Expert/Leader
175K-283K Annually
Expert/Leader
Big Data • Cloud • Fintech • Information Technology • Financial Services
Lead solution architecture for OCC's next-generation clearing system: design distributed, cloud-native, event-driven and batch systems (Kafka, microservices, Kubernetes), define architecture standards and NFRs, guide implementation, collaborate with DevOps/security, document decisions, and mentor engineering teams.
Top Skills: Apache IcebergArgocdArtifactoryAWSC#DockerDomain-Driven DesignEvent-Driven ArchitectureForgerockGitInfrastructure As CodeJavaJenkinsJwtKafkaKubernetesMicroservicesOauth2/OidcProtocol BuffersPythonS3SailpointTerraform
8 Days Ago
Hybrid
Chicago, IL, USA
98K-142K Annually
Mid level
98K-142K Annually
Mid level
Big Data • Cloud • Fintech • Information Technology • Financial Services
Support the Director of Operational Risk by conducting IT and security risk assessments, maintaining risk inventories, generating Archer reports, coordinating with IT, Security, Legal, Compliance and Internal Audit, communicating results to governance, and enhancing ORM methodologies and automation.
Top Skills: ArcherEgrc SystemsMicrosoft AccessExcelMicrosoft PowerpointMicrosoft Word

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