Overview
Skills
Job Details
Responsibilities:
Collaborate with business users and multiple business units to understand BI requirements and reporting goals.
Participate in requirement gathering sessions with data owners, decision makers, and end users to define reporting needs and KPIs.
Design, review, and validate data warehouse tables, ETL source-to-target mappings, and transformation logic.
Perform data validation, reconciliation, and functional testing of BI reports and dashboards.
Verify ETL workflows, schemas, and business rules to ensure data accuracy and completeness.
Test and validate dashboard and report development, including metrics, attributes, and hierarchies.
Ensure data quality, consistency, and performance of BI applications.
Document test cases, test results, and defect logs to support QA processes.
Requirements:
Strong experience in BI testing including ETL, data warehouse, and dashboard validation.
Experience with Azure BI ecosystem (Azure Data Factory, Azure SQL Database, Synapse, or Databricks preferred).
Hands-on experience in writing and executing SQL queries for data validation.
Knowledge of BI reporting tools (Power BI, Tableau, or MicroStrategy).
Experience in data modeling concepts including facts, dimensions, attributes, and hierarchies.
Strong analytical, problem-solving, and communication skills.