Sr Power BI Analyst

At CWB, we strive to build value for the people who choose us every day: our people, our clients and our investors. We do this by:

• Putting people first and building relationships with intention

• Seeking out and embracing new ideas

• Believing that how we do things is as important as what we do

Senior Power BI Analyst

Put a new spin on your banking career

The overwhelming majority of our employees say CWB is a Great Place to Work®

We’re different from the big banks in the way we engage our employees - caring, responsive, and armed with an obsession for growing talent. Our reputation is powered by a people first culture that ensures our employees be and feel heard, promotes inclusivity and diverse viewpoints, and inspires collaboration and innovation.

Our employees love CWB. You’ll love it here too.

What you will do

• Collaborate with stakeholders to identify requirements for Power BI Dashboards and reports that provide actionable, data driven insights in support of achieving business objectives.

• Develop and maintain highly complex, mission critical reports, dashboards, and Power Platform applications.

• Create advanced visualizations that present complex data in ways that are easy to understand.

• Develop, test and maintain Power BI and SQL scripts that transform data from the data warehouse and other sources.

• Design and create tabular data models for high performance and scalability.

• Conduct advanced data analysis and create complex calculations using DAX.

• Design, develop and document solutions that follow best practices and meet specified requirements.

• Provide technical expertise and recommendations in assessing new project requirements.

• Troubleshoot data-related issues and drive performance tuning and optimization.

• Assist with the administration of the Power BI platform to ensure it is secure and accessible.

• Develop and build strong relationships within IT and across the lines of business.

• Perform peer code reviews to ensure adherence to design, development, and maintenance standards.

• Contribute to the design and development best practices and guidelines.

• Advocate the use of Power BI within the organization by demonstrating new features and providing training, mentorship, and support to business users.

• Participate in post-project implementation reviews or ‘lessons learned’, incorporating these lessons into appropriate process documentation, standards, templates, and checklists.

• Assist in the development of current to future state architecture roadmaps.

• Align and promote enterprise data assets principles and strategy.

• Maintain deep expertise in Power BI, emerging technologies, and best practices.

• Recommend new procedures and processes to drive desired results on diverse projects.

• Be an accountable, approachable, positive team member who is purposeful in their actions.

What you bring to this role

Education

• Bachelor’s Degree in Computer Science, Engineering, or related field.

• Certifications in Power BI or other BI technologies would be a plus.

Professional Experience

• 10 years’ experience in Business Intelligence, data modeling, enterprise

reporting, data visualizations, data analysis and dashboard development.

• 3-5 years as a Senior Power BI Developer.

• Demonstrated ability to navigate between big-picture and implementation details.

• Experience with reporting environments incorporating Microsoft SQL Server technology such as T-SQL, SSRS, SSAS, SSIS.

• Advanced SQL expertise and strong analytical skills.

• Highly proficient writing DAX

• Well versed in database technology, data warehouse design standards and tabular modeling.

• Demonstrated ability to present data in an intuitive way and familiarity with data visualization best-practices.

• Experience with Data virtualization tools like Denodo is considered an asset.

• Education/experience with the Microsoft Power Platform is considered an asset.

• Education/experience in Advanced Mathematics and/or Statistics is considered an asset.

• Education/experience in Machine Learning and/or Artificial Intelligence is considered an asset.

Personal Competencies

• Technical writing ability

• Excellent troubleshooting and problem-solving skills.

• Ability to work in a collaborative team environment.

• Ability to work with minimal supervision.

• Experience working on complex assignments requiring continuous periods of concentration, with periodic interruption.

• Strong organizational and analytical skills.

• Strong interpersonal and communication (written & verbal) skills, including technical writing ability.

Your success is our obsession! And our award-winning culture & benefits back it up.

Proudly recognized by Great Place to Work® in 2023 as one of Canada’s top 50 Best Workplaces & recipient of Waterston Human Capital’s Most Admired Corporate Culture 2023.

Wellness matters. We offer an award-winning benefits package that includes:

· Hybrid work environments

· Everyday flexibility

· Generous company-funded health coverage

· Health care spending account

· A flexible wellness program

· generous time-away options to unplug, rest & recover

Career development. We commit to our employees’ development and help them reach their professional goals with:

· Organization wide coaching services

· Mentorship

· Education support & training programs

Bring your whole self to work. Inclusion is a journey requiring practice & experience to result in a powerful outcome. Your perspective matters & voice will be heard. Find community within the CWB family in our employee represented groups.

IND-EH

As an equitable employer, CWB Financial Group is committed to providing a safe and inclusive environment where a diverse workforce thrives. You are welcomed and encouraged to bring your whole self to work. Dignity, respect and equality are non-negotiables. If you require accommodation during any part of the recruitment or selection process, please reach out.

* Position closes at 12:01am on the close date identified below.