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 holding true to the values that guide us. We put people first and build relationships with intention. We seek out and embrace new ideas, knowing that better is always possible. We believe that how we do things is as important as what we do. And we harness the power of inclusion. Our culture is who we are and how we show up - as individuals and as a team - to accomplish our strategy.
Flexible Work Arrangements (FWA)
Hybrid Work Environment
CWB is on a mission to become the best full-service bank for business owners of Canada.
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!
Assist with managing resource time and costs associated with after-hours support ensuring alignment to approved budget.
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.
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.
Experience in visual design and development utilizing Microsoft Power BI, Tableau or similar software.
Demonstrated ability to communicate data in an intuitive way and familiarity with data visualization best-practices.
Understanding of OLAP/multi-dimensional data organization techniques and one or more related languages (e.g. DAX; VizQL).
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.
Ignite your career. Apply with CWB today.
Winners of Canada’s Most Admired Corporate Culture 2020
& recognized as one of 50 Best Workplaces in Canada by Great Places to Work
Your voice matters . Help us shape our voice around important social & cultural matters.
The opportunity to make a difference . Put your mark on the CWB landscape.
Flexible work arrangements . Make work make sense for you. Hybrid work environment.
Physical health and mental fitness are priorities. Generous time away to practice self-care and family-care with 100% company paid benefit & support programs.
Community giving. Drive economic prosperity in your community. Get involved. Volunteer. Fundraise. All with CWB support.
Bring your whole self to work. Inclusion is a journey requiring practice & experience that results in a powerful outcome.
Innovation. Learn. Grow. Enhance. At CWB we play to win. When we fail, we fail forward.
Connection. Join, participate, lead an employee regulated group (ERG). Find a community within the CWB family.
Organization wide coaching services. Strategic career design is something we work hard to deliver for all employees.
Recognition. Peer to peer recognition program. Both “in the moment” and monumental!
Financial rewards . Yup! We pay you too. Base plus performance incentives.
Retirement investment strategy. You can’t work forever, so we have a RRSP contribution & matching program with financial advisors at the ready to help you make the most of your wealth.
Company ownership. The knowledge and opportunity to impact the bottom line and be rewarded for it - every day, with our employee share purchase plan.
Bring you. All of you. Feminist. First Nations band member. Gay rights activist. Sign language speaker. Labels don’t matter here, but your perspective does.
All applicants are welcome, and we expressly encourage applicants to apply who identify as women, persons with visible and invisible disabilities (including physical, mental, sensory, learning impairment, etc.), Indigenous peoples (including First Nations, Metis and Inuit), LGBTQ2S+ and/or racialized persons. We are specifically seeking diversity in this role, because at CWB we believe that inclusion has power, and we’re looking for some unique perspectives to add to this area of our business. We have a culture that thrives on idea-sharing, collaboration, respect, caring and camaraderie. If you have a voice to add to the conversation, we’d love you to apply.
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.
- P osition closes at 12:01am on the close date identified below.