Data Quality Engineer

Vedan Technologies; Connecticut; On-site; USD 90,000 - 120,000; Full time

Job summary

Vedan Technologies is looking for a Senior Data Quality Engineer to join our Data Readiness team in Connecticut. This role involves evaluating data quality, translating business rules into technical queries, and generating essential data readiness metrics. You will ensure the reliability of data from ERP systems to support business insights.

The ideal candidate should have strong expertise in Snowflake and advanced skills in SQL and/or Python. Knowledge of ERP systems like SAP is a plus. The role requires exceptional analytical reasoning to tackle complex data scenarios and deliver insightful analysis.

Qualifications

• Strong expertise in Snowflake for data storage and querying.
• Advanced proficiency in SQL and/or Python for data manipulation.
• Understanding of ERP systems like SAP or JDA.

Responsibilities

• Run comprehensive data quality assessments and generate metrics.
• Translate data governance rules into executable queries.
• Build complex queries for data quality criteria.
• Utilize Snowflake to track data quality scores and trends.
• Respond to ad-hoc analytical requests and analyze complex data.

Skills

Snowflake

SQL

Python

Data Quality Assessment

Data Architecture

Job description

We are seeking Sr. Data Quality Engineer to join our Data Readiness team. In this role, you will be responsible for evaluating data quality, translating business rules into technical queries, and generating critical data readiness metrics. You will play a crucial part in ensuring the reliability of data from various ERP systems to drive business insights.

Key Responsibilities

Data Quality Assessment: Run comprehensive data quality assessments and generate data quality metrics to track trends week-over-week.

Rule Translation: Translate data governance rules written in pure business language into executable queries, mapping them accurately to technical field names and tables in ERP systems.

Query Development: Build simple to highly complex executable queries (including nested statements and complex joins) to define pass/fail criteria for data quality rules on specific datasets.

Data Architecture & Tracking: Utilize Snowflake to store query results and maintain dedicated schemas to track data quality scores and performance trends over time.

Ad-Hoc Analysis: Respond to ad-hoc analytical requests and design sessions by logically investigating and troubleshooting complex data scenarios, which may involve deep-dive analysis lasting several hours.

Required Skills & Qualifications

Technical Stack: Strong expertise in Snowflake, along with advanced proficiency in SQL and/or Python for scripting and data manipulation.

ERP Systems Knowledge: Basic to advanced understanding of technical fields and table structures across ERP platforms such as SAP, JDA, or other non-SAP systems.

Analytical Mindset: Exceptional logical reasoning and investigative skills to tackle unstructured ad-hoc requests requiring deep analysis and complex joins.