Advanced Power BI Engineer
At a glance
Mid-level Data Analysis & BI role at Invesco. Charlottetown · full-time · CA$52,000–CA$58,000 base.
dataroles summary, based on the employer's posting.
What you'll do
- Build clear, interactive Power BI reports that turn business data into useful decisions and actionable KPIs
- Set interface standards for Technology reports, then map business needs into navigation flows and wireframes
- Connect data sources through Power BI gateways and M scripting, then shape results with DAX and R
- Apply row-level security and control access to reports and workspaces for the Technology Infrastructure team
- Work with Business Analysts to rank reporting needs, verify data accuracy, and carry agreed work through
What you bring
- At least three years working with the Microsoft BI Stack, including two years building Power BI reports
- Strong visual design experience and working knowledge of common design software such as Photoshop
- Practical experience with Microsoft Office, especially Excel
Who this fits
This role suits a mid-career Power BI specialist who can work independently with analysts and stakeholders and support a Technology Infrastructure team. The position is based in Charlottetown and requires at least four full days each week in an Invesco office under the workplace policy stated as of October 1, 2025.
From the employer
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 timeWorker Type
EmployeeJob Exempt (Yes / No)
NoWorkplace 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.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.