Power BI Technical Lead (Lead Analyst)
Location: India
Experience: 6–8 Years
Shift Hours: 12:30 PM to 10:00 PM
Notice Period: Immediate to 20 Days

About the Role
At CGI, we believe in ownership, collaboration, and continuous growth. As part of our Data & Analytics practice, you will work with cross‑functional teams to deliver high‑quality Power BI solutions that enable data‑driven decision‑making and measurable business outcomes.
We are seeking a hands‑on Power BI Technical Lead (Lead Analyst) who combines strong technical expertise with delivery ownership and stakeholder engagement. This is a delivery‑focused role, where you will actively develop Power BI solutions, lead BI workstreams of 3-5 partners, mentor developers, and ensure predictable, high‑quality outcomes within established architectural standards.

This is not a lead‑only role. Active hands‑on development is a core expectation.

Role Responsibilities
Delivery & Technical Leadership

. Lead end‑to‑end delivery of Power BI Analytics Dashboards, Paginated Reports, semantic models, and datasets
. Own technical execution for assigned BI workstreams of report groups with 3-5 partners, ensuring quality, performance, and on‑time delivery
. Drive requirement clarification sessions, design workshops, and solution discussions with business stakeholders
. Translate business requirements into clear technical designs and implement scalable Power BI solutions
. Support BI migration initiatives including report inventory analysis, rationalization, modernization, and conversion planning
. Identify delivery risks, dependencies, and trade‑offs; proactively propose and implement mitigation strategies


Power BI Development & Engineering

. Design and develop Power BI dashboards and Paginated Reports following enterprise best practices
. Build optimized DAX measures and calculations with strong focus on performance and usability
. Develop and optimize Power Query transformations
. Implement Row‑Level Security (RLS), access controls, and dataset governance standards
. Perform performance tuning across models, visuals, datasets, and queries
. Collaborate with data engineering teams on SQL optimization, ETL dependencies, and data readiness


Governance, Quality & DevOps

. Enforce BI development standards, naming conventions, documentation, and version control practices
. Support and implement CI/CD and deployment pipelines for Power BI (Azure DevOps or similar)
. Conduct code and design reviews to ensure adherence to quality, security, and performance standards
. Ensure all solutions comply with data governance, security, and compliance requirements


Team Enablement & Stakeholder Engagement

. Mentor and guide BI developers on Power BI best practices, DAX optimization, and data modeling
. Act as a technical point of contact for stakeholders within assigned delivery scope
. Present solution approaches, insights, and progress updates to business and account leadership
. Contribute to retrospectives and continuous improvement initiatives within the BI practice


Required Skills & Experience

. 7–9 years of experience in Business Intelligence / Data Analytics
. Strong hands‑on expertise in Power BI, including: Advanced data modeling (star / snowflake schemas) DAX development and performance tuning Power Query transformations Row‑Level Security (RLS)
. Experience with Power BI Paginated Reports (SSRS / Report Builder)
. Strong SQL skills with solid understanding of data warehousing and ETL concepts
. Experience leading small BI teams or delivery streams in a project or consulting environment
. Familiarity with DevOps, CI/CD, automation, and data governance practices
. Strong communication skills with the ability to engage confidently with business and technical stakeholders
. Agile / Scrum SDLC experience


Tools & Technologies

. Power BI Desktop
. Power BI Report Builder
. DAX Studio
. Tabular Editor
. SQL Server / Oracle / Postgres
. Jira / Azure DevOps


Good to Have

. Experience migrating legacy BI platforms such as SAP BusinessObjects, Cognos, WebFocus, Pentaho to Power BI
. Exposure to Azure Data Services or Microsoft Fabric
. Experience in reporting modernization or BI migration programs
. Experience working in multi‑stakeholder or distributed delivery environments
. Awareness of automation, monitoring, or performance management approaches in BI platforms


What Success Looks Like in This Role

. Consistently delivers Power BI solutions with predictable quality and timelines
. Leads structured and effective stakeholder discussions
. Improves team capability through mentoring and technical guidance
. Ensures reporting outcomes align with measurable business impact
. Acts as a reliable hands‑on technical lead within defined architectural standards

#LI-IP2

Your future duties and responsibilities

Required qualifications to be successful in this role

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team—one of the largest IT and business consulting services firms in the world.