Advanced Power BI Engineer
Invesco Ltd. · Charlottetown, Prince Edward Island, Canada · CA$52K–CA$58K/yr
Financial Services · 5,001-10,000 employees
About the role
The role involves designing and deploying interactive business intelligence solutions using Microsoft Power BI to support decision-making processes. You will collaborate with stakeholders to translate business requirements into insightful dashboards while managing data accuracy and security.
What they look for
Requirements
Candidates must have at least three years of experience with the Microsoft BI stack and two years of specific Power BI reporting experience. Proficiency in design tools like Photoshop and strong analytical skills are required to translate complex datasets into actionable insights.
Benefits
Full 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?
Our people are at the very core of our success and we strive to provide employees with a competitive total rewards package which includes:
- 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 accessibility@invesco.ca or 1.800.874.6275 to let us know if you require accommodation for an interview due to a disability.
