Role and Responsibilities:
- Lead discovery of current reporting, BI, and data landscapes: inventory source systems, existing datasets, semantic models, KPIs, metric definitions, data gaps, and upstream/downstream dependencies.
- Design logical and physical data models for analytics use cases, including dimensional models, fact and dimension structures, conformed dimensions, aggregations, and curated reporting marts.
- Develop analytics-ready datasets using SQL and Redshift, including data transformation, joins, business rules, performance tuning, incremental loads, and data reconciliation.
- Build and maintain governed semantic layers and Power BI-ready data structures that enable self-service reporting, standardized metrics, and consistent business interpretation.
- Define and document metric logic, source-to-target mappings, lineage, grain, refresh frequency, business rules, and validation criteria for all analytical data assets.
- Implement data quality and validation checks including completeness, accuracy, duplication, referential integrity, reconciliation,



and exception reporting to ensure trusted analytics outputs.
- Support Power BI dashboard development by shaping datasets, optimizing query performance, validating measures, and ensuring alignment between data models and business reporting needs.
- Collaborate with data engineering, BI, product, and business teams to deliver reusable, scalable, and well-governed analytics data products in an Agile delivery model.
- Prepare and maintain explicit documentation including data dictionaries, model design notes, source-to-target mapping documents, acceptance criteria, data quality test results, and operational runbooks.
- Support migration, rationalization, and modernization of legacy reporting assets by identifying redundant datasets, retiring unused tables, and aligning future-state models to analytics requirements.
- Use SAS Viya or similar analytics platforms, where applicable, to understand legacy logic, valida

📌 Power BI Developer (Gurugram)
🏢 EXL
📍 Gurugram