QA/QC Specialist, Data Analytics / BI

Position Title: QA/QC Specialist – Data Analytics & Business Intelligence Location: Remote (Working hours should be 9am-5pm EST) Clearance Requirements: Not specified Position Status: Contract – 4 years, with potential extension Pay Rate: $50/hr on W2 Position Description We are seeking an experienced QA/QC Specialist with expertise in Data Analytics, Business Intelligence (BI), and Data Quality Assurance to support enterprise data and reporting initiatives within a municipal transportation environment. In this role, you will ensure the accuracy, completeness, consistency, and reliability of enterprise data, ETL/ELT pipelines, data transformations, analytical models, BI reports, and dashboards. You will collaborate with data engineers, BI developers, data analysts, data architects, and business stakeholders to validate data processes, identify discrepancies, resolve defects, and strengthen confidence in data-driven decision-making. This long-term contract opportunity is ideal for a detail-oriented professional with strong SQL skills, hands-on data testing experience, and a passion for improving data quality and analytical reliability. Key Responsibilities Quality Assurance and Test Planning Develop and execute QA/QC strategies, test plans, test cases, test scripts, and data validation procedures. Translate business requirements and technical specifications into measurable testing criteria. Maintain comprehensive testing documentation and quality standards. Data Pipeline and BI Testing Validate ETL/ELT pipelines, data integrations, transformations, data warehouse structures, and analytical models. Use SQL to verify data accuracy, reconcile results, investigate discrepancies, and validate reporting outputs. Test Power BI, Tableau, or similar BI reports, dashboards, KPIs, and analytical datasets. Perform regression testing and support user acceptance testing (UAT). Defect Management and Data Quality Improvement Identify data anomalies, investigate root causes, document defects, and coordinate corrective actions. Collaborate with data engineering, analytics, BI, architecture, and business teams to resolve data quality issues. Establish repeatable quality controls to improve data reliability, consistency, and reporting accuracy. Required Skills/Education Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent professional experience. 5+ years of experience in quality assurance, software testing, data validation, data warehousing, BI testing, or related disciplines. Demonstrated experience testing data-intensive applications, ETL/ELT pipelines, data integration processes, or enterprise reporting solutions. Strong SQL proficiency for data validation, reconciliation, troubleshooting, and independent verification of analytical results. Hands-on experience creating test plans, test cases, test scripts, and QA/QC documentation. Knowledge of data warehousing, relational databases, data modeling, dimensional modeling, and data transformation processes. Experience testing BI reports, dashboards, KPIs, and analytical datasets. Familiarity with Microsoft Power BI, Tableau, or comparable reporting platforms. Understanding of data quality dimensions, including accuracy, completeness, consistency, validity, uniqueness, and timeliness. Experience with defect tracking, root-cause analysis, regression testing, and user acceptance testing. Strong analytical, problem-solving, documentation, and communication skills. Ability to collaborate effectively with technical teams and business stakeholders. Preferred Qualifications Experience with cloud data platforms such as Microsoft Azure, AWS, or Google Cloud Platform (GCP). Familiarity with Microsoft Fabric, Azure Data Factory, Azure Databricks, Snowflake, Amazon Redshift, or Google BigQuery. Experience with Python-based test automation, automated data validation, or reconciliation frameworks. Knowledge of Power BI DAX measures, semantic models, data relationships, row-level security, and refresh validation. Familiarity with data quality tools such as Great Expectations, dbt tests, or Soda. Experience with Jira, Azure DevOps, test management tools, and defect tracking systems. Understanding of CI/CD pipelines, automated regression testing, and quality gates for data deployments. Knowledge of data governance, metadata management, data lineage, and master data management. Experience working in Agile/Scrum environments and following software development lifecycle (SDLC) practices. Relevant certifications in software testing, data analytics, cloud technologies, or BI platforms. About Seneca Resources At Seneca Resources, we are more than just a staffing and consulting firm, we are a trusted career partner. With offices across the U.S. and clients ranging from Fortune 500 companies to government organizations, we provide opportunities that help professionals grow their careers while making an impact. When you work with Seneca, you’re choosing a company that invests in your success, celebrates your achievements, and connects you to meaningful work with leading organizations nationwide. We take the time to understand your goals and match you with roles that align with your skills and career path. Our consultants and contractors enjoy competitive pay, comprehensive health, dental, and vision coverage, 401(k) retirement plans, and the support of a dedicated team who will advocate for you every step of the way. Seneca Resources is proud to be an Equal Opportunity Employer, committed to fostering a diverse and inclusive workplace where all qualified individuals are encouraged to apply.