Advanced Power BI Engineer

Invesco Ltd.; Charlottetown; Hybrid; 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 Ltd. in Charlottetown is seeking a Power BI specialist to design, develop and deploy interactive BI solutions. You will partner with Business Analysts and stakeholders to translate requirements into dashboards, ensure data accuracy, and deliver insights that support decision making.

The role involves building visually impactful reports, applying Power BI features including row-level security, and guiding UI/UX design for technology reporting themes within a global investment firm.

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 common design tools such as Photoshop.
• Hands on experience with Microsoft Office products, especially Excel.

Responsibilities

• 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 KPIs.
• Develop UI/UX and design language for various Technology reporting themes.
• Implement design principles and ensure reports adhere to them.
• Translate business requirements into documented navigation flows and wireframes.
• Create self-explanatory reporting interfaces to answer business questions clearly.
• Self-manage by understanding customer needs and delivering accordingly.
• Utilize Power BI latest features and updates.
• Serve as the Power BI SME for the Technology Infrastructure team.
• Implement row level security and manage report/workspace access.
• Review and prioritize requirements with Business Analysts and track to completion.
• Extract data from multiple sources using Power BI gateways and M scripting.

Skills

Power BI

DAX

R

Tools

Microsoft BI Stack

Power BI

Photoshop

Excel

M scripting

Job description

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.

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:

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

• 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

Contract and Working Hours

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.

Benefits

• 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.

Accessibility

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.

About Invesco

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.