Data Quality Analyst

Financial Data QA Engineer/AnalystThe American College of Radiology (ACR) is a progressive membership organization representing nearly 40,000 medical specialists in radiological care. As a member of our team, you will join a world leader in patient-centered care advocacy, policy and clinical research, quality and safety. Our culture encourages innovation, diversity, integrity and leadership. A nonprofit 501(c)(3), ACR (the American College of Radiology) has over 500 purpose-driven employees in the Greater Washington, DC and Philadelphia region. If you share our core values of: Leadership • Integrity • Quality • Innovation, we want you on our team! We are seeking a highly skilled and motivated Data QA to join our team. This role is focused on strategic ERP implementation, data migration validation, and data integration validation. You will work closely with finance and accounting teams and other stakeholders to ensure accurate data movement and integrity across systems. Experience with ERP platforms such as NetSuite and data migration/integration projects is highly desirable. This candidate will possess a meticulous eye for detail, strong analytical thinking, and a passion for data quality. In this role, you will play a critical part in ensuring the accuracy, reliability, and performance of our data pipelines and software solutions. You will collaborate closely with cross-functional teams to validate data flows, automate testing processes, and uphold the highest standards of data integrity.Key ResponsibilitiesCollaborate with Application, Data Development, Business Analysts, and Operations teams to design and implement comprehensive testing strategies.Review business requirements, functional specifications, and design documents to create detailed test plans.Test fidelity of data migration from one system to another using SQL and related tools.Design, develop, and maintain automated test cases for ETL pipelines using tools such as Validatar, QuerySurge, or ICEDQ. This role will be working in a similar tool for data comparison.Automate data testing processes wherever feasible, including large datasets within SQL Server databases or similar.Perform end-to-end ETL validation and testing in AWS data pipelines (Glue, Athena, S3, Redshift, RDS).Develop and execute tests using Python or PySpark to validate large-scale data processing jobs.Conduct API testing for data services and backend systems.Validate source-to-destination data movement and transformation in database applications.Perform backend database testing aligned with application flow functionality.Assess and produce Key Performance Indicators (KPIs).Participate in design and SQL code reviews to ensure testability and adherence to quality standards.Plan and execute Manual, Functional, and Regression test suites.Assist in QA discovery or analysis to identify gaps and facilitate requirements refinement.Qualifications2 to 4 years of experience working with Finance and Accounting business partners or similar environments is highly preferred but not required.Bachelor's degree in Health Informatics, Computer Science, or a related field.3–5 years of experience in Test Strategy, Test Design, Execution, and Reporting.2+ writing Python and/or PySpark in a Production environment.4+ years of expert-level experience in testing and automating large datasets within SQL Server databases or similar.Strong proficiency in writing complex SQL queries, stored procedures, functions, views, grouping operations, and indexes.Strong understanding of ETL concepts and AWS data flow diagrams.Experience in testing database applications for data movement and transformation.Experience with AWS Glue, Athena, S3, Redshift, and RDS.Proficiency in Python, API testing, and test automation frameworks.Strong communication skills and experience working in Agile environments.Keywords ERP, NetSuite, Data QA, Data Quality, SQL, ETL Testing, Python, AWS Glue, Athena, S3, Redshift, API Testing, Automation, Agile, Validatar, QuerySurge, ICEDQ