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 pl
atform 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.