Snowflake Data Quality & SQL Engineer

Company Overview

Company details not specified.

Job Summary

We are seeking a highly motivated and detail-oriented Snowflake Data Quality & SQL Engineer to ensure the accuracy and reliability of our data within Snowflake. This role focuses on robust testing of data transformations and ingestion processes, contributing to the overall data integrity in our organization.

Responsibilities

• Interpret Data Mapping Documents: Analyze and understand complex data mapping specifications to ensure accurate translation of business rules into data transformations.
• Develop Advanced SQL Tests: Design and write intricate SQL queries within Snowflake to validate data quality, integrity, and transformation logic.
• Perform ETL Testing: Execute comprehensive Extract, Transform, Load (ETL) testing, including data validation, reconciliation, and defect identification.
• Automate Ingestion Testing with Python: Develop and maintain Python scripts to automate testing of file ingestion processes into Snowflake, ensuring that data lands correctly and efficiently.
• Collaborate and Report: Work closely with data engineers and stakeholders to troubleshoot data issues, document findings, and contribute to continuous data quality improvements.

Qualifications

• Technical Skills: Proficiency in SQL, Python, Snowflake, and ETL processes.
• Analytical Skills: Strong analytical and problem-solving skills, with the ability to interpret complex data requirements.
• Attention to Detail: High attention to detail and commitment to maintaining data integrity and accuracy.
• Collaboration Skills: Excellent communication and collaboration skills for engaging with team members and stakeholders.
• Testing Expertise: Experience with manual and automated testing methodologies.
• Education: A degree in Computer Science, Information Technology, Data Science, or a related field is preferred.

Preferred Skills

• Familiarity with data quality frameworks and methodologies.
• Experience with additional programming languages or data engineering tools.
• Knowledge of cloud-based data solutions and best practices.

Experience

• Minimum of 3-5 years of experience in data quality engineering, SQL development, or data testing roles.

Environment

Work setting details are not specified, such as remote, in-office, or hybrid arrangements.

Salary

Salary details are not specified.

GrowthOpportunities

Career advancement opportunities within the company are not specified.

Benefits

Information on offered benefits is not provided.