Power BI Developer

Description

The company is a global consulting firm that delivers digital solutions across AI, consulting, digital, cloud and DevOps, data, and software engineering for financial services and technology firms. The company has 17,000+ staff in 58 offices across 22 countries and has operated for 20+ years.

Its FinLabs group researches and builds solutions in AI, blockchain, data science models, digital underwriting, and mobile-first applications.

The team is looking for an experienced Power BI developer with strong SQL, data warehousing, and enterprise analytics skills. You will build complex dashboards and reports and work with business stakeholders to turn data into insights. The role also calls for scripting, REST API work, and familiarity with DevOps practices for automation, deployment, and troubleshooting.

Responsibilities

• Build, maintain, and improve interactive reports, dashboards, and ad-hoc queries in Power BI.
• Work with business users and analysts to define requirements and turn them into data solutions.
• Use Power Query, Power Pivot, and data modeling to build efficient data models.
• Write and tune DAX queries for speed and analytical depth.
• Create and manage Paginated Reports with Power BI Report Builder or similar tools.
• Query and manage SQL Server or other relational databases to extract and analyze data.
• Support script-based jobs and automation workflows, including REST API integrations.
• Help deploy solutions with Azure DevOps, Git, and CI/CD practices, applying a conceptual understanding of deployment pipelines.
• Investigate data issues and resolve them quickly to keep systems reliable.
• Take part in the full project lifecycle, from requirements gathering through deployment and maintenance.

Requirements

• At least 8 years of experience in data warehousing, business intelligence, analytics, and reporting.
• At least 3 years of experience with relational and multi-dimensional (OLAP) data modeling.
• Strong SQL skills, including query optimization and database design, especially with SQL Server or similar databases.
• Solid understanding of Fixed Income, Equity, and Derivatives businesses.
• Extensive experience with data modeling in Power Query and Power Pivot.
• Proficiency in DAX for complex measures and calculated columns.
• Proven experience building reports and dashboards for enterprise systems.
• Ability to analyze user requirements, recommend solutions, and implement them.
• Experience with REST API integrations and scripting for automation.
• Basic understanding of DevOps principles, version control with Git and Azure Repos, and deployment pipelines.
• Excellent communication, presentation, and interpersonal skills.
• Self-driven, with strong troubleshooting skills and the ability to manage multiple priorities under pressure.
• Preferred, not required: working knowledge of Data Flows within Power BI.
• Preferred, not required: experience with Power BI Report Server (PBRS).
• Preferred, not required: familiarity with Power BI Service (Power On) and cloud-based analytics solutions.
• Preferred, not required: experience with the Snowflake data warehouse or other cloud data platforms.

Conditions

The base salary varies by geography and other factors. For this role filled in Mississauga, ON, the base salary is CAD $115k to CAD $125k per year, plus benefits.

The company is an equal opportunity and affirmative action employer that makes employment decisions based on business needs, job requirements, and individual qualifications.

Benefits

• Paid annual leave of 15 days (3 weeks), plus 10 days of personal leave for floating and sick days.
• Comprehensive insurance covering medical, dental, vision, life, and long-term disability.
• Flexible hybrid working policy.
• RRSP with an employer contribution of up to 4%.
• A higher education certification policy.
• On-demand access to more than 5000 curated courses on Udemy for Business at no cost.
• Coaching from experienced colleagues in FinLabs and Centers of Excellence (CoE).
• Projects for tier-one banks, financial institutions, and insurance firms.