Associate Principal, Quality Assurance
Core
Design and develop quality metrics implementation for Ovation Program Reporting, focusing on ETL pipelines, data validation, and governance metrics for regulatory and analytics reporting.
Role type
Associate Principal Quality Assurance Engineer (Data & Reporting)
Builds
ETL pipelines, Tableau dashboards, automated quality validation checks, and governance reporting artifacts.
Domain
Financial Services / Data Engineering / Quality Assurance
Deliverable
production ML models | product features | dashboards & analysis
Required skills
ETL pipeline design (Alteryx/Airflow/SQL), complex SQL query writing, Tableau dashboard integration, data validation and reconciliation, SQL query performance optimization, reusable framework development, QA governance process improvement.
Preferred skills
AI tool implementation for reporting enhancement, automation tool identification for testing.
Technologies
Alteryx, Airflow DAG, SQL, MSSQL Server, BigQuery, Tableau
Responsibilities
Design and implement ETL pipelines for data ingestion and transformation; Write complex SQL queries to analyze large datasets and deliver executive reporting; Develop reusable ETL frameworks to standardize data onboarding and enforce audit controls; Monitor and optimize SQL query performance across pipelines; Create detailed reporting and tracking of quality KPIs; Participate in Agile sprint planning and create test scenarios with robust acceptance criteria.
Seniority
Senior, hands-on IC