We're Hiring: Senior Data Quality Assurance Specialist

Location: Pune / Ahmedabad

Shift: 2:00 PM – 11:30 PM IST

Experience: 5+ Years

Employment: Full-Time

Position Overview:

● Validate data accuracy, completeness, and consistency within enterprise SQL databases, data warehouses, and reporting environments.

● Develop and execute test plans, test cases, and validation procedures for new and existing data integrations.

● Perform end-to-end testing of ETL and ELT processes utilizing SQL and Python-based data pipelines.

● Verify source-to-target data mappings and transformations across multiple systems and applications.

● Conduct reconciliation and data balancing activities between source systems, staging environments, data warehouses, and reporting platforms.

● Identify, document, and track data quality issues and defects through resolution.

● Perform functional, regression, and data validation testing for Power BI reports, dashboards, data models, and datasets.

● Validate report calculations, KPIs, measures, dimensions, filters, hierarchies, and business logic.

● Ensure reporting output aligns with established business requirements and source system data.

● Verify report performance, data refresh processes, and security configurations.

● Collaborate with BI developers to resolve report defects and data inconsistencies. Production Support & Root Cause Analysis

● Investigate and troubleshoot production issues related to reporting, analytics, ETL processing, and data quality.

● Perform root cause analysis of data discrepancies detected by end users, business stakeholders, or automated monitoring processes.

● Support incident management processes through issue documentation, impact analysis, and resolution validation.

● Validate corrective actions and ensure production fixes meet business and technical requirements. Data Investigation & Continuous Improvement

● Compare and validate data across transactional systems, operational databases, and analytical reporting solutions.

● Perform ad hoc data investigations to support business inquiries, audit requests, and operational reviews.

● Recommend improvements to data quality controls and monitoring procedures.





● Develop, maintain, and improve QA methodologies, testing standards, and validation frameworks.

● Assist in establishing data quality metrics and ongoing monitoring processes. The above is not an all-inclusive list of all duties performed by this job title, only a representative summary of the primary duties and responsibilities. Incumbent may be required to perform other additional duties as assigned.

Minimum Qualifications

● Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.

● 5+ years of experience in Data Quality Assurance, Business Intelligence, Data Warehousing, Data Analysis, or related discipline.

● 3+ years of experience testing and validating enterprise reporting solutions, preferably Power BI.

● Strong hands-on experience with Microsoft SQL Server, SQL querying, and data analysis techniques.

● Experience validating ETL/ELT processes and data integrations.

● Working knowledge of Python-based data processing and automation solutions.

● Experience analyzing large datasets and identifying data quality issues across multiple systems.

● Demonstrated experience supporting production environments and investigating reported defects.

● Experience working with third-party data sources and enterprise applications.

● Understanding of data governance, master data management, and data lineage concepts. Knowledge,

Skills & Abilities

● Advanced knowledge of SQL and relational database concepts.

● Strong understanding of data warehousing architectures and dimensional modeling.

● Knowledge of ETL/ELT processes, data transformations, and integration patterns.

● Working knowledge of Python scripting and data processing methodologies.

● Experience with Power BI datasets, semantic models, DAX calculations,



and report validation.

● Understanding of software testing methodologies, defect lifecycle management, and QA best practices.

● Solid data analysis and problem-solving skills.

● Excellent root cause analysis and troubleshooting capabilities.

● Ability to perform detailed data reconciliation across complex systems.

● Proficiency writing advanced SQL queries for validation and investigation purposes.

● Strong documentation and test case development skills.

● Ability to prioritize multiple projects and production support activities simultaneously.

● Effective verbal and written communication skills with both technical and non-technical audiences.

● Strong organizational skills and attention to detail.

● Ability to identify data anomalies, trends, and inconsistencies within large datasets.

● Ability to independently investigate production issues and drive issues to resolution.

● Ability to translate business requirements into comprehensive testing and validation procedures.

● Ability to work in a fast-paced environment while maintaining a high standard of quality and accuracy.

● Ability to proactively recommend process improvements that enhance data integrity and reporting reliability.

Physical Demands

This position occasionally requires the abilities of standing, walking, lifting or exerting forces up to 20 lbs., reaching or stretching, climbing or balancing, crouching or stooping, crawling, and depth perception.

This position frequently requires the abilities of sitting, fingering or manual dexterity, repetitive finger motion, speaking, hearing, and seeing colors.

Pay: ₹1,000,000.00 - ₹1,800,000.00 per year

Education

- Bachelor's (Required)

Experience:
- Data Quality Assurance: 5 years (Required)
- Data Warehousing: 5 years (Required)
- Testing and validating enterprise reporting solutions: 3 years (Required)
- Power BI: 5 years (Required)
- Microsoft SQL Server: 5 years (Required)
- ETL/ELT: 5 years (Required)
- Data integrations: 5 years (Required)
- Python: 5 years (Required)

Location:
- Pune, Maharashtra (Required)

Work Location: In person

📌 Senior Data Quality Assurance Specialist (Pune)
🏢 Sigma Solve
📍 Pune