Enterprise Power BI Architect

As an Enterprise Power BI Architect at CGI, your role involves defining, governing, and enabling BI architecture across BI Transformation programs and multiple accounts. Your responsibilities include: - Define and govern enterprise-level Power BI transformation architecture standards and best practices - Partner with solution architects to drive BI transformation solutioning across programs and accounts - Lead migration assessments and planning, including report inventory rationalization, modernization strategies, and conversion roadmaps - Provide architectural guidance and design patterns for paginated and interactive Power BI analytics; build complex or reference implementations where architectural validation is required - Design scalable semantic models, reporting frameworks, and reusable datasets - Establish reusable data models, KPI frameworks, visualization standards, development practices, and accessibility requirements - Define and implement data security strategies, including Row-Level Security (RLS) and access governance - Optimize performance, scalability, and reliability across datasets, models, and enterprise workspaces You will also be responsible for: - Leading BI transformation planning and execution phases with clients, account teams, and delivery teams - Defining and enforcing BI governance standards, including naming conventions, version control, workspace strategy, and deployment pipelines - Collaborating with data engineering teams to align data warehousing, lakehouse, and reporting layer architectures - Evaluating existing BI landscapes and recommending architecture tooling and usage improvements - Ensuring compliance with regulatory, security, and data governance requirements Additionally, you will: - Lead solution architecture discussions with business stakeholders and client leadership - Translate business strategy into enterprise reporting and analytics roadmaps - Articulate trade-offs, risks, scalability considerations, and remediation approaches clearly - Support account teams in solution proposals, estimations, and client presentations Furthermore, your role involves: - Guiding Tech Leads and developers on advanced data modeling, DAX optimization, and performance challenges - Conducting architecture and design reviews to ensure adherence to standards - Enabling DevOps CI/CD automation and monitoring practices for Power BI - Mentoring BI teams to elevate technical maturity and architectural thinking Qualifications required for this role include: - 9 years of experience in Business Intelligence/Data Analytics - 5 years of deep hands-on Power BI experience - Expert-level proficiency in advanced data modeling, DAX optimization, Power Query transformation, Row-Level Security (RLS), and governance - Strong SQL expertise and solid understanding of data warehousing architectures - Experience working with enterprise data platforms (Azure SQL Server, Microsoft Fabric preferred) - Experience defining and implementing DevOps/deployment pipelines for Power BI - Strong stakeholder management, communication, and architectural articulation skills Good to have: - Project experience migrating SAP BusinessObjects, Cognos, WebFocus, Pentaho, or similar platforms to Power BI - Experience with Microsoft Fabric - Exposure to Data Lakes and Lakehouse architectures - Experience with automation and monitoring frameworks - Experience working in multi-account or global delivery environments In this role, you can expect to be a key enabler of predictable, high-quality BI delivery, bridging business strategy, data platforms, and reporting architecture. Join CGI's team, one of the largest IT and business consulting services firms in the world, to turn meaningful insights into action and shape your career in a company built to grow and last. As an Enterprise Power BI Architect at CGI, your role involves defining, governing, and enabling BI architecture across BI Transformation programs and multiple accounts. Your responsibilities include: - Define and govern enterprise-level Power BI transformation architecture standards and best practices - Partner with solution architects to drive BI transformation solutioning across programs and accounts - Lead migration assessments and planning, including report inventory rationalization, modernization strategies, and conversion roadmaps - Provide architectural guidance and design patterns for paginated and interactive Power BI analytics; build complex or reference implementations where architectural validation is required - Design scalable semantic models, reporting frameworks, and reusable datasets - Establish reusable data models, KPI frameworks, visualization standards, development practices, and accessibility requirements - Define and implement data security strategies, including Row-Level Security (RLS) and access governance - Optimize performance, scalability, and reliability across datasets, models, and enterprise workspaces You will also be responsib