Financial Data QA

TechDigital Group

Reston (VA)

On-site

USD 80,000 - 100,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading technology firm in Reston, Virginia is seeking a Financial Data QA Engineer/Analyst to ensure data quality in ERP implementations and data migrations. Ideal candidates should possess strong SQL and Python skills, along with experience in testing data flows and automating processes. This role involves collaborating with finance teams and requires a meticulous eye for detail. Join a culture that encourages innovation and quality, and contribute to critical data integrity initiatives.

Qualifications

2 to 4 years of experience in Finance and Accounting or similar environments preferred.
Strong proficiency in writing complex SQL queries and stored procedures.
Experience with AWS Glue, Athena, S3, Redshift, and RDS.

Responsibilities

Collaborate with teams to design and implement testing strategies.
Test fidelity of data migration using SQL.
Develop and maintain automated test cases for ETL pipelines.

Skills

SQL

Data QA

Python

ETL Testing

API Testing

Automated Testing

Agile

Education

Bachelor's degree in Health Informatics, Computer Science, or related field

Tools

AWS Glue

Validatar

QuerySurge

ICEDQ

Job description

Financial Data QA Engineer/Analyst

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.

Core Values:

Leadership
Integrity
Quality
Innovation

If you share our core values of leadership, integrity, quality, and 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 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 Responsibilities

Collaborate 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.
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.

Qualifications

2 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.