Business Intelligence Analyst

At , 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

Business Intelligence Analyst

Role Specifications

Everyday flexibility. Hybrid work environments. Collaborative connection.

CWB Corporate

Put a new on your banking career

We’re different from the big banks in 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.

The opportunity

We are seeking a Business Intelligence Analyst to fulfill the development, enhancements and support for all data warehouse, data marts, reporting, data visualizations and dashboards for the Canadian Western Bank Financial Group.

This includes the documentation of all requirements and development details aligned to audit expectations.

As part of the Information Management team and in partnership with the business, you will utilize data from source systems to populate data assets and build attractive, intuitive and insightful information products.

If you are passionate about data analysis and find excitement in using your findings to drive business decisions, we want to hear from you!

What you will be responsible for

Assist business stakeholders in realizing their stated objectives through the use of data assets and information products that enable better and faster decisions and ensure completed solutions meet their specified requirements.

Effectively communicate and build rapport with team members and business partners.

Develop complex, mission critical reports, projects and applications.

Deliver professional quality of data analysis and ETL processes to reduce the high consequence of error.

Gather and formally document the object inventory, capturing details including data sources and data requirements to fulfill internal and external audit requirements.

Build Extract, Transform, Load processes using SAS Data Integrator based on a logical model or design.

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

Contribute to design and development standard methodologies and guidelines.

Monitor and remediate all issues with the data warehouse / data marts and reports.

Provide knowledge transfer to the other members of the development team.

Perform and support daily tasks such as job scheduling, monitoring, troubleshooting and remediation.

Support testing of solutions in all applicable environments.

Support partners in the use of information products.

Assist with training materials, and demonstrations.

Ensure issues are identified, tracked, reported on and resolved in a timely manner.

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

Perform other duties as assigned by the Information Management leaders.

What you will bring to this role

College diploma or university degree in Computer Science or related technology field.

Experience in database and / or reporting environments incorporating Microsoft SQL Server technology.

Strong query / data manipulation skills, especially utilizing Structured Query Language (SQL).

Experience in data warehouse or data mart design and development.

Experience with ETL processes / tools, SAS Data Integration studio considered a benefit.

Working knowledge of TFS or equivalent project management, development management tools.

Education in Advanced Mathematics and / or Statistics is an asset

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

Excellent troubleshooting and problem solving skills.

Ability to work in a collaborative team environment.

Ability to work with moderate supervision.

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

Strong organizational and analytical skills.

Good interpersonal and communication (written & verbal) skills, including Technical writing ability.

Why work with us?

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.

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

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

Organization wide coaching services

Mentorship

Education support & training programs

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.

LI-EH1

IND-EH

As an equitable employer, CWB Financial Group is committed to providing a safe and 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 during any part of the recruitment or selection process, please reach out.

Closing Date :

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

05 / 9 / 2024