Senior / Lead - Power BI Developer

Founded in 1976, CGI is among the world's largest independent IT and business consulting services firms. With 94,000 consultants and professionals globally, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services, and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion, and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com. Job Title: Senior Power BI Developer Position: SSE / LA / AC Experience: 6 to 10+ years of experience Job location: Bangalore / Chennai Position ID: J0626-1190 Work Type: Hybrid Employment Type: Full Time / Permanent Qualification: Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field. We are looking for a highly skilled Senior Power BI Developer with extensive experience in designing, developing, and maintaining enterprise scale Business Intelligence solutions. The ideal candidate should have strong expertise in Power BI, DAX, Power Query, data modeling, report optimization, and stakeholder management. Key Responsibilities: 1. Power BI Development . Design, develop, and maintain interactive Power BI dashboards and reports. . Translate business requirements into effective reporting and analytical solutions. . Create complex DAX measures, calculated columns, KPIs, and business metrics. . Develop and maintain reusable datasets and semantic models. . Implement report navigation, drill through, bookmarks, and advanced visualizations. . Ensure reports meet performance, scalability, and usability requirements. 2. Data Modeling . Design and implement Star Schema and Snowflake Schema models. . Develop optimized data models for reporting and analytics. . Establish relationships, hierarchies, and calculated tables. . Optimize model performance for large datasets. 3. Data Transformation . Develop and maintain Power Query (M Language) transformations. . Integrate data from multiple sources such as SharePoint, APIs, and cloud platforms. . Perform data cleansing, validation, and transformation activities. . Troubleshoot and resolve data quality issues. 4. Security & Governance . Implement and maintain Row Level Security (RLS). . Manage workspace access and report permissions. . Follow Power BI governance and best practices. . Ensure compliance with organizational security standards. 5. Performance Optimization . Optimize DAX calculations and report performance. . Analyze and improve dataset refresh efficiency. . Reduce report load times through efficient data modeling techniques. . Monitor and troubleshoot Power BI Service refresh issues. 6. Power BI Service Administration . Manage workspaces, apps, gateways, datasets, and dataflows. . Configure scheduled refreshes and deployment processes. . Support report publishing and production deployments. . Monitor refresh history and troubleshoot failures. 7. Stakeholder Collaboration . Work closely with business users to gather requirements and define KPIs. . Participate in UAT, deployment, and postproduction support. . Communicate technical solutions effectively to non-technical stakeholders. . Provide user training and knowledge transfer sessions. Required Technical Skills . Power BI Desktop . Power BI Service . DAX . Power Query (M Language) . SQL . Data Modeling . Row Level Security (RLS) . Dataflows . Power BI Gateway . Performance Tuning . SharePoint Preferred Skills . Microsoft Fabric . AWS(S3 Bucket) . Databricks . REST APIs Key Experience Required . 6+ years of experience in Power BI development. . Strong experience in creating enterprise level dashboards and reports. . Expertise in DAX optimization and troubleshooting. . Experience implementing Row Level Security (RLS). . Experience working with large datasets and performance tuning. . Strong understanding of BI and Data Warehouse concepts. . Experience supporting production reports and handling critical incidents. Soft Skills . Strong analytical and problem-solving skills. . Excellent communication and stakeholder management skills. . Ability to work independently and lead reporting initiatives. . Experience working in Agile environments. CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs. #LI-GB9