Overview

Location: Fully remote within India

Responsibilities

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

Qualifications

• Typically 6+ years in data quality engineering, ETL testing, or data engineering, with recent emphasis on automation.
• Strong SQL reconciliation and Python test automation skills.
• Power BI report testing experience, including filters, slicers, totals, and drill-through behavior.
• Clear written and spoken English and the ability to explain findings to engineers and business users.
• 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.
• Pharmaceutical, healthcare, or distribution data.
• 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.
• 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.