Description

You will ensure data integrity and quality across the end-to-end data pipeline.

Responsibilities

• Develop and execute test plans to validate data movement between Snowflake and external sources.
• Monitor and validate ETL processes to ensure accurate and efficient data loading.
• Automate data validation and quality checks using SQL, Python, and Soda.io.
• Track, document, and manage data quality issues within Snowflake and the wider pipeline.
• Collaborate with data engineers to resolve discrepancies and perform regression testing on the data platform.

Required Skills

• 7+ years of hands-on testing experience with Snowflake, including data modeling and ETL/ELT processes.
• Expertise in data validation, query optimization, and data management best practices.
• Advanced SQL skills, including joins, subqueries, and complex query writing.
• Experience with RDBMS and data pipeline frameworks integrated with Snowflake.
• Experience with cloud platforms, specifically AWS and its data services.
• Basic knowledge of AWS Airflow and Soda.io.
• Basic Python scripting skills.
• Bachelor's degree.

Preferred Skills

• Snowflake Certification (e.g., SnowPro Core).
• Experience with AWS DevOps CI/CD.
• Experience in the pharma or healthcare sector.
• Experience with Azure or Google Cloud platform data services.
• Working knowledge of Agile methodologies like Scrum or Kanban.

Key Skills

Education

Bachelor's degree