Data Quality Analyst

Jersey, NJ - USA

Monthly Salary: USD 101 - 101

Experience Required: 10years

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

We are seeking a Data Quality Analyst to join our Insurance business unit in this role you will be responsible for ensuring the accuracy consistency and reliability of data across our platforms. You will design and execute test plans for ETL processes validate data transformations using SQL and perform reconciliation across source systems data warehouses and data lakes. Working closely with data engineering and BI teams you will play a key role in identifying issues improving data pipelines and driving high-quality data delivery.

This is an excellent opportunity for a detail-oriented professional with strong SQL and ETL testing experience to contribute to clients mission of leveraging data and AI to transform businesses. The role offers exposure to modern data platforms QA frameworks and cloud technologies alongside the opportunity to develop your skills in a global collaborative and innovative environment.

As part of your duties you will be responsible for:

Understand business requirements and data flows to create comprehensive test plans and test cases for ETL jobs.
Perform data validation and reconciliation between source systems staging and target data stores (DWH data lakes etc.).
Develop and execute automated and manual tests to ensure data accuracy and quality.
Work with SQL queries to validate data transformations and detect anomalies.
Identify document and track defects and inconsistencies in data processing.
Collaborate with data engineering and BI teams to improve ETL processes and data pipelines.
Maintain QA documentation and contribute to continuous process improvements.

Requirements

Qualifications and experience we consider to be essential for the role:

Strong SQL skills ability to write complex queries for data validation and transformation testing.
Hands-on experience in ETL testing validating data pipelines transformations and data loads.
Knowledge of data warehousing concepts dimensions facts slowly changing dimensions (SCD) etc.
Experience in test case design execution and defect tracking.
Experience with QA tools like JIRA TestRail or equivalent.
Ability to work independently and collaboratively in an Agile/Scrum environment.

Skills and Personal attributes we would like to have:

Experience with ETL tools like Informatica Talend DataStage or AWS/GCP native ETL services (e.g. Dataflow Glue).
Knowledge of automation frameworks using Python/Selenium/pytest or similar tools for data testing.
Familiarity with cloud data platforms Snowflake BigQuery Redshift etc.
Basic understanding of CI/CD pipelines and QA integration.
Exposure to data quality tools such as Great Expectations Deequ or DQ frameworks.
Understanding of reporting/BI tools such as Power BI Tableau or Looker
Bachelors or Masters degree in Computer Science Information Technology or related field.

As part of your duties you will be responsible for:

Understand business requirements and data flows to create comprehensive test plans and test cases for ETL jobs.
Perform data validation and reconciliation between source systems staging and target data stores (DWH data lakes etc.).
Develop and execute automated and manual tests to ensure data accuracy and quality.
Work with SQL queries to validate data transformations and detect anomalies.
Identify document and track defects and inconsistencies in data processing.
Collaborate with data engineering and BI teams to improve ETL processes and data pipelines.
Maintain QA documentation and contribute to continuous process improvements.

Requirements

Qualifications and experience we consider to be essential for the role:

Strong SQL skills ability to write complex queries for data validation and transformation testing.
Hands-on experience in ETL testing validating data pipelines transformations and data loads.
Knowledge of data warehousing concepts dimensions facts slowly changing dimensions (SCD) etc.
Experience in test case design execution and defect tracking.
Experience with QA tools like JIRA TestRail or equivalent.
Ability to work independently and collaboratively in an Agile/Scrum environment.

Skills and Personal attributes we would like to have:

Experience with ETL tools like Informatica Talend DataStage or AWS/GCP native ETL services (e.g. Dataflow Glue).
Knowledge of automation frameworks using Python/Selenium/pytest or similar tools for data testing.
Familiarity with cloud data platforms Snowflake BigQuery Redshift etc.
Basic understanding of CI/CD pipelines and QA integration.
Exposure to data quality tools such as Great Expectations Deequ or DQ frameworks.
Understanding of reporting/BI tools such as Power BI Tableau or Looker
Bachelors or Masters degree in Computer Science Information Technology or related field.