Quality Assurance/Quality Control Specialist – Data Analytics & Business Intelligence

ITnova; Jersey City (NJ); Remote; USD 70,000 - 90,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Disability & Life Insurance

401(k) Program

Paid Time Off

11 Holidays

Employee Assistance Program

Job summary

ITnova seeks a QA/QC Specialist - Data Analytics & Business Intelligence to support the ADAW for the PANYNJ Aviation Department. The role emphasizes data quality assurance, testing of data pipelines and Power BI dashboards, and coordination with the data engineering team to resolve issues before releases.

Responsibilities include UAT support, test case development, and maintaining QA documentation while ensuring data accuracy and consistency across analytics assets.

Qualifications

• BS in IT/CS/Data Analytics or related field.
• Experience in QA, software testing, data quality management.
• Experience writing and executing test cases and documenting results.
• Ability to validate data accuracy and integrity in dashboards.
• Experience with SQL Server for data validation.

Responsibilities

• Validate data loaded into the ADAW against source systems.
• Develop, maintain, and execute automated data quality checks and validation processes.
• Monitor data quality dashboards and automated alerts to identify anomalies.
• Investigate data quality issues and coordinate resolution with the data engineering team.
• Validate dashboards and reports to ensure alignment with business requirements.
• Develop and execute test cases and validation procedures for data pipelines and reporting.
• Support UAT by preparing test scenarios and documenting results.
• Verify issues are resolved before release to business users and SMEs.
• Maintain test docs, defect logs, and QA records.
• Collaborate with Data Engineer, Cloud Architecture/Team Lead, and Program Manager for reliable releases.

Skills

Quality assurance

Data validation

SQL

Microsoft SQL Server

Power BI

UAT

Data quality checks

Education

Bachelor's degree in IT/CS/Data Analytics

Tools

SQL Server

Azure data services

Power BI

Job description

ITnova is seeking a QA/QC Specialist - Data Analytics & Business Intelligence to support the Port Authority of New York and New Jersey (PANYNJ) Aviation Department’s Aviation Data Analytics Warehouse (ADAW). The ideal candidate will have experience in data quality assurance, database testing, data validation, and quality control processes. This role will verify data accuracy and consistency, test data pipelines and Power BI dashboards, identify and document discrepancies, support user acceptance testing (UAT), and coordinate with the data engineering team to resolve issues before solutions are released. Experience with SQL, Microsoft SQL Server, Azure data services, and Power BI reporting is highly desirable.

ITnova is seeking a QA/QC Specialist - Data Analytics & Business Intelligence to support the Port Authority of New York and New Jersey (PANYNJ) Aviation Department’s Aviation Data Analytics Warehouse (ADAW). The ideal candidate will have experience in data quality assurance, database testing, data validation, and quality control processes. This role will verify data accuracy and consistency, test data pipelines and Power BI dashboards, identify and document discrepancies, support user acceptance testing (UAT), and coordinate with the data engineering team to resolve issues before solutions are released. Experience with SQL, Microsoft SQL Server, Azure data services, and Power BI reporting is highly desirable.

Responsibilities

• Validate data loaded into the Aviation Data Analytics Warehouse (ADAW) against source systems.
• Develop, maintain, and execute automated data quality checks and validation processes.
• Monitor data quality dashboards and automated alerts to identify anomalies, inconsistencies, and missing data.
• Investigate data quality issues, identify potential root causes, and coordinate resolution with the data engineering team.
• Validate dashboards and reports to confirm that calculations, data fields, and outputs align with business requirements.
• Develop and execute test cases, test scenarios, and validation procedures for data pipelines and reporting solutions.
• Support user acceptance testing (UAT) by preparing test scenarios, documenting results, and tracking defects.
• Verify that identified issues are resolved before solutions are released to business users and subject matter experts.
• Maintain test documentation, defect logs, data validation results, and quality assurance records.
• Collaborate with the Data Engineer, Cloud Architecture/Team Lead, and Program Manager to support reliable platform releases and continuous improvement.

Required Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, or a related field preferred.
• Demonstrated experience in quality assurance, software testing, data validation, or data quality management.
• Experience developing and executing test cases and documenting test results.
• Experience validating data accuracy, completeness, consistency, and integrity.
• Experience with relational databases and Microsoft SQL Server.
• Working knowledge of SQL for data validation, reconciliation, and investigation of discrepancies.
• Experience identifying, documenting, tracking, and verifying the resolution of defects.
• Experience supporting user acceptance testing (UAT) and coordinating with technical teams.
• Strong analytical, problem-solving, documentation, and communication skills.
• Ability to verify that dashboards, reports, and data outputs meet documented business requirements.

Preferred Experience

• Experience testing cloud-based data warehouses or enterprise data integration platforms.
• Experience with Microsoft Azure Synapse Analytics, Azure Data Factory, Azure SQL, and Databricks.
• Experience validating Power BI dashboards, reports, calculations, and semantic data models.
• Experience developing automated data quality checks, monitoring processes, and exception alerts.
• Experience with Azure DevOps or similar tools for test management, defect tracking, and issue resolution.
• Experience working in an Agile development environment.
• Experience supporting data analytics or business intelligence programs in a complex enterprise environment.

Must be US Citizen

Full-time remote ( Mon – Fri, 9:00 am – 5:00 pm EST)

Benefits

• Medical, Dental, and Vision coverage
• Short Term Disability, AD&D and Life insurance
• 401(k) Program
• Paid Time Off
• 11 Paid Holidays
• Employee Assistance Program

ITnova is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.