Data Warehouse Administrator

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.

Data Warehouse Administrator

Location: Edmonton is a preference.

Role Specifications

Everyday flexibility. Hybrid work environments. Collaborative connection.

It’s a new world, and we’re learning to embrace it People are changing the way they work and connect, so we’re changing too. Join a team that lets you impact the future, grow to your fullest potential, be your authentic self, and connect with clients and colleagues in meaningful ways.

CWB is a bank build for business owners

Canadian Western Bank (CWB) is the only
_full-service bank_ in Canada with a strategic focus to meet the unique financial needs of businesses and their owners. Our teams take a
_ relationship-based_ approach to deliver a uniquely
_proactive client experience_ through highly
_personalized service, specialized expertise, customized solutions, and faster response times. _We provide full-service business and personal banking,
_nation-wide specialized financing_ in targeted industries, comprehensive wealth management offerings, and trust services. Our highly engaged teams operate within a
_client-centric, collaborative, and change-ready culture, _with a core focus to achieve our vision to become the best full-service bank for business owners in Canada as we continue to transform our capabilities.

Bring you. All of you. Caregiver. Ally. Outdoor enthusiast. Indigenous community partner. Foodie. Neurodivergent perspective. Sports fan. Human rights activist. Labels don’t matter here, but your perspective does.

_inclusion has power_, and we’re always looking for unique perspectives to add to our teams. 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. All applicants are considered as part of an equitable and fair selection process.

The opportunity

The Data Warehouse Administrator provides operational enhancements, maintenance and support for the SAS server environments at Canadian Western Bank. This position provides expertise in performing software maintenance, installation and configuration. Utilizes system administration skills to maintain both production and non-production environments. Documents all configuration details of data warehouse installation and setup. The SAS Administrator serves as liaison to the IS infrastructure teams and business partners to ensure appropriate delivery of technology solutions in accordance with business requirements and objectives. The Data Warehouse Administrator also ensures the platforms are positioned for compliance with IS policies and standards and agreed upon service levels. This role will be the primary administrator to support the SAS AML environment, with support from the full admin team.

Key deliverables

FINANCIAL PILLAR- Assist with managing resource time and costs associated with after-hours support ensuring alignment to approved budget.

CLIENT PILLAR- Assist business stakeholders in realizing their stated objectives through the use of data assets and information products that enable better and faster decisions.- Ensure completed solutions meet specified requirements of stakeholders.- Effectively communicate and build rapport with team members and business stakeholders.

SUPPORT PILLAR- Provide administrative support for the AML (anti-money laundering) environments.- Assist in the configuration of the Operating Systems (including Windows, Unix / Linux) with respect to the requirements of the SAS, Denodo and Data Lakehouse (DLH) ecosystem.- Contributes to the best practices and guidelines for usage of the SAS, Denodo and DLH products.- Ensure proper documentation is maintained for all processes.- Reviewing server and desktop pre-installation checklists to ensure it contains all requirements for infrastructure, operating systems and system user permission/access.- Support software downloads for SAS, Denodo and DLH Binaries- Install and configure software, documenting all details for the Build-Book.- Review installation Build-Book and revise as required.- Install and configure non-production and production server SAS, Denodo and DLH software, and troubleshooting including all remediation required for successful completion of software install.- Configure database access engines for all data sources and validate access engine configurations.- Perform health-checks & monitoring post migration and identify any required remediation efforts.- D