Senior Specialist, Database Developer

ABOUT US

SickKids Foundation with over 50 years of philanthropic impact is Canadas largest charitable funder of child health research learning and care raising over $200 million last year. As a national charity SickKids Foundation invests in national and international initiatives to benefit children in Canada and around the world. As the fundraising partner to The Hospital for Sick Children (SickKids) we are aligned in supporting Precision Child Health (PCH) the future of tailoring medicine to each childs unique traits so SickKids can diagnose faster treat smarter and predict better.

We are driven by our core values of integrity collaboration excellence innovation and inclusion with goals of delivering a superior donor experience investing in our people and culture driving innovative and sustainable fundraising and disrupting the market through data and technology.

SickKids Foundation is committed to an inclusive culture by embedding equity diversity and inclusion in our policies practices and behaviours. We aim to build awareness and skills in this area both internally and with our partners. Our commitment extends to creating a safe positive work environment. For details on our Equity Diversity & Inclusion commitment please click here.

Were committed to attracting and retaining passionate individuals to help create a healthier future. Thats why SickKids Foundation is looking for a new Database Developer.

Description of the Position

We are looking for a skilled and motivated Database Developer to join our Data Platforms & Integrations team. This role is ideal for someone who is passionate about building reliable data solutions improving data quality administering modern database environments developing robust ETL/ELT processes and helping teams access trusted information through reliable reporting and analytics solutions.

The Database Developer will design develop administer optimize and support database ETL/ELT integration and reporting solutions across the Foundations enterprise systems.

This role supports on-premises and cloud database environments enterprise data pipelines reporting platforms integrations and API-based data services. The successful candidate will work with partners across CRM Digital Marketing Technology Business Intelligence & Analytics Infrastructure Cybersecurity and Enterprise Architecture to ensure data is secure reliable well-structured governed and available for operational and strategic use.

Key Responsibilities

Database Development and Administration

• Develop maintain and optimize database objects including tables views stored procedures functions indexes and data models.
• Administer and support on-premises and cloud-based database environments including Microsoft Azure data services.
• Support database provisioning configuration maintenance monitoring backup and recovery performance tuning security and access management.
• Ensure database solutions are reliable secure scalable performant and aligned with enterprise architecture and data governance standards.

ETL/ELT Data Integration and Pipelines

• Design develop test deploy monitor and support ETL/ELT processes across enterprise systems.
• Develop and maintain data pipelines using SSIS Azure Data Factory and related integration technologies.
• Build automated data movement processes that support operational reporting analytics CRM marketing technology digital platforms fundraising systems and enterprise applications.
• Create reusable and maintainable integration patterns that reduce manual data handling point-to-point solutions inconsistent transformations and operational risk.
• Support data extraction transformation cleansing validation reconciliation loading exception handling and source-to-target mapping.
• Troubleshoot pipeline failures data latency transformation errors data quality issues and performance bottlenecks.
• Document ETL/ELT workflows data mappings transformation rules dependencies and support procedures.

Reporting and Analytics Enablement

• Develop maintain and optimize operational analytical and management reports using SSRS Power BI Tableau and related tools.
• Translate business reporting needs into accurate secure user-friendly reports dashboards paginated reports datasets and extracts.
• Support report data models semantic layers stored procedures queries refresh schedules subscriptions and access permissions.
• Troubleshoot report performance data accuracy refresh visualization and user access issues.
• Promote reporting standards that support data quality consistency security accessibility and maintainability.

Data Quality Governance Security and Collaboration

• Partner with CRM Data Governance BI Cybersecurity and Infrastructure teams to support data quality lineage privacy security and system-of-record integrity.
• Ensure database ETL/ELT reporting and integration solutions comply with privacy security and regulatory requirements.
• Monitor and improve database performance pipeline reliability report performance throughput refresh schedules and data quality.
• Work with delivery squads project teams vendors and business stakeholders to understand requirements and deliver practical well-documented solutions.
• Collaborate with teams supporting CRM and Salesforce platform initiatives where data integrations reporting or platform data structures are involved.

Qualifications

While we know that for any job posting no one candidate will possess the qualifications being sought in equal measure below is an outline of the qualifications we believe are important for a candidate to bring to the position or for the successful candidate to develop while in the role:

• Bachelors degree or diploma in Information Technology Computer Science Data Management Engineering or a related field or equivalent professional experience.
• Minimum of 3 to 5 years of experience in database development database administration ETL/ELT development data integration data engineering reporting or a related technical role.
• Strong SQL development skills including stored procedures views indexing query optimization performance tuning and data modelling.
• Hands-on experience designing developing testing deploying monitoring and supporting ETL/ELT processes.
• Experience with SSIS and Azure Data Factory is strongly preferred.
• Experience developing and supporting data pipelines source-to-target mappings transformation logic data cleansing validation reconciliation exception handling and automated data loads.
• Experience developing reports dashboards paginated reports datasets extracts or reporting solutions using SSRS Power BI and/or Tableau.
• Experience administering on-premises and cloud-based database environments including backup and recovery monitoring security access management maintenance and optimization.
• Experience with Microsoft Azure services including Azure SQL Database Azure SQL Managed Instance Azure Data Factory Azure Storage Azure Synapse Analytics or related Azure data and integration services.
• Familiarity with APIs integration platforms scheduled data loads cloud-based data movement enterprise data platforms data warehouses data marts data quality and data governance.
• Familiarity with CRM systems fundraising platforms marketing technology analytics platforms or non-profit environments is considered an asset.
• Salesforce platform experience is considered a strong asset.
• Strong troubleshooting problem-solving documentation communication and stakeholder engagement skills.
• Commitment to building secure reliable scalable well-documented and maintainable database ETL/ELT reporting and integration solutions.

We are looking for a detail-oriented database professional who enjoys solving complex data problems building reliable ETL/ELT processes supporting database environments and creating practical reporting and data solutions that help teams work more effectively.

You are curious collaborative and motivated by meaningful work. You care about data quality reliability security performance and usability and you are excited by the opportunity to contribute to a globally recognized organization that is changing the future of child health.

Total Compensation Package

Expected Hiring Salary Range: $82064 - 102582; with the ability to progress to a maximum of $117970 with demonstrated experience and proficiency. To ensure fair and equitable pay at SickKids Foundation placement on the salary range will be based on your years of experience skills and qualifications relevant to the Analyst People Systems and Analytics.

To help you lead in the fight for kids health and to support your health wellness and career growth in addition to competitive compensation we offer a comprehensive benefit package (includes a flex benefit plan) tuition reimbursement flexible work arrangements pension plan and birth parent/parental top up to name a few!

Position Status: Permanent Full-Time;

Hours: Hybrid work model: minimum two days per week in-office (Tuesday and Wednesday).

Available To: Internal and External Candidates

Available: Immediately; this posting is for an existing vacancy.

Date Posted: May 25 2026

Applications will be reviewed on an ongoing basis. We encourage interested candidates to apply early.

How to apply: Please apply on-line by visiting our website: note that automated tools including artificial intelligence may be used to support the pre-screening of applications as part of our recruitment process.

SickKids Foundation is committed to its people and the talents capabilities and perspectives they bring to our mission. We live that commitment by being open and accessible to all by valuing and respecting every individual and by equally supporting every employee. As an organization proud to have joined the BlackNorth Initiatives CEO pledge we uphold our commitment by inviting and encouraging individuals from diverse lived experiences from Black Indigenous communities of colour people with disabilities 2SLGBTQIA community and all candidates who may contribute to the further diversification of the Foundations community.

Candidates who require accommodation during the recruitment process should contact the People & Culture team at:

Required Experience:

Senior IC

Employment Type : Full-Time
Experience: years
Vacancy: 1