Manager
Referral available at EXL
An employee here can refer you. The referrer stays anonymous and reaches out to you directly if interested.
Description
Role name: Lead Power BI Developer
Exp: 8 to 10 Years
Band - C1
Location: Gurgaon/Bangalore – 5 Days Work from office
JD - Roles & Responsibilities:
- Analyze business requirements by engaging with stakeholders to identify key metrics, KPIs, and reporting objectives that align with organizational goals.
- Conceptualize end-to-end reporting solutions, translating complex business needs into structured data models and visualization frameworks.
- Perform exploratory data analysis (EDA) to understand data distributions, identify patterns, detect anomalies, and validate assumptions before report design.
- Conduct data profiling and quality assessments to evaluate completeness, consistency, and accuracy of source data, recommending remediation where necessary.
- Analyze historical and real-time datasets to uncover trends, correlations, and business insights that drive strategic decision-making.
- Perform root-cause analysis on business metrics and KPIs to identify performance drivers, variances, and opportunities for improvement.
- Design interactive, user-centric Power BI dashboards and reports with a strong focus on usability, storytelling, and actionable insights.
- Develop robust data models using Power Query (M) and DAX, ensuring optimized performance, accuracy, and scalability.
- Apply analytical methods (trend analysis, variance analysis, etc.) to enrich reporting with prescriptive insights.
- Translate raw data into meaningful business narratives by combining quantitative analysis with contextual understanding of business processes.
- Integrate data from multiple sources (SQL Server, Excel, SharePoint, APIs, cloud platforms like Azure synapse, etc.) through ETL processes and establish reliable data pipelines.
- Implement row-level security (RLS), role-based access, and governance standards to ensure data confidentiality and compliance.
- Optimize report performance by fine-tuning DAX measures, data refresh schedules, and semantic models.
- Validate data accuracy through reconciliation with source systems and cross-verification against business rules to ensure trustworthy analytics.
- Implement Copilot for Power BI to enable natural-language querying, allowing end-users to interact with reports conversationally and generate insights without technical expertise.
- Configure and optimize semantic models (linguistic schemas, synonyms, descriptions, and metadata) to enhance Copilot's contextual understanding and response accuracy.
- Design Copilot-ready reports by structuring measures, tables, and relationships to support AI-driven summarization, narrative generation, and Q&A experiences.
- Enable AI-powered features such as automated report page creation, smart narratives, and executive summaries to accelerate insight delivery.
- Establish governance and responsible AI practices around Copilot usage, including data sensitivity handling, prompt guidance, and user access controls within the Fabric/Power BI ecosystem.
- Educate and enable business users to effectively leverage Copilot capabilities through demos, documentation, and best-practice guidelines.
- Collaborate with cross-functional teams — business analysts, data engineers, and leadership — to deliver reports that support strategic decision-making.
- Present analytical findings and insights to business stakeholders through data-driven storytelling, enabling informed and timely decisions.
- Maintain documentation of data sources, transformations, business logic, and report specifications for long-term maintainability.
- Continuously enhance existing reports based on user feedback, evolving business needs, and Power BI platform updates
- Analyze business requirements by engaging with stakeholders to identify key metrics, KPIs, and reporting objectives that align with organizational goals.
- Conceptualize end-to-end reporting solutions, translating complex business needs into structured data models and visualization frameworks.
- Perform exploratory data analysis (EDA) to understand data distributions, identify patterns, detect anomalies, and validate assumptions before report design.
- Conduct data profiling and quality assessments to evaluate completeness, consistency, and accuracy of source data, recommending remediation where necessary.
- Analyze historical and real-time datasets to uncover trends, correlations, and business insights that drive strategic decision-making.
- Perform root-cause analysis on business metrics and KPIs to identify performance drivers, variances, and opportunities for improvement.
- Design interactive, user-centric Power BI dashboards and reports with a strong focus on usability, storytelling, and actionable insights.
- Develop robust data models using Power Query (M) and DAX, ensuring optimized performance, accuracy, and scalability.
- Apply analytical methods (trend analysis, variance analysis, etc.) to enrich reporting with prescriptive insights.
- Translate raw data into meaningful business narratives by combining quantitative analysis with contextual understanding of business processes.
- Integrate data from multiple sources (SQL Server, Excel, SharePoint, APIs, cloud platforms like Azure synapse, etc.) through ETL processes and establish reliable data pipelines.
- Implement row-level security (RLS), role-based access, and governance standards to ensure data confidentiality and compliance.
- Optimize report performance by fine-tuning DAX measures, data refresh schedules, and semantic models.
- Validate data accuracy through reconciliation with source systems and cross-verification against business rules to ensure trustworthy analytics.
- Implement Copilot for Power BI to enable natural-language querying, allowing end-users to interact with reports conversationally and generate insights without technical expertise.
- Configure and optimize semantic models (linguistic schemas, synonyms, descriptions, and metadata) to enhance Copilot's contextual understanding and response accuracy.
- Design Copilot-ready reports by structuring measures, tables, and relationships to support AI-driven summarization, narrative generation, and Q&A experiences.
- Enable AI-powered features such as automated report page creation, smart narratives, and executive summaries to accelerate insight delivery.
- Establish governance and responsible AI practices around Copilot usage, including data sensitivity handling, prompt guidance, and user access controls within the Fabric/Power BI ecosystem.
- Educate and enable business users to effectively leverage Copilot capabilities through demos, documentation, and best-practice guidelines.
- Collaborate with cross-functional teams — business analysts, data engineers, and leadership — to deliver reports that support strategic decision-making.
- Present analytical findings and insights to business stakeholders through data-driven storytelling, enabling informed and timely decisions.
- Maintain documentation of data sources, transformations, business logic, and report specifications for long-term maintainability.
- Continuously enhance existing reports based on user feedback, evolving business needs, and Power BI platform updates
Graduate in Computer Science, Data Science, or related field. 8-10 years of experience in data engineering or related field.
Skills
Sign in to read and join the discussion.