> Markdown version of [/jobs/ext/1484388-associate-principal-quality-assurance](https://www.wearedevelopers.com/jobs/ext/1484388-associate-principal-quality-assurance). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Associate Principal, Quality Assurance - **Company:** The Options Clearing Corporation - **Location:** Chicago, IL, United States (Remote available) - **Experience:** Experienced - **Salary:** $102,100.0 - $137,000.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Agile Methodology, Artificial Intelligence, Airflow, Big Data, BigQuery, Data Validation, Data Integrity, Extract Transform Load (ETL), Microsoft SQL Server, Scrum Methodology, SQL Databases, Freeform SQL, Information Technology, Alteryx - **Published:** July 29, 2026 - **Apply:** https://theocc.wd5.myworkdayjobs.com/careers/job/Chicago---125-S-Franklin/Associate-Principal--Quality-Assurance_REQ-4751 ## About the Role 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 ## Description 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.*, 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [The Affordances of Quality](https://www.wearedevelopers.com/videos/1134-the-affordances-of-quality) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Self-service Quality: QA Without QA](https://www.wearedevelopers.com/videos/100184-self-service-quality-qa-without-qa) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Trustworthy AI Starts at Deployment: 5 Checks Before You Ship](https://www.wearedevelopers.com/magazine/753-trustworthy-ai-starts-at-deployment-5-checks-before-you-ship) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)