Data Tester

Civica; United States; Híbrido; USD 70.000 - 90.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible work options

Descripción de la vacante

Civica in the United States is seeking a Data Tester to safeguard financial data accuracy during migration projects. You will design test cases, validate reconciliations, and apply SQL expertise to verify data across legacy and target systems.

You\'ll work with Data Engineers, Analysts, and UK stakeholders in a structured, collaborative environment, handling defect tracking, root-cause analysis, and go-live readiness to ensure smooth transitions.

Formación

• Design, build and execute tests for data migrations and ERP finance transformations.
• Perform reconciliation checks between source and target systems.
• Write SQL queries to verify data integrity across environments.

Responsabilidades

• Design test plans, scripts, and cases for migration cycles (mock runs, SIT, UAT, cutover).
• Validate data mappings and reconciliations across systems.
• Log and track defects; support root cause analysis with ETL teams.
• Ensure regression tests cover changes and verify post-migration readiness.

Conocimientos

SQL queries

Data testing

Test planning

Excel advanced

Communication

Educación

Bachelor's degree in Finance/CS

Herramientas

JIRA

Azure DevOps

HP ALM

TestRail

Descripción del empleo

We’re Civica and we make software that helps deliver critical services for citizens all around the world. From local to state government, to education, to health and care, over 5,000 public bodies across the globe use our software to help provide critical services to over 100 million citizens.

Our aspiration is to be a GovTech champion everywhere we work around the globe, supporting the needs of citizens and those that serve them every day. Building on 21 years of continuous growth and success, we're at a pivotal point on our journey to realise that aspiration.

As a company, we’re passionate about what we do and the citizens we help to serve. If you too would like to help champion the use of technology in public services, to improve outcomes for citizens and public sector organisations, then Civica is the right place for you. We will help you unlock the best version of yourself, achieve growth in your career whilst making a real difference to people and communities.

Why you'll love this role as Data Tester at Civica

As a Data Tester at Civica, you’ll play a pivotal role in ensuring the success of multiple data migration projects by safeguarding the accuracy and integrity of financial data. You’ll design and execute test cases, validate reconciliations, and apply SQL expertise to verify data across legacy and target systems. Working hand‑in‑hand with Data Engineers, Analysts, and UK stakeholders, you’ll be at the heart of complex migrations — identifying and resolving defects, supporting root cause analysis, and ensuring readiness for go‑live. This is your chance to make a tangible impact on mission‑critical systems, grow your expertise in ETL and financial data validation, and thrive in a collaborative, structured environment where your work directly contributes to smoother transitions and trusted outcomes.

Requirements

You will be handling the following responsibilities

• Test planning: Design, build, and maintain test plans, scripts, and cases across migration cycles (mock runs, SIT, UAT, cutover).
• Data validation: Perform reconciliation checks between source and target systems using mapping specifications.
• SQL testing: Write queries to compare record counts, field values, and financial totals across systems.
• Defect management: Log, track, and resolve data defects using tools like Azure DevOps.
• Root cause analysis: Collaborate with engineers and ETL teams to investigate and resolve issues.
• Regression testing: Confirm fixes and ensure no new issues are introduced.
• Financial integrity: Check for duplicates, missing values, incorrect mappings, and broken relationships.
• Documentation: Maintain clear records of test evidence, sign‑offs, and defect logs.
• Reporting: Highlight risks, blockers, and readiness for go/no‑go decisions.
• Cutover support: Participate in go‑live activities and post‑migration checks.
• Stakeholder alignment: Work with UK‑based stakeholders to align priorities and timelines.

Apply if you have

• SQL expertise: Ability to write queries for data extraction, joins, filtering, and aggregation.
• Data testing techniques: Experience with reconciliation, sampling, field‑level comparisons, and count checks.
• Tool proficiency: Familiarity with test management and defect tracking tools (e.g., JIRA, Azure DevOps, HP ALM, TestRail).
• Advanced Excel: Skilled in XLOOKUP, pivot tables, and formulas for reconciliation and reporting.
• ETL exposure: Understanding of ETL processes and data migration methodology is a strong plus.
• Finance knowledge: Basic to intermediate grasp of GL, Chart of Accounts, Trial Balance, AP/AR, and Fixed Assets.
• ERP familiarity: Prior exposure to SAP, Oracle Financials, Workday Financials, or similar systems.
• Project experience: Background in testing data for finance transformations, ERP implementations, or migration projects.
• Attention to detail: Methodical approach with strong analytical and problem‑solving skills.
• Communication skills: Clear written and verbal communication for defect reporting and stakeholder updates.
• Collaboration: Comfortable working with UK‑based stakeholders across time zones.
• Resilience: Ability to manage competing priorities during test cycles and cutover periods.
• Qualifications: Bachelor’s degree in Finance, Accounting, Computer Science, or related field; 1–4 years of experience in data testing/QA; offshore/onshore delivery model exposure preferred.

Why you'll love working with us

We know that when our people are happy, they will work better and have greater work satisfaction. Here's what you can expect:

We're all different -and we love this about us.

We provide an inclusive,safe, and welcoming environment to all Civica ns, new and old Focus on learning- there are heaps of opportunities to enable you to grow and be your best.

Giving culture -we encourage you to "give back" with benefits such as our Days of Difference leave where you can volunteer for a charity of your choice.

Flexible Work - we have comprehensive flexibility options including part‑time work, adjusted hours, and staggered shifts, and hybrid or remote working, supporting work–life balance based on individual needs.