Advanced Power BI Engineer

invesco; Charlottetown; On-site; CAD 52,000 - 58,000; Full time

Benefits offered by this job

Hybrid working environment

RRSP Contributions

Health & Wellness Benefits

Work flexibility Programs

Parental Leave Benefits

Study Support

Job summary

Invesco is seeking a Power BI Developer to design, build, and deploy advanced BI solutions within the Enterprise Workplace and Collaboration Team. You will translate business needs into interactive dashboards, leveraging GenAI features and DAX/R for data analysis, while ensuring data accuracy and security.

The role emphasizes visual storytelling, UI/UX design, and collaboration with Business Analysts. This is a hybrid position with the expectation to work from Invesco offices several days a week.

Qualifications

• Three plus years of experience with Microsoft BI Stack.
• At least two years of Power BI reporting experience.
• Comprehensive design experience with knowledge of Photoshop.
• Hands on experience with Microsoft Office products, especially Excel.

Responsibilities

• Design, develop, and deploy Power BI reports that are user-friendly and visually impactful.
• Incorporate native and GenAI/ML features of Power BI to derive KPIs.
• Develop UI/UX and design language for Technology reporting themes.
• Translate business requirements into navigation flows and wireframes.
• Ensure reporting interfaces are clear and self-explanatory.
• Implement row level security and manage report access.
• Extract data from multiple sources using Power BI gateways and M scripting.
• Write complex DAX and use R for data analysis.
• Collaborate with Business Analysts to prioritize requirements.
• Handle large structured and unstructured datasets.

Skills

Microsoft BI Stack

Power BI reporting

Excel

Photoshop

Tools

Photoshop

Job description

As one of the world's leading independent global investment firms, Invesco is dedicated to rethinking possibilities for our clients. By delivering the combined power of our distinctive investment management capabilities, we provide a wide range of investment strategies and vehicles to our clients around the world. If you're looking for challenging work, intelligent colleagues, and exposure across a global footprint, come explore your potential at Invesco.

Job Description

About the Team:

This position will be part of the Enterprise Workplace and Collaboration Team within the Infrastructure Technology department. The team consists of global engineers supporting key Technology solutions.

About the Role:

This position will be responsible for designing, developing, and deploying visually appealing and highly interactive business intelligence solutions using Microsoft Power BI. The incumbent would work with Business Analysts and key stakeholders to analyze the data and reporting requirements, understand the business needs, ensure data accuracy, and recommend and deliver insightful dashboards and reports that support decision-making processes.

Responsibilities of the Role:

• The focus of the role is to develop Power BI reports that are user friendly and visually impactful
• Incorporate native and GenAI/ML data analysis features of Power BI to translate data into insights and highlight actionable KPIs
• Develop UI/UX and design language for various Technology reporting themes
• Devise and implement design principles and ensure all reports adhere to these principles
• Translate business requirements into documented navigation flows and wireframes
• Take a simplistic and self-explanatory approach to reporting interface to ensure answers to questions asked by Business Partners are clear and evident
• Ability to self-manage, by understanding customer needs and converting them into deliverables
• Utilize full potential of Power BI by incorporating the latest features and updates
• Serve as the Power BI subject matter expert for a dedicated Technology Infrastructure team.
• Implement row level security and manage access to reports and workspaces
• Work with Business Analysts to review and prioritize requirements and track to completion
• Extract data from multiple data sources by configuring Power BI gateways and using M scripting to connect and refresh the data.
• Write complex DAX statements and utilize R to manipulate and analyze data
• Ability to work with large structured and unstructured datasets
• Special projects as assigned

Requirements of the Role:

• Three plus years of experience with Microsoft BI Stack
• At least two years of Power BI reporting experience
• Comprehensive design experience with knowledge of common design tools such as Photoshop
• Hands on experience with Microsoft Office products, especially Excel

The salary range for this position in Charlottetown is $52,000 - $58,000 CAD/year. The total compensation offered for this position includes salary and incentive pay and will vary based on skills, experience and location

Full Time / Part Time

Full time

Worker Type

Employee

Job Exempt (Yes / No)

No

Workplace Model

Pursuant to Invesco's Workplace Policy, employees are expected to comply with the firm's most current workplace model, which as of October 1, 2025, includes spending at least four full days each week working in an Invesco office. This reflects our belief that spending time together in the office helps us build stronger relationships, collaborate more easily, and support each other's growth and development.

What's in it for you?

• Hybrid working environment
• RRSP Contributions
• Health & Wellness Benefits
• Work flexibility Programs
• Parental Leave Benefits
• Study Support

The above information on this description has been designed to indicate the general nature and level of work performed by employees within this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. The job holder may be required to perform other duties as deemed appropriate by their manager from time to time.

Invesco is committed to fair and accessible employment practices. If selected for an interview, we will work with you to ensure that your interview is accessible and accommodation is provided. Please contact us at [e-mail] or 1.800.874.6275 to let us know if you require accommodation for an interview due to a disability.