Role & seniority: BI & ETL Tester (senior, 5–10+ years in BI/ETL testing or QA)

Stack/tools: ETL testing (Airflow), BI tools (Power BI, SAP BO), data warehousing (Star/Snowflake schemas), cloud data platforms (GCP), SQL (complex queries, window functions, CTEs), Python/pytest (automation), dbt tests, JIRA, Git, CI/CD awareness

Top 3 responsibilities

ETL/Data Pipeline Testing: end-to-end validation, source-to-target verification, data reconciliation, schema/transformation checks, scheduling and error handling, regression/functional/sanity testing
BI/Reporting Testing: validate reports/dashboards, verify formatting, filters, KPIs, aggregations, performance, data refresh, row-level/report-level security
SQL & Data Quality Validation + Test Execution: write/execute complex SQL for business rules, identify data issues, collaborate with engineers/developers, create test plans/cases, support manual and automated testing, defect tracking

Must-have skills

5–10+ years in BI/ETL testing or QA
Strong SQL (joins, window functions, aggregations, CTEs)
Experience with ETL tools (Airflow) and BI tools (Power BI, SAP BO)
Data warehousing concepts (Star/Snowflake), cloud platforms (GCP a plus)
Agile/Scrum, defect management, test documentation (JIRA)

Nice-to-haves

SAP source systems (ECC, S/4HANA, SAP BW/IBP)
BigQuery or other big data tech
Automation (Python or SQL-based frameworks), CI/CD for data testing
Version control (Git)
Lo

Full Description

We are seeking a skilled BI & ETL Tester to validate, analyze, and ensure the accuracy, performance, and reliability of data pipelines, BI reports, dashboards, and analytics solutions. The ideal candidate will have strong experience in data validation, SQL, ETL process testing, and working with modern data platforms. Key Responsibilities

ETL / Data Pipeline Testing

Validate end-to-end ETL workflows including data extraction, transformation, and loading.
Perform source-to-target data validation, record counts, reconciliation, schema checks, and transformation logic checks.
Test data ingestion from multiple sources (databases, files, SAP, cloud platforms).
Verify scheduling, dependencies, and error-handling processes in ETL jobs.
Conduct regression, functional, and sanity testing for data loads.

BI / Reporting Testing

Validate BI reports and dashboards for accuracy, formatting, filters, drill-downs, KPIs, and aggregations.
Compare visual outputs with backend data using SQL queries.
Test performance, data refresh cycles, row-level security, and report-level access.

SQL & Data Quality Validation

Write complex SQL queries to validate business rules, calculations, and data transformations.
Identify data issues, anomalies, and integrity gaps.
Collaborate with Data Engineers, BI Developers, and Data Analyst to resolve defects.

Test Planning & Execution

Create detailed test plans, test cases, test scenarios, and acceptance criteria.
Perform manual testing and assist in setting up automated testing frameworks (e.g., Python, PyTest, dbt tests).
Document defects in tools like JIRA and follow through to closure.
Participate in sprint planning, reviews, and Agile ceremonies.
Required Skills & Experience
5–10+ years of BI/ETL testing or QA experience.
Strong SQL skills (joins, window functions, aggregations, CTEs).

Experience testing ETL tools such as: Airflow

Experience with BI tools

Power BI, SAP BO, etc.
Understanding of data warehousing (Star/Snowflake schema, dimensions, facts).
Knowledge of cloud data platforms ( GCP is a plus).
Familiarity with Agile/Scrum methodology.
Experience in defect management and test documentation tools.
Preferred Qualifications

BI and ETL Tester

Top 3 responsibilities

Must-have skills

Nice-to-haves

Full Description

Experience with BI tools