calgary
Senior Data Warehouse Developer
Calgary, Alberta · Senior
Sponsorship not specifiedDetected 20 days ago
SQLAzureData AnalysisData EngineeringLeadershipCommunicationCollaborationProblem SolvingWarehouse Management System
About the role
- 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.
- At CHF our approach is grounded in purpose, collaboration, and accountability.
Responsibilities
- Design scalable architecture, optimizs performance, lead complex data modelling
- Design complex pipelines, models, and BI assets with system level impact
- 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
- 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.
- The Senior Data Warehouse Developer will design, maintain the warehouse including cloud based automation, predictive modelling and infrastructure oversight.
Requirements
- Ability to work in a fast-paced, dynamic environment that requires flexibility and balancing of competing priorities
- The ideal candidate will be expected to demonstrate and grow the following competencies:
Nice to have
- 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)
Skills
- Accountability and Deliverables
- Key activities include:
- Cloud-Based Extract, Transform, Load (ETL) Development & Automation
- Mobile Awareness GEOINT Environment (MAGE) Application Development & Enhancement
- Infrastructure Administration & Support
- Utilize cloud tools, automation, and analytics
- Recommend implementing new tools and provide explanations of their benefits based on experience
Benefits
- 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.
- We are looking for passionate, entrepreneurial, and talented people to join our action-oriented, high impact team.
Company info
- Our culture values transparency, inclusion, and resilience.
- Interviews and development conversations focus on real examples of how we act when it's hard, because that's when our values matter most.
Apply directly at calgary →Create a free account for alerts like thisView calgary immigration profile
This listing is sourced directly from calgary's careers page and normalized into a canonical job model.