Senior Data Engineer

The BC Cancer Foundation is at the forefront of a transformative era in cancer research and care.

As the fundraising partner of BC Cancer, we are driving bold initiatives that inspire hope and save lives. Cancer is the largest health challenge globally, and we are mobilizing communities, partners and collaborators across British Columbia to accelerate wide-impact solutions.

With a team of over 90 staff across five sites, more than $110 million in annual revenue, and over 80,000 donors annually, we are one of the province’s largest non-profit organizations. We have a purpose-driven, high-performing culture – fuelled by talent, data and technology to accelerate progress and shape the future of cancer care.

We are a passionate, professional and positive team committed to advancing cancer research and supporting patients and families throughout their journey.

Based in Vancouver, BC, this is a hybrid technical role combining core Data Engineering (building our Data Lakehouse and pipelines) with Business Process Automation (building Power Apps/Automate solutions) to modernize our fundraising operations.

Reporting to the Director, Data Platforms and Analytics, responsibilities of the Senior Data Engineer will include:

• Architect, design, and implement scalable cloud data solutions using Microsoft Fabric/Snowflake for an enterprise-grade Data Lakehouse.
• Lead the implementation and architectural rollout of the Data Platform, including validating architectural decisions against PHSA’s security and infrastructure constraints.
• Partner with the analytics lead to design semantic models and optimize Power BI performance, including Direct Lake or Direct Query performance tuning.
• Own cost guardrails and optimization including warehouse sizing, caching, job scheduling, capacity limits, and monthly budgets and alerts.
• Stay informed on emerging technologies, proposing innovative enhancements to the data platform.

• Develop and maintain robust ETL/ELT pipelines integrating diverse data sources such as Blackbaud’s Raiser's Edge, Financial Edge, Google Analytics, and various marketing platforms.
• Develop and maintain API integrations with BCCF’s CRM (Raiser’s Edge) and other systems. To be leveraged for data pipelines as well as process automation.
• Optimize, troubleshoot, and maintain data pipelines to ensure performance, reliability, and cost-efficiency.
• Design and build low-code business applications using Microsoft Power Apps (Canvas/Model-driven) to replace manual Excel workflows and capture clean data at the source.
• Build automations with Power Automate, Azure Functions, or Logic Apps to operationalize data-driven workflows where appropriate.

• Establish, communicate, and enforce best practices for governance and security, including quality assurance, data lineage and cataloging, sensitivity labels, data retention, access recertification, row-level security, and column masking for PII.

• Collaborate closely with stakeholders and business analysts to define and document clear technical and functional requirements.
• Produce comprehensive documentation and lead knowledge transfer sessions.
• Mentor junior team members, fostering a culture of continuous learning and technical excellence.

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field, or equivalent experience.
• 7+ years of proven experience in data engineering, preferably 5+ within cloud environments (strong preference for Azure/Fabric ecosystem).
• Demonstrated success implementing large-scale data platforms (experience with Microsoft Fabric, Azure Synapse or Snowflake is strongly preferred).
• Demonstrated experience implementing medallion and dimensional models at scale.
• Extensive expertise in data modeling, pipeline architecture, and ETL/ELT processes.
• Experience integrating APIs and managing complex data ingestion workflows.
• Experience with Power Platform (Power Apps/Power Automate) in an enterprise context is highly…