Senior Data Warehouse Developer

Calgary Homeless Foundation•Calgary, AB

About The Position

Calgary Homeless Foundation (CHF) is seeking a passionate and entrepreneurial Senior Data Warehouse Developer to join their high-impact team. This role is responsible for developing and optimizing CHF’s Data Warehouse and associated Business Intelligence assets, ensuring the integration and accuracy of organizational information. The developer will design and maintain the warehouse, including cloud-based automation, predictive modeling, and infrastructure oversight. CHF is dedicated to ending homelessness by providing strategic leadership, capacity development, and support to the sector, utilizing a comprehensive data warehouse to identify challenges and solutions. The organization values a collaborative, action-oriented approach with a focus on learning and evaluation, ensuring that people experiencing homelessness remain at the heart of their work.

Requirements

Post-secondary degree/diploma/certification in Computer Science or a related discipline (equivalent experience will also be considered)
5+ years of experience in a medium complex data warehouse environment
Hands-on Data warehousing project experience
Experience in full life cycle Business Intelligence development, implementation, tuning and support
5+ years of experience in MS SQL Server, designing, developing, Scripting queries and data processing packages
Extensive experience in relational and multi-dimensional data modeling, including multiple source systems from databases and flat files, OLAP, ROLAP
Experience in the areas of data architecture, data warehousing, and database administration
Familiarity with BI tools (e.g., Qlik Sense)
Experience in data warehouse implementation using Azure infrastructure
Places emphasis on client satisfaction and clearly communicate solutions to both technical and non-technical staff
Demonstrated ability for creativity and innovative problem solving
Able to multi-task in a dynamic environment, think clearly and calmly under pressure
Ability to work in a fast-paced, dynamic environment that requires flexibility and balancing of competing priorities

Nice To Haves

Data Warehouse certifications are an asset
Experience with Web application development is an asset

Responsibilities

Cloud-Based Extract, Transform, Load (ETL) Development & Automation
Design scalable architecture, optimize performance, lead complex data modeling
Design complex pipelines, models, and BI assets with system level impact
Lead the development, upgrade, and maintenance of the Mobile Awareness GEOINT Environment (MAGE) application, aligning with evolving business needs and ensuring seamless integration with data infrastructure
Utilize cloud tools, automation, and analytics for Infrastructure Administration & Support
Recommend implementing new tools and provide explanations of their benefits based on experience
Design and implement robust data models, including both logical and physical schemas, to support scalable analytics and reporting across the organization
Design, implement and integrate predictive analytical models with the data warehouse
Develop and optimize the corporate SQL Server–based data warehouse, ensuring high performance, scalability, and data integrity
Identify systemic problems and suggests long-term architectural solutions with flexibility for future development, tackles advanced challenges
Build strong partnerships with the Homeless Management Information System (HMIS), Data & Analytics, and other teams to resolve data quality issues, define key performance indicators (KPIs), and meet evolving reporting requirements
Leads end-to-end delivery of data initiatives
Develop and maintain critical process contingency plans to safeguard data availability and continuity of reporting services
Continuously monitor data warehouse operations, analyze performance bottlenecks, and implement optimizations to improve efficiency and reliability