Lead QA & Data Quality Engineer — ETL, SQL & Tableau

The Options Clearing Corporation (OCC); Chicago (IL); Hybrid; USD 102,100 - 137,000; Full time

Benefits offered by this job

Hybrid work up to 2 days remote

Tuition reimbursement

Student loan repayment assistance

Technology stipend

Generous PTO and parental leave

401k employer match

Comprehensive health benefits

Job summary

The Options Clearing Corporation (OCC) is hiring a QA/Data Engineer to design and implement quality metrics for Ovation Program Reporting. You will participate in Agile teams, contribute to sprint planning, and help craft robust acceptance criteria while ensuring data governance and test coverage.

You will build ETL pipelines, validate data, and develop dashboards for governance metrics. Primary tools include Alteryx or Airflow, SQL in MSSQL Server or BigQuery, and Tableau for executive

Qualifications

• Bachelor’s degree in computer science or related field with 3+ years in QA/engineer/ data engineer roles.
• Experience designing ETL pipelines with Alteryx or Airflow and SQL.
• Ability to interpret business requirements and design test scenarios.

Responsibilities

• Design and develop quality metrics implementations for Ovation Program Reporting.
• Participate in Agile lifecycle including sprint planning, daily standups, and retrospectives.
• Create and track quality KPIs and governance artifacts; ensure timely problem resolution.

Skills

ETL pipelines

SQL queries

ETL frameworks

SQL performance monitoring

Education

Bachelor's degree in computer science or related plus 3 years QA/engineer/data engineer experience

Tools

Tableau

MSSQL Server

BigQuery

Alteryx

Airflow

Job description

The Options Clearing Corporation (OCC) is hiring a QA/Data Engineer to design and implement quality metrics for Ovation Program Reporting. You will participate in Agile teams, contribute to sprint planning, and help craft robust acceptance criteria while ensuring data governance and test coverage.

You will build ETL pipelines, validate data, and develop dashboards for governance metrics. Primary tools include Alteryx or Airflow, SQL in MSSQL Server or BigQuery, and Tableau for executive