Data QA Engineer – Enterprise Data

Posted Yesterday
Hiring Remotely in Latham, NY, USA
In-Office or Remote
Mid level
Information Technology • Software
The Role
Validate ETL/ELT pipelines and data migrations, test database objects, write complex SQL for verification, automate database regression tests, assess query performance, and validate BI reports in Tableau/Power BI while tracking defects in JIRA/TestRail.
Summary Generated by Built In
About Truelogic

At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.

Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference.

By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future.

Our Client

A leading technology organization focused on building robust, scalable data ecosystems and advanced analytics platforms.


Job Summary

We are seeking a meticulous Data QA Engineer to safeguard the integrity, accuracy, and reliability of complex enterprise data ecosystems. In this role, you will tackle the critical challenge of validating intricate ETL pipelines, ensuring seamless data migrations, and verifying that transformed data accurately reflects true business logic before it reaches critical analytical layers and decision-makers. The ideal candidate is a highly analytical problem-solver who combines a deep understanding of database architecture with hands-on experience in test automation, query optimization, and end-to-end data quality assurance.

Responsibilities
  • Ensure data accuracy, consistency, and completeness across pipelines by thoroughly validating ETL processes, referential integrity, constraints, and data normalization.

  • Perform comprehensive functional testing on core database objects, including stored procedures, triggers, views, and functions.

  • Validate data migrations and write complex SQL queries to verify data correctness and system integrity.

  • Test data pipelines, transformations, and business logic within business intelligence reporting tools like Tableau and Power BI to guarantee accurate report generation.

  • Build and maintain automated test scripts to execute seamless database regression and integration testing.

  • Identify slow-running queries, monitor execution plans, evaluate database indexing, and collaborate closely with DBAs to fine-tune overall system performance.

  • Partner with developers, data analysts, and product teams to track defects utilizing JIRA or TestRail and drive data quality best practices across the engineering organization.

Qualifications and Job Requirements
  • Advanced ability to write and execute complex SQL queries for deep data verification, reconciliation, and troubleshooting.

  • Proven track record of validating ETL and ELT data pipelines, transformation logic, and complex data warehousing environments.

  • Hands-on experience testing database objects and structures, with a solid understanding of data normalization and schema validation.

  • Practical experience documenting full-lifecycle test plans, cases, results, and defects in tools like JIRA or TestRail.

  • Hands-on experience with test automation tools and programming languages such as Python, Selenium (with SQL assertions), or custom database scripting is highly preferred.

  • Familiarity with non-functional testing using tools like Apache JMeter for database load, stress, and performance testing is a plus.

  • Experience testing presentation layers, reports, and business logic in BI platforms such as Tableau or Power BI is strongly desired.

  • Understanding of query execution plans, indexing strategies, and database performance tuning is a plus.

What We Offer
  • 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.

  • Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.

  • Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.

  • Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.

  • Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.

Why You’ll Like Working Here
  • A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally.

  • Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America.

  • Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field.

Apply now!

Skills Required

  • Advanced ability to write and execute complex SQL queries for data verification and reconciliation.
  • Proven track record validating ETL and ELT data pipelines, transformation logic, and data warehousing environments.
  • Hands-on experience testing database objects and structures (stored procedures, triggers, views, functions) and schema validation.
  • Experience documenting full-lifecycle test plans, test cases, results, and defects using tools like JIRA or TestRail.
  • Hands-on experience with test automation tools and programming languages such as Python or Selenium or custom database scripting.
  • Familiarity with non-functional testing tools like Apache JMeter for database load, stress, and performance testing.
  • Experience testing BI presentation layers, reports, and business logic in Tableau or Power BI.
  • Understanding of query execution plans, indexing strategies, and database performance tuning.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
266 Employees
Year Founded: 2003

What We Do

Truelogic Software is a Nearshore tech firm specializing in Staff Augmentation Services and Innovation Projects. We build innovative digital products by extending the engineering teams of US companies with our elite group of 500 Latin American highly experienced tech talent. Our SERVICES Staff Augmentation Services Dedicated Agile Teams Innovation Projects Our EXPERTISE Mobile & Web Development Data Engineering DevOps QA Automation & Testing UX/UI Designing Project Management Email us [email protected]

Similar Jobs

ServiceNow Logo ServiceNow

Dir, Solution Consulting

Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Remote or Hybrid
New York, NY, USA
29000 Employees
194K-320K Annually

GameChanger Logo GameChanger

Director, Information Security & Technology

Computer Vision • Digital Media • Kids + Family • Mobile • Software • Sports
Remote
United States
260 Employees
220K-240K Annually

GameChanger Logo GameChanger

Senior Product Marketing Manager

Computer Vision • Digital Media • Kids + Family • Mobile • Software • Sports
Remote
United States
260 Employees
140K-160K Annually

Samsara Logo Samsara

Senior Product Manager

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
131K-220K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account