Data Engineer - Snowflake

About Arch:
Arch Capital Group Ltd. (Arch) is a leading global insurer with operations in more than a dozen countries. We write insurance, reinsurance and mortgage insurance on a worldwide basis, and our customers value us as an innovative partner and dependable risk manager with decades of fresh ideas and solid results. Part of the S&P 500, Arch has the size and capital position to remain a market-leading specialty insurer.

Snowflake QA Analyst

We are looking for a Snowflake QA Analyst to ensure the accuracy, reliability, and quality of our Snowflake-based data pipelines, warehouse processes, and analytics solutions.

Responsibilities:

• Develop and execute test cases for Snowflake data pipelines, transformations, and SQL logic.
• Validate data integrity, lineage, and business rules across ETL/ELT workflows.
• Perform functional, regression, integration, and backend database testing.
• Log defects, track resolutions, and collaborate with data engineers and developers.
• Review requirements and provide QA input during design and development.
• Document test results and support post-deployment validation.

Required Skills:

• Strong SQL skills with hands-on experience in Snowflake.
• Experience testing data pipelines (ADF, Airflow, Informatica, DBT, etc.).
• Solid understanding of data warehousing concepts and cloud platforms (Azure/AWS/GCP).
• Familiarity with QA processes, defect management tools (e.g., JIRA), and Agile practices.
• Strong analytical and communication skills. Preferred Qualifications
• 58 years in QA, with at least 12 years in data/Snowflake testing.
• Experience validating dashboards/reports and BI tools.
• ISTQB/CSQA or relevant QA certifications (preferred).
• Experience in insurance or financial services is a plus.