Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
Your Role
As a Power BI Lead at Capgemini, you will be responsible for leading the design, development, and optimization of enterprise-scale Business Intelligence solutions using Power BI. You will work closely with business stakeholders, data teams, and technology partners to transform complex business requirements into scalable analytics platforms, actionable insights, and modern reporting solutions.
You will drive architecture decisions, reporting strategy, data modeling standards, governance frameworks, and modernization initiatives, helping organizations migrate legacy reporting and analytics processes into modern, scalable, and automated Power BI environments.
This role requires strong technical expertise in Power BI, data modeling, Power Query, DAX optimization, reporting architecture, and team leadership.
Responsibilities & Scope
Power BI Architecture & Strategy
Define and lead the overall Power BI architecture, reporting strategy, and data visualization standards.
Design scalable, secure, and high-performing analytics solutions aligned with business objectives.
Establish best practices for report development, semantic modeling, governance, and performance optimization.
Drive BI modernization initiatives to improve reporting capabilities and business insights.
Data Modeling & Analytics Solutions
Design and develop enterprise-grade data models using dimensional modeling best practices.
Build scalable and reusable semantic models utilizing:
Star Schema
Snowflake Schema
Normalized Models
Denormalized Structures
Define business metrics, KPIs, and data definitions that support enterprise reporting requirements.
Ensure consistency, reliability, and scalability across analytics solutions.
Data Transformation & Modernization
Lead the migration of legacy reporting and analytics workflows into Power BI.
Transform existing Alteryx processes into optimized:
Power Query solutions
Power BI datasets
Automated reporting workflows
Modernize Excel-based business processes through centralized reporting and dashboard solutions.
Improve reporting efficiency through automation and standardization.
Dashboard Development & Performance Optimization
Lead end-to-end dashboard and report development initiatives.
Ensure dashboards deliver:
High performance
Strong user experience
Business value
Visual consistency
Review and optimize:
DAX measures
Calculated columns
Power Query transformations
Data refresh performance
Dataset architecture
Implement strategies that improve scalability and reporting responsiveness.
Governance, Security & Deployment
Establish governance standards for enterprise Power BI environments.
Implement and maintain:
Row-Level Security (RLS)
Workspace Security
Dataset Governance
Access Management
Define deployment and lifecycle management standards.
Support CI/CD processes, version control strategies, and release management practices.
Ensure compliance with enterprise data governance, security, and audit requirements.
Leadership & Stakeholder Engagement
Partner with business stakeholders to gather requirements and define reporting strategies.
Translate business needs into technical solutions and implementation roadmaps.
Provide technical leadership and mentoring to Power BI developers and analysts.
Conduct architecture reviews and ensure adoption of best practices across teams.
Collaborate with Data Engineers, Data Architects, Business Analysts, and Product Owners to deliver analytics solutions.
Your Profile
Analytics leader – Passionate about transforming data into business value.
Strategic thinker – Understands how analytics supports organizational goals and decision-making.
Technical expert – Comfortable designing large-scale BI architectures and delivering enterprise reporting solutions.
Mentor and collaborator – Enjoys coaching teams and driving technical excellence.
Problem solver – Skilled at addressing performance, governance, and scalability challenges.
Continuous learner – Keeps current with evolving Microsoft Data & Analytics technologies.
Qualifications & Preferred Skills
Required Skills
Power BI Expertise
Advanced experience with:
Power BI Desktop
Power BI Service
Dataflows
Datasets
Semantic Models
Report Development
Strong dashboard and visualization design skills.
Data Modeling & Transformation
Expertise in:
Star Schema Design
Dimensional Modeling
Data Normalization & Denormalization
Data Architecture Best Practices
Advanced Power Query development experience.
Experience migrating Alteryx workflows to Power BI-based solutions.
DAX & Performance Optimization
Advanced DAX development skills.
Experience tuning and optimizing:
Measures
Calculated Columns
Data Models
Refresh Processes
Query Performance
Governance & Security
Experience implementing:
Row-Level Security (RLS)
Data Governance Frameworks
Reporting Standards
Workspace Administration
Knowledge of enterprise security and compliance practices.
DevOps & Deployment
Experience with:
CI/CD Pipelines
Version Control
Release Management
Development Lifecycle Best Practices
Understanding of Power BI deployment pipelines and environment management.
Stakeholder Management
Strong requirements gathering and business analysis skills.
Ability to translate business requirements into scalable technical solutions.
Experience working directly with executive and business stakeholders.
Preferred Skills
Experience with:
Microsoft Fabric
Azure Data Services
Azure Synapse Analytics
Azure Data Factory
SQL Server
Snowflake
Databricks
Knowledge of Agile/Scrum methodologies.
Experience leading BI modernization and digital transformation initiatives.
Familiarity with enterprise data governance frameworks.
Microsoft Power BI certifications (PL-300 or related certifications).
What You'll Love
Opportunity to lead enterprise analytics and Business Intelligence transformation initiatives.
Exposure to modern Data & Analytics ecosystems including Microsoft Fabric, Azure, and advanced BI technologies.
Access to certifications, leadership development programs, and technical training.
Collaboration with global Data, AI, and Cloud teams.
Career growth opportunities within Capgemini's Data & AI practice.
Inclusive and innovative work environment focused on continuous learning and excellence.
Need to Know
Career Development in Spanish & English: Access to technical academies, certifications, mentoring programs, leadership training, and continuous learning opportunities designed to support your professional growth.
Community Engagement: Participate in innovation communities, technical forums, volunteering initiatives, hackathons, and knowledge-sharing events across Capgemini.
About Capgemini
Capgemini is a global business and technology transformation partner, helping organizations accelerate their dual transition to a digital and sustainable world while creating tangible impact for enterprises and society. It is a responsible and diverse organization with more than 340,000 team members in over 50 countries.
With a strong heritage of more than 55 years, Capgemini helps clients unlock the value of technology through end-to-end services and solutions leveraging capabilities in strategy and design, engineering, AI, generative AI, cloud, data, and digital transformation.
At Capgemini Mexico, we are committed to fostering a diverse and inclusive workplace where everyone has equal opportunities. We welcome applications from all qualified candidates and evaluate them based on merit, skills, qualifications, and experience relevant to the role.