Data Analyst - ETL Testing

Talentgigs; Hyderabad; On-site; INR 600,000 - 1,000,000; Full time

Job summary

A leading data analytics firm is looking for a Senior Data QA Engineer in Hyderabad to ensure end-to-end data accuracy and reliability across analytics. The successful candidate will collaborate with SQL and Power BI teams to validate data pipelines and business intelligence outputs. Requires 5+ years of Data QA experience and strong skills in Microsoft SQL Server and T-SQL. This hybrid role offers the chance to work closely with US stakeholders in an Agile environment.

Qualifications

• 5+ years of experience in Data QA / Analytics QA roles.
• Strong hands-on experience with Microsoft SQL Server and T-SQL for data validation.
• Experience testing Power BI datasets, reports, and dashboards.

Responsibilities

• Validate data accuracy, completeness, and consistency across SQL Server analytics.
• Test Power BI datasets and validate KPIs and DAX measures.
• Create and maintain data test cases and validation scripts.

Skills

Data QA & Analytics QA

Microsoft SQL Server

T-SQL

Power BI

Data reconciliation

Analytical thinking

Tools

Test management tools

Job description

Location: Offshore (working with US stakeholders)

Hours: 3 PM IST to 11:30 PM IST

Mode: Hybrid – 3 days onsite in Hyderabad

Role Summary

The Senior Data QA Engineer is responsible for ensuring end-to-end data accuracy, consistency, and reliability across the analytics ecosystem. This role works closely with Microsoft SQL Server (T-SQL) Engineers and Power BI Developers to validate data pipelines, transformations, and business intelligence outputs, ensuring trusted, production-ready analytics in an Agile delivery environment.

Key Responsibilities

End-to-End Data Quality & Validation

• Validate data accuracy, completeness, and consistency across SQL Server analytics layers and Power BI datasets.
• Perform source-to-target reconciliation, data profiling, and exception analysis.
• Validate transformations, aggregations, and business rules implemented in T-SQL.

Power BI Testing & Validation

• Test Power BI datasets, semantic models, and dashboards.
• Validate KPIs, DAX measures, calculations, filters, slicers, drill-throughs, and visuals.
• Ensure alignment between SQL Server source data and Power BI outputs.
• Validate row-level security (RLS), access controls, and refresh behavior in Power BI Service.
• Execute advanced T-SQL validation queries to verify fact and dimension tables.
• Validate batch and incremental data loads and historical data accuracy.
• Support testing of ETL/ELT pipelines feeding analytics layers.

Test Design, Automation & Release Support

• Create and maintain data test cases, validation scripts, and reconciliation queries.
• Support regression testing, UAT, and analytics release sign-off.
• Collaborate with development teams to resolve data defects and prevent recurrence.
• Participate in sprint planning, stand-ups, reviews, and retrospectives.
• Work closely with SQL, Power BI, and data engineering teams during delivery cycles.
• Communicate data quality risks, findings, and resolutions clearly to stakeholders.

Required Skills & Experience

• Data QA & Analytics QA - 5+ years of experience in Data QA / Analytics QA roles.
• Strong hands-on experience with Microsoft SQL Server and T-SQL for data validation.
• Experience testing Power BI datasets, reports, and dashboards.
• Solid understanding of data warehousing concepts (facts, dimensions, star schemas).
• Strong experience with data reconciliation, data quality checks, and exception handling.

Technical

• Proficiency in writing complex SQL validation queries.
• Experience validating DAX calculations and BI metrics.
• Familiarity with ETL/ELT processes and data pipelines.
• Experience with defect tracking and test management tools.

Soft Skills

• Exceptional attention to detail and analytical thinking.
• Clear communication and documentation abilities.
• Comfortable working in Agile / Scrum environments.
• Ability to collaborate effectively with offshore teams and US stakeholders.
• Ownership mindset with strong delivery focus.

Nice to Have

• Experience with Power BI Service (refreshes, workspaces, RLS).
• Exposure to NiFi or other data ingestion tools.
• Familiarity with data governance, audit, or compliance reporting.