What are the responsibilities and job description for the Quality Assurance/Quality Control Specialist - Data Analytics & Business Intelligence position at ITnova?
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.