Senior Data Warehouse Developer

Calgary Homeless Foundation (CHF)

Calgary Homeless Foundation guides the fight against homelessness. Fueled by this purpose, we envision the day when homelessness is rare, brief, and non-recurring — perhaps an episode in someone's life, but never a condition that defines it. Working in alignment with governments and collaboratively with service providers and community partners, we help translate complex system needs into coordinated, efficient ground-level action that maximizes the impact of every resource and creates lasting pathways out of homelessness.

We are uniquely positioned to observe the many challenges facing our city and strengthen the entire sector through strategic leadership, forward-thinking capacity development, and hands-on, day-to-day support.

Our comprehensive data warehouse reveals the full picture of homelessness in our community, enabling us to anticipate challenges and identify effective solutions. And we unite diverse stakeholders around shared goals and help address complex situations that no single agency can solve alone.

Our collective approach and focus on learning and evaluation equip us to address homelessness across our city while keeping the people experiencing it at the heart of our work. When the system works better together, more people find their way home.

We are looking for passionate, entrepreneurial, and talented people to join our action-oriented, high impact team.

The Position

Reporting to the Manager, Data Analytics & Business Intelligence, the Senior Data Warehouse Developer is responsible for developing and optimising CHF’s Data Warehouse, and associated Business Intelligence assets, ensuring optimized integration and accuracy of all organizational information assets and associated systems. The Senior Data Warehouse Developer will design, maintain the warehouse including cloud based automation, predictive modelling and infrastructure oversight.

Our Staff

CHF staff are action-oriented individuals who are catalytic leaders, courageous collaborators, evidence inspired, and vision dedicated. They choose to bring their professional expertise and personal talents to the non-profit sector, to add value to the full community. They work cooperatively with others in a strong team environment; demonstrate flexibility in organizing and undertaking work; show a high degree of initiative, discernment and resourcefulness; exhibit excellent communication and relational skills; demonstrate thoughtfulness and intelligence in decision making; and are focused on creating positive outcomes for persons experiencing homelessness.

How we work here:

At CHF our approach is grounded in purpose, collaboration, and accountability. We believe that how we work together matters as much as what we achieve.

Here’s what you can expect from us—and what we expect from you:

• Ownership Under Pressure: We take responsibility for outcomes, even when challenges arise.

• Constructive Feedback: We give and receive feedback openly, with the goal of learning and improving.

• Pace with Purpose: We move quickly when needed, without sacrificing quality or integrity.

• Healthy Disagreement: We challenge ideas respectfully and invite discussion to make decisions stronger.

• Shared Understanding: Expertise means building clarity for others, not being “right by default.”

Our culture values transparency, inclusion, and resilience. We name real pressures – external and internal - and navigate them together. Interviews and development conversations focus on real examples of how we act when it’s hard, because that’s when our values matter most.

Accountability and Deliverables

Key activities include:

• Cloud-Based Extract, Transform, Load (ETL) Development & Automation
  • Design scalable architecture, optimizs performance, lead complex data modelling
  • Design complex pipelines, models, and BI assets with system level impact
    

• 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
• Infrastructure Administration & Support
  • Utilize cloud tools, automation, and analytics
  • Recommend implementing new tools and provide explanations of their benefits based on experience
• Data Modeling & Architecture
  • 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 warehous
• 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
  • Identify systemic problems and suggests long-term architectural solutions with flexibility for future development, tackles advanced challenges
• 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
  • Leads end-to-end delivery of data initiatives
• 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

The ideal candidate will have the following qualifications:

• Post-secondary degree/diploma/certification in Computer Science or a related discipline
• Equivalent experience will also be considered. Data Warehouse certifications are an asset
• 5+ 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
• 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
• Experience with Web application development is an asset
• 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

Gneral Competency Requirements

The ideal candidate will be expected to demonstrate and grow the following competencies:

Taking Accountability for Guiding the Fight Against Homelessness by:

• Regularly sharing our Purpose and Ambition and make decisions that move us toward
• Following through on my commitments to earn the trust of my colleagues and community partners
• Identifying obstacles, admitting my mistakes, and taking ownership of solutions
  

Fostering a Growth Mindset by:

• Regularly seek new information and leveraging data to inform my solutions and decisions
• Treating mistakes as learning opportunities and focusing myself & others on improving future results
• Considering how I may have contributed to problems and regularly seeking feedback to discover how I can improve
• Accepting ambiguity and taking action to move us in the direction of our goals without waiting for perfect information

Empowering Others to Succeed by:

• Articulating and agreeing upon clear expectations and desired results
• Meeting regularly with my key internal and external stakeholders to ensure they have what they need from me to succeed
• Eliminating organizational constraints that hold people back

Collaborating for Greater Impact by:

• Proactively collaborating with others and incorporating their input into soutions
• Respecting the unique strengths and agency of others by encouraging them to propose solutions and make decisions
• Having the courage to share difficult perspectives directly, respectfully, and in a timely manner, and encouraging others to do the same
• Being willing to change my perspective when presented with new information