Job Location: This role is local to Chicago and required onsite presence three days a week About the job you9re considering Capgemini is seeking a Senior Power BI Developer / Visual Analytics Consultant with 7+ years of experience in business intelligence, data analytics, and reporting. In this role, you will partner with business stakeholders, data engineers, and architects to transform complex data into actionable insights through advanced Power BI solutions. You will lead analytics initiatives, design scalable data models, develop impactful dashboards, and drive data-driven decision-making across the organization.

Your role

• Analyze business requirements and assess data sources using advanced SQL to determine analytics solutions and project scope.
• Design, develop, and optimize Power BI data models, calculations, measures, and security frameworks.
• Connect, prepare, transform, and manage data from cloud-based data warehouses, including Snowflake, Redshift, Google Cloud SQL, and Azure SQL.
• Create and maintain efficient datasets, views, and aggregations to support reporting and analytics needs.
• Develop interactive dashboards, reports, and visualizations following visual analytics and performance best practices.
• Enable advanced insights through DAX, AI-driven analytics, conditional formatting, drill-through capabilities, and data storytelling techniques.
• Collaborate with business users throughout requirements gathering, dashboard design, testing, deployment, and adoption.
• Manage Power BI workspaces, datasets, security, refresh schedules, deployment pipelines, and content lifecycle.
• Lead project delivery, mentor junior team members, and provide guidance on analytics strategy and best practices.

Skills and experience

• 7+ years of experience in Power BI, BI development, or visual analytics consulting.
• Advanced SQL skills with strong data analysis and troubleshooting capabilities.
• Expertise in Power BI data modeling, DAX, Row-Level Security (RLS), and performance optimization.
• Experience integrating Power BI with cloud data platforms such as Snowflake, Amazon Redshift, Google Cloud SQL, and Azure SQL.
• Strong understanding of data transformation, ETL processes, data warehousing, and analytics best practices.
• Experience developing executive dashboards, reports, and self-service analytics solutions.
• Excellent verbal and written communication, stakeholder management, and data storytelling skills.
• Ability to work independently, manage priorities, and deliver under tight deadlines.
• Leadership experience with the ability to guide projects and mentor junior consultants.

The base compensation range for this role in the posted location is: $119,700 - $159,500.

Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.

The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.

These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

It is not typical for candidates to be hired at or near the top of the posted compensation range.

In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave

• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility