Lead Data Quality Engineer

GSMS, Incorporated; India; On-site; INR 2,200,000 - 3,200,000; Full time

Benefits offered by this job

Private medical insurance

Life insurance

Paid leave & holidays

Remote-work support

Job summary

GSMS, Incorporated seeks a senior Data Quality Engineer to lead QA for ETL pipelines, data warehouses, and Power BI reports. This hands-on leadership role oversees a Data Quality Engineer and collaborates across teams to ensure data integrity in GSMS's analytics stack, with an emphasis on automation and CI/CD practices.

You will define testing standards, build automated checks with SQL and Python, validate migrations, and support UAT with the Product Owner.

Qualifications

• 6+ years of experience in data quality engineering, ETL testing, or data engineering.
• Experience establishing an automated data testing framework.
• Strong SQL reconciliation and Python test automation skills.
• Experience validating data warehouse or platform migrations.
• Experience testing cloud data pipelines and warehouse transformations.
• Power BI report testing experience, including filters and drill-through behavior.
• Excellent written and spoken English to explain findings.

Responsibilities

• Define testing standards and priorities across ingestion, transformations, warehouse models and reports.
• Build maintainable automated checks using SQL, Python, and testing tools.
• Design migration reconciliation for completeness, accuracy and business-rule consistency.
• Test ETL behavior including incremental processing, duplicates, missing data, and recovery.
• Validate Power BI measures and report outputs against SQL results and business rules.
• Integrate checks into pipelines and CI/CD, and establish ongoing quality monitoring.
• Lead defect triage and communicate coverage, unresolved issues, and release-readiness.
• Support Product Owner-led UAT through preparation, investigation and retesting.
• Manage and mentor the Data Quality Engineer and collaborate with other teams.
• Use AI-assisted testing with independent validation of outputs.

Skills

Data quality engineering

ETL testing

Data engineering

SQL reconciliation

Python test automation

Power BI testing

Test planning

Defect triage

English communication

Tools

pytest

Great Expectations

Soda

Job description

Employment

Full-time, dedicated to GSMS through an Employer of Record in India

Reports to

Lead Data Engineer

Direct report

Data Quality Engineer

Working hours

2:00–10:00 PM IST, fixed year-round

About GSMS

GSMS is the largest provider of generic pharmaceuticals to the US federal healthcare system, serving the Department of Veterans Affairs, Department of Defense, and other government healthcare organizations.

Data is central to how we compete—and win. Our data and analytics capabilities are a defining competitive advantage. The intelligence we develop about the government pharmaceutical market helps GSMS identify opportunities, shape our product portfolio, make competitive pricing decisions, and grow market share. Across sales, manufacturing, distribution, and daily operations, colleagues depend on our insights to decide where to act and how to succeed.

We’re embarking on a company-wide AI transformation. Our 24-month implementation roadmap will bring AI and advanced analytics into how teams make decisions and get work done across GSMS. Modernizing our platform on Microsoft Fabric provides a foundation for self-service analytics, data and operational agents, and workflow automation. Within engineering, we’re integrating AI and large language models into a governed process for building, reviewing, and validating solutions.

You’ll join a dedicated GSMS team, work directly with business users, and take lasting ownership of solutions that shape how the company competes.

The opportunity

You’ll establish and lead quality engineering across ETL pipelines, warehouse data, and Power BI reports.

This is a hands-on leadership role spanning current production operations and our Fabric migration. You’ll build automation, define testing standards, and provide clear evidence of data quality and release readiness.

You’ll manage the incoming Data Quality Engineer and collaborate with existing quality colleagues. The Product Owner will coordinate user acceptance testing, supported by your team’s validation and defect investigation.

What you’ll do

• Define testing standards and priorities across ingestion, transformations, warehouse models, and reports.
• Build maintainable automated checks using SQL, Python, and appropriate testing tools.
• Design migration reconciliation that checks completeness, accuracy, and business-rule consistency.
• Test ETL behavior, including incremental processing, duplicates, missing data, and recovery.
• Validate Power BI measures and report outputs against independently calculated SQL results, matching business rules and filter conditions.
• Integrate checks into pipelines and CI/CD, and establish ongoing quality monitoring.
• Lead defect triage and communicate coverage, unresolved issues, and release-readiness recommendations.
• Support Product Owner-led UAT through preparation, investigation, and retesting.
• Manage and mentor the Data Quality Engineer and collaborate with other quality colleagues.
• Use AI-assisted testing with independent validation of outputs.

What you’ll bring

• Typically 6+ years in data quality engineering, ETL testing, or data engineering, with recent emphasis on automation.
• Experience establishing an automated data testing framework or approach.
• Strong SQL reconciliation and Python test automation skills.
• Experience validating data warehouse or platform migrations.
• Experience testing cloud data pipelines and warehouse transformations.
• Power BI report testing experience, including filters, slicers, totals, and drill-through behavior.
• Experience leading test planning, defect triage, and technical quality work.
• Clear written and spoken English and the ability to explain findings to engineers and business users.

Helpful additional experience

• Microsoft Fabric or PySpark.
• SQL Server and Azure Data Factory.
• Testing tools such as pytest, Great Expectations, or Soda.
• DAX familiarity for investigating report discrepancies; complex DAX development is not required.

Compensation and benefits

• Annual fixed gross salary of ₹22,00,000–₹32,00,000, based on relevant skills and experience.
• Additional incentive compensation based on individual and company performance.
• Comprehensive medical insurance with family coverage options.
• Life insurance.
• Paid leave and holidays.
• Remote-work support.

Working arrangement

• This is a dedicated, full-time position, with employment administered through an Employer of Record (EOR) in India.
• Your day-to-day work, team relationships, and priorities will be with GSMS.
• Working hours are 2:00–10:00 PM IST, fixed year-round, providing overlap with US colleagues. Production support takes place within these hours.
• You must be available during scheduled working hours and may not hold another full-time job concurrently. Any outside work must comply with the applicable employment agreement and conflict-of-interest policy.