The Calgary Homeless Foundation

Calgary Homeless Foundation (CHF) is a registered charity with a vision and mission to end homelessness in our city. As stewards of government funding, CHF invests in community and in the Calgary Homeless Serving System of Care (CHSSC) to achieve desired outcomes and impacts (population, program, system) in a cost-effective manner. Providing Systems Level Leadership to CHSSC, CHF, leverages research, data, system planning, and coordination and funding to address gaps and define best practices. CHF leads with a collective impact framework and is committed to moving forward in partnership with all orders of government, public systems, homeless-serving agencies, the private sector, faith-based communities, foundations, and all Calgarians to achieve Functional Zero homelessness in Calgary.

We are looking for passionate, adaptive, and talented people to join our agile, high-impact team.

The Position

Reporting to the Manager, Data Analytics & Business Intelligence, the Data Warehouse & Business Intelligence Developer is responsible for developing and maintaining CHF’s Data Warehouse and associated Business Intelligence assets, ensuring optimized integration and accuracy of all organizational information assets and associated systems. The Data Warehouse & Business Intelligence Developer will design, develop, maintain, optimize, and document the corporate SQL Server-based data warehouse.

Accountabilities and Deliverables

• Cloud-Based Extract, Transform, Load (ETL) Development & Automation
  • Develop, maintain, and optimize ETL pipelines using Azure Data Factory and related services, ensuring timely, reliable, and automated data ingestion and transformation.
• Mobile Awareness GEOINT Environment (MAGE) Application Development & Enhancement
  • Lead the development, upgrade, and maintenance of the MAGE application, aligning with evolving business needs and ensuring seamless integration with data infrastructure.
• Data Modeling & Architecture
  • Design and implement robust data models, including logical and physical schemas, to support scalable analytics and reporting across the organization. Design, implement, and integrate predictive analytical models with the data warehouse.
• Data Lineage & Documentation
  • Create and maintain comprehensive documentation of data flows, lineage, and dependencies to support transparency, governance, and troubleshooting.
• SQL Server Data Warehouse Management
  • Develop and optimize the corporate SQL Server–based data warehouse, ensuring high performance, scalability, and data integrity.
• Data Quality & Validation
  • Implement rigorous testing and validation protocols to ensure all information assets are accurate, complete, and ready for timely reporting.
• Cross-Team Collaboration
  • 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.
• Infrastructure Administration & Support
  • Oversee the administration and upkeep of data warehouse and Business Intelligence (BI) servers, tools, and jobs, ensuring high availability and performance.
• Contingency Planning & Risk Mitigation
  • Develop and maintain critical process contingency plans to safeguard data availability and continuity of reporting services.
• Performance Monitoring & Optimization
  • Continuously monitor data warehouse operations, analyze performance bottlenecks, and implement optimizations to improve efficiency and reliability.

Education and Experience

• Post-secondary degree/diploma/certification in Computer Science or a related discipline. Equivalent experience will also be considered. Data Warehouse certifications are an asset
• 2+ years of experience in a medium complex data warehouse environment, hands-on Data warehousing project experience, and experience in full life cycle Business Intelligence development, implementation, tuning, and support
• 2+ 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, and 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
• Experience with Web application development is an asset
• Places emphasis on client satisfaction and clearly communicates solutions to both technical and non-technical staff.
• Demonstrated ability for creativity and innovative problem-solving
• Able to multitask 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