Senior Backend Data Test Engineer: ETL & Data Quality

Beacon Hill Staffing Group, LLC; Columbia (SC); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Leave programs

Job summary

Beacon Hill Staffing Group, LLC is seeking a Senior Backend Data Test Engineer to validate large-scale CMS data systems and ensure data integrity across backend platforms and frontend UI applications.

The role requires strong SQL and data validation skills in PostgreSQL, Snowflake, and Databricks, plus agile collaboration with BAs, DBAs, and developers. Expect robust ETL testing and API validation in a fast-paced environment.

Qualifications

• Minimum of 5+ years of direct experience as a Backend/Data Tester.
• Strong expertise in backend database testing using PostgreSQL, Snowflake, and advanced SQL.
• Experience performing data validation within a big-data environment (Databricks, Snowflake, etc.).
• Proficiency with Jira, Confluence, and Slack.
• Solid experience working within Agile or SAFe methodologies.
• Hands-on experience writing user stories, defect tickets, and clear acceptance criteria.
• Ability to create detailed test cases based on user stories and functional requirements.
• Strong communication skills with the ability to collaborate effectively with Product Owners, DBAs, and Developers.
• Proven ability to work independently, take initiative, and manage tasks with minimal direction.

Responsibilities

• Perform comprehensive ETL and backend data validation across big-data technologies including Databricks, Snowflake, PostgreSQL, and related platforms.
• Analyze, interpret, and validate complex CMS datasets, including Shared Systems Claims, Final Action Indicator logic, Provider data, and Beneficiary data etc.
• Validate data sourced from CMS's Integrated Data Repository
• Conduct detailed data comparison and reconciliation between backend datasets (PostgreSQL/Snowflake) and corresponding Frontend/UI outputs and/or Databricks Unity Catalog results.
• Collaborate with Business Analysts, DBAs, Developers, DevOps engineers, and Scrum/Kanban teams to ensure system reliability, data accuracy, and optimal performance.
• Ensure adherence Testing Framework standards, organizational SDLC processes, quality procedures, and regulatory compliance requirements.
• Participate in functional UI validations as needed to support end-to-end data integrity across user-facing components.
• Independently develop, execute, and maintain detailed backend test plans, test cases, and validation scenarios with zero or minimal supervision.
• Design and execute API-based test scenarios to validate backend services and data flows.
• Actively participate in Agile ceremonies .

Skills

PostgreSQL

Snowflake

SQL

Databricks

ETL validation

Big-data

Jira

Confluence

Slack

Agile/SAFe

Test planning

API testing

Automation (Java/Selenium/Cucumber)

GitHub/Jenkins CI/CD

Tools

Tableau

Grafana

Burp Suite

TestRail

GitHub

Jenkins

Selenium

Cucumber

Job description

Beacon Hill Staffing Group, LLC is seeking a Senior Backend Data Test Engineer to validate large-scale CMS data systems and ensure data integrity across backend platforms and frontend UI applications.

The role requires strong SQL and data validation skills in PostgreSQL, Snowflake, and Databricks, plus agile collaboration with BAs, DBAs, and developers. Expect robust ETL testing and API validation in a fast-paced environment.