Senior Power BI Developer - Visual Analytics Consultant

Capgemini; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Power BI Developer to join their North York office. The role involves analyzing data, designing dashboards, and implementing data models to deliver actionable insights. Candidates should have extensive experience in SQL and Power BI, along with strong analytical and leadership skills. This position supports flexible work arrangements and emphasizes employee well-being.

Benefits

Flexible work

Healthcare

Paid time off

Parental leave

Family benefits

Social programs

Mentoring

Qualifications

• 7 years of relevant experience.
• Advanced skills in SQL queries.
• Strong knowledge of Cloud Data Warehouses.

Responsibilities

• Analyze data via SQL queries and assess quality for analytics.
• Plan and implement Power BI connections to data sources.
• Design dashboards based on best practices and requirements.

Skills

SQL

Data storytelling

Analytical curiosity

Leadership

Python

Education

Microsoft Power BI certifications

Tools

Power BI

Snowflake

Redshift

Google Cloud

Azure

Job description

Join to apply for the Senior Power BI Developer - Visual Analytics Consultant role at Capgemini

Get AI-powered advice on this job and more exclusive features.

Job Title:

Senior Power BI Developer / Visual Analytics Consultant

Job Location:

North York, Ontario

About The Role

Capgemini is hiring a Senior Power BI Developer / Visual Analytics Consultant with 7+ years of experience working in office 3 days per week in North York, Ontario.

Responsibilities

1. Perform Discovery and Determine Scope
   • Analyze data via SQL queries to assess structure, granularity, quality, and fit for analytics.
   • Gather, document, and validate detailed business requirements.
   • Discover, define, and document innovative, actionable analytics and KPIs.
   • Prepare high-level project plans including required activities, resources, and timeframes.
   • Recommend the appropriate analytics delivery method based on scenarios.
   • Understand when to recommend Power BI platform, mobile, and Embedded Analytics options.
2. Evaluate, Prepare, and Connect to Data
   • Plan and implement Power BI connections to data sources such as Snowflake, Redshift, Google Cloud SQL, and Azure SQL.
   • Collaborate with data engineers and architects to prepare efficient data sets.
   • Create views and aggregate data within Cloud data warehouses.
   • Handle data sourcing, connections, settings, queries, and performance issues.
   • Clean, transform, and load data.
3. Plan and Implement Data Models & DAX
   • Recommend calculation methods via Power BI or Data Warehouse.
   • Design data models including tables, relationships, measures, hierarchies, and performance considerations.
   • Develop data models with filtering, calculated tables/columns, and row-level security.
   • Create measures using DAX for complex calculations.
   • Optimize model performance through aggregations and other techniques.
4. Design Dashboards and Develop Visualizations/Reports
   • Implement performance best practices.
   • Develop visualizations for insightful, actionable business use.
   • Design dashboards based on best practices and requirements.
   • Collaborate with stakeholders to iterate dashboards.
   • Support UAT, performance testing, and deployment.
   • Create dashboards with features like mobile access, Q&A, data alerts.
   • Enrich reports with drill-through, drilldown, slicers, and exports.
5. Enable Insightful Analysis & AI
   • Enhance reports with conditional formatting, top N analysis, Quick Insights.
   • Perform advanced analysis using grouping, bins, AI Insights.
6. Deploy Assets and Maintain Access
   • Manage datasets, scheduled refreshes, security, and dependencies.
   • Create and manage workspaces, roles, pipelines, subscriptions, content promotion, and lifecycle.

Qualifications

• 7 years of relevant experience.
• Advanced skills in SQL queries.
• Data storytelling and analytical curiosity.
• Leadership and coaching abilities.
• Microsoft Power BI certifications, especially PL-300.
• Strong knowledge of Cloud Data Warehouses (e.g., Snowflake, Redshift, Google, Azure).
• Python skills in full-stack environments.

Life at Capgemini

Capgemini supports your well-being with flexible work, healthcare, paid time off, parental leave, family benefits, social programs, mentoring, ERGs, and disaster relief.

About Capgemini

Capgemini is a global leader in business and technology transformation, with over 55 years of experience, 340,000 employees, and operations in more than 50 countries. We leverage AI, cloud, data, and industry expertise to deliver impactful solutions. Our 2024 revenues were €22.1 billion.

Disclaimer

We are an Equal Opportunity Employer committed to diversity. We consider all qualified applicants without regard to protected characteristics. Reasonable accommodations are provided during recruitment. For more info, visit this link.