Power BI Developer

100 Queens Quay E, Toronto, ON M5E 1Z2, Canada Req #254
August 19, 2024
About Us:
As a leading Canadian wealth management organization, Richardson Wealth offers the personal touch of a boutique firm while delivering big results. With offices across the country, we are home to some of Canada’s best investment advisors. We’ve embarked on an exciting growth phase – a multi-year transformational journey to enhance our entrepreneurial, high-performing, advisor-centric culture.

Where we’re going: 
We want to be the brand of choice for Canada’s top advisors and their high-net-worth clients. We also have an ambitious growth strategy to triple our Assets under Administration (AUA) to $100 billion by 2027.

To reach our goals, we are making strategic investments in technology, real estate and, most importantly, our people.

Position Overview
As a Power BI Developer, you will bring extensive experience using Microsoft Power BI and broader Power Platform to translate business needs into easily understandable reports and visualizations. Working with members of our business community as well other Data Services team members, you will be accountable for gathering requirements from the client for development, testing and implementation. You are often leading solutions with an iterative and consultative approach, as well as providing support and mentoring to other team members.

The successful candidate will also have the opportunity to influence a multi-year data architecture modernization program currently underway, helping to ensure the data architecture serves our business needs as the organization evolves. 

Duties and Responsibilities
•    Serve as a Subject Matter Expert (SME) within all aspects of Microsoft Power Platform and collaborate with different teams to understand the business requirements and conduct gap analysis
•    Conceptualize, design and implement Microsoft Power BI solutions from the existing corporate database and burgeoning data lakehouse/warehouse, as well as other enterprise data sources
•    Build automated reports & dashboards with the help of Power BI & other reporting tools
•    Leverage and extend processes aligned to data visualization best practices (as defined or adopted by business sponsors) and standards, ensure quality (Alignment to form, fit and function)
•    Perform detailed analysis on tested and deployed Power BI scripts
•    Make essential technical and strategic changes to optimize Power BI environments
•    Assist in the design of logical and physical dimensional data mart models
•    Conduct unit & integration tests, assisting in test preparations to ensure data integrity, data quality, and program functional completeness & correctness
•    Produce and maintain technical documentation for colleagues, as well as procedures for end users
•    Participate in the development of project plans to establish appropriate workload expectations and schedules

Qualifications 
•    4+ years of experience in a Power BI Developer, or similar data-related role
•    4+ years of experience with SSAS, SSRS, SSIS, in MS SQL Server 2016 or higher
•    Excellent analytical skills and ability to present ideas and recommendations to various stakeholders and ability to grasp complex business 
•    Demonstrated expertise in Power Platform (PowerApps, MS Flow and Power BI)
•    Experience with DAX, M and SQL languages
•    Experience in programming, scripting, automation, and customization initiatives
•    Practical knowledge of Microsoft Power BI service architecture design and administration, defining roles and security
•    Strong knowledge of data warehousing, including data source analysis and profiling, as well as Relational DBMS
•    Critical thinking capabilities and a consultative mindset
•    Excellent soft skills and readily able to communicate ideas and concepts to business sponsors and non-technology colleagues
•    Ability to thrive in a busy, high pressure, wealth management IT environment 
•    Financial Services industry experience, preferably interacting with data flowing from Broadridge Dataphile or ISM back-office applications, and trading applications
•    Experience with cloud-based tools on Azure data platform (e.g., Snowflake, ADLS, Synapse, ADF, Databricks etc.) and agile delivery methodology preferred

Education
•    Bachelor's degree in Computer Science, Software Engineering, Business Intelligence, Data Science, or related education or experience
•    A Canadian Securities Course or commensurate experience is a definite advantage

Why Apply:
Our firm is only as good as the people who work here. Our employees are exceptional because they combine in-depth expertise with enthusiasm, and empathy. From our front office talent to our colleagues behind the scenes, we have one focus: to ensure our people thrive here more than anywhere else. Are you innovative, self-driven, and client-centric?

If so, we’re ready to invest in you.

Richardson Wealth is an equal opportunity employer and committed to providing a diverse, equitable and inclusive environment. We are happy to meet your individual needs in keeping with the Canadian Charter of Rights and Freedoms and the Accessibility for Ontarians with Disabilities Act. Candidates may request accommodation at any point during the interview process.
 
We are a proud partner of Pride at Work Canada.

Other details

  • Pay Type Salary
Apply Now
Location on Google Maps
  • 100 Queens Quay E, Toronto, ON M5E 1Z2, Canada