Responsibilities

JOB SUMMARY: Responsible for designing, developing, and executing automated testing solutions and comprehensive test plans related to Source System and Business Data Products to validate the integrity, accuracy, and consistency of enterprise data across multiple business domains. This role ensures the quality of data processed through ETL pipelines and data modeling scripts across platforms such as Oracle, SQL Server, and Snowflake. The QA Automation Engineer collaborates with data engineering, QA, and business teams to support scalable, reliable, and high quality data delivery across the organization. DUTIES & RESPONSIBILITIES: Design and Develop Automated Data Quality Tests: Create reusable, automated tests to validate data ingestion, transformations, and loading across Oracle, SQL Server, and Snowflake. Validate data integrity, completeness, schema conformity, and business logic through all layers - from raw landing zone to curated data products. Ensure End-to-End Data Pipeline Validation: Automate testing for ETL/ELT processes, including data staging, cleansing, fact and dimension population, and final consumption layers. Monitor transformations and data flows between platforms (Oracle - Snowflake, SQL Server - Snowflake, etc.). Leverage Snowflake-Specific Testing Capabilities: Use Snowflake's native SQL features (e.g., streams, tasks, time travel, variant types) in test development. Automate regression and functional testing for Snowflake data models, stored procedures, and materialized views. Build and Maintain a Cross-Platform Test Framework: Extend or integrate test automation frameworks compatible with Oracle, SQL Server, and Snowflake. Apply data validation tools to verify transformations. Utilize TestRail for Test Case Management: Design, document, and maintain test cases and test plans in TestRail. Track test execution, report defects, and maintain traceability across automated and manual test cases. Collaborate Across Data Engineering and Modeling Teams: Partner with data engineers, data modelers, and analysts to define test criteria for ingestion jobs, business logic, and reporting outputs. Provide early feedback on data development tickets and participate in code reviews. Support CI/CD and Test Automation in Production Pipelines: Integrate automated tests into CI/CD workflows. Validate data integrity during production releases, schema changes, and migrations. Develop Monitoring and Alerting for Data Quality: Set up data anomaly detection and alerting for critical pipelines (e.g., volume drops, schema drift, business rule violations). Create dashboards or automated reports for data quality trends. Ensure Test Coverage, Reusability, and Documentation: Maintain versioned, reusable test suites across platforms. Document test strategies, data quality standards, and platform-specific considerations. Perform other job related duties as needed. QUALIFICATIONS DEGREE TYPE: Bachelor's Degree FIELD(S) OF STUDY: Business Management, Computer Science, Industrial Engineering, or other related field of study EXPERIENCE: 5 - 7 years' experience in the role of Agile Project Manager or Delivery Coach, with focus on delivering solutions, preferably in the cruise industry. COMPETENCIES/SKILLS: Strong expertise in quality assurance practices for data platforms, including the design of automated quality frameworks, validation of data pipelines, and testing guided by risk priorities, combined with a strong understanding of regulatory and governance requirements that apply to data products. Proficiency with automated testing strategies, TestRail for test management, Snowflake features that support QA automation, and scripting or continuous-integration and delivery tools is essential to maintain system accuracy and efficiency. Strong analytical and troubleshooting abilities enable rapid defect isolation and continuous improvement of processes. Clear and collaborative communication with Product Owners, Delivery Coaches, Engineering, and business stakeholders to ensure test coverage keeps pace with changing data product objectives and compliance standards.