Senior Data Warehouse Developer

Position

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

• 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
• 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 logical and physical schemas, to support scalable analytics and reporting across the organization
  • Design, implement and integrate predictive analytical models with the data warehouse
• 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 suggest long‑term architectural solutions with flexibility for future development, tackle advanced challenges
• Cross‑Team Collaboration
  • Build strong partnerships with HMIS, Data & Analytics, and other teams to resolve data quality issues, define KPIs, and meet evolving reporting requirements
  • Lead 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

• Post‑secondary degree/diploma/certification in Computer Science or a related discipline
• Equivalent experience considered; data warehouse certifications are an asset
• 5+ years in a medium‑complex data warehouse environment, hands‑on data warehousing projects, full lifecycle Business Intelligence development, implementation, tuning and support
• 5+ years 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 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
• Client‑focused communication, clear articulations of solutions to technical and non‑technical staff
• Demonstrated creativity and innovative problem‑solving
• Ability to multi‑task in a dynamic environment, think clearly and calmly under pressure
• Adaptive to fast‑paced, dynamic environments requiring flexibility and balanced priorities

• Taking Accountability: share purpose and ambition, follow through on commitments, identify obstacles, admit mistakes, take ownership of solutions
• Fostering a Growth Mindset: seek new information, treat mistakes as learning opportunities, seek feedback, accept ambiguity, act proactively
• Empowering Others to Succeed: articulate expectations, meet regularly with stakeholders to ensure success, eliminate constraints
• Collaborating for Greater Impact: proactively collaborate, incorporate input, respect strengths, encourage solutions, share difficult perspectives, be willing to change perspective