Business Intelligence Analyst page is loaded Business Intelligence Analyst Apply locations Edmonton, AB - CWB Corporate Office time type Full time posted on Posted 2 Days Ago job requisition id R7742 At CWB , we strive to build value for the people who choose us every day: our people, our clients and our investors. Putting people first and building relationships with intention Business Intelligence Analyst CWB Corporate Put a new spin on your banking career 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. 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. 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 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. Monitor and remediate all issues with the data warehouse/data marts and reports. Perform and support daily tasks such as job scheduling, monitoring, troubleshooting and remediation. Support testing of solutions in all applicable environments. Assist with training materials, and demonstrations. 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. Education in Advanced Mathematics and/or Statistics is an asset Education or experience in Machine Learning and/or Artificial Intelligence is considered an asset Good interpersonal and communication (written & verbal) skills, including Technical writing ability. 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. Health care spending account A flexible wellness program We commit to our employees' development and help them reach their professional goals with: Education support & training programs Inclusion is a journey requiring practice & experience to result in a powerful outcome. Find community within the CWB family in our employee represented groups. #CWB Financial Group is a diversified financial services organization providing specialized service in business and personal banking, equipment financing and leasing, trust and wealth management across Canada. With more than 2,500 employees in companies with offices and branches across the country, we're helping our clients manage their money, grow their business and realize their financial potential. If you're interested in sales, support or leadership role with a growing, award-winning organization, chances are we have a challenging and rewarding opportunity of interest to you. #