Data Quality Engineer
Fully Remote (with 10% travel required)
Duration:
initial 12-month contract (W2, not eligible for C2C)
Pay:$45-50/hr
We are seeking a Data Quality Engineer to develop, implement, and maintain data quality processes and validation frameworks that ensure the accuracy, completeness, consistency, and reliability of enterprise data.
This role requires advanced SQL expertise to analyze complex datasets, build validation queries, identify discrepancies, and troubleshoot data quality issues across enterprise data platforms. The Data Quality Engineer will work closely with data engineers, data modelers, architects, and business stakeholders to establish data quality standards, validate data transformations, and support reporting, analytics, and data modernization initiatives.
Key Responsibilities
- Develop and optimize complex SQL queries for data profiling, validation, reconciliation, and quality assessments across enterprise databases and data warehouses.
- Design and maintain SQL-based data quality checks to identify missing, duplicate, inaccurate, inconsistent, or improperly formatted data.
- Validate data accuracy and completeness throughout ETL/ELT pipelines, ensuring data integrity across source systems, staging environments, and target platforms.
- Perform source-to-target data reconciliation to verify data transformations, business rules, and mapping requirements.
- Develop automated data quality tests to proactively identify and report data anomalies and integrity issues.
- Investigate data quality issues, conduct root cause analysis, and collaborate with engineering teams to implement corrective solutions.
- Support enterprise data platforms, including Snowflake, Azure SQL Managed Instance (SQL MI), Azure Data Factory (ADF), and Denodo.
- Analyze large datasets to identify data quality trends, inconsistencies, and opportunities for improvement.
- Partner with technical and business stakeholders to define data quality requirements, validation rules, and acceptance criteria.
- Maintain data quality documentation, test cases, validation scripts, and issue-tracking records.
- Establish and monitor data quality metrics related to accuracy, completeness, consistency, uniqueness, validity, and timeliness.
- Participate in data integration testing, system migrations, release validation, and enterprise data modernization initiatives.
- Support data governance and metadata management initiatives by identifying quality risks and recommending improvements to enterprise data standards.
Required Qualifications
- 5+ years of experience in data quality engineering, SQL development, data analysis, data engineering, or a related field.
- Advanced SQL development experience within enterprise database environments.
- Hands-on experience with data validation, reconciliation, profiling, and troubleshooting.
- Experience working with relational databases, data warehouses, and ETL/ELT processes.
- Demonstrated ability to identify and resolve complex data quality issues across multiple systems.
- Strong analytical, problem-solving, and technical documentation skills.
- Ability to collaborate with technical and business stakeholders and translate requirements into executable data validation rules.
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field preferred. Equivalent professional experience may be considered.
Preferred Technical Experience
- Snowflake
- Azure SQL Managed Instance (SQL MI)
- Azure Data Factory (ADF)
- Denodo
- Enterprise data warehouses
- ETL/ELT pipelines
- Data governance and metadata management
...