Solution Developer

JOB SUMMARY   CARE Canada’s Strategic Plan, From Caring Comes Courage, sets out CARE Canada’s commitment to bring all our resources, talent, and expertise together to unlock women’s leadership for a gender-just future. It recognizes that to lead change and realize a better life for herself and her community, every woman needs to be safe, healthy and have a dignified livelihood. It also fundamentally realizes that ‘business as usual’ is no longer good enough: this Plan challenges us to reimagine how we achieve our mission, inspire Canadian investment in that mission, and transform our organization to be future-ready.    The Solution Developer will contribute to the development of reusable digital solutions that strengthen data quality, reporting, analytics, and decision support across different initiatives. It will also help identify and embed future AI-enabled capabilities where appropriate, including AI chatbots, natural-language data queries, automated report generation, report summaries, forecasting insights, anomaly detection, user guidance, data quality checks, and decision-support features. These AI capabilities may be incorporated progressively as business needs, data readiness, governance requirements, and technical feasibility are confirmed.   This role will help develop scalable digital enablement tools that can be adapted across multiple projects and business areas, supporting budgeting, forecasting, reporting, program management, data access, and operational decision-making. The role requires strong SQL Server experience, preferably Azure SQL, Power Apps/Power Platform skills, and modern development capabilities using tools such as Visual Studio, VS Code, and contemporary web frameworks. Experience with Microsoft Fabric, Power BI, and AI-assisted development practices is an asset. KEY RESPONSIBILITIES AND TASKS   1. Digital Solution Development (35%) Design, develop, and maintain reusable digital applications and workflows using Microsoft Power Platform, Power Apps, Visual Studio, VS Code, and modern development frameworks.  Develop user-friendly interfaces and business applications that improve access to operational, financial, and program information. Build and maintain APIs and integrations with organizational systems.  2. Database Administration & Data Management (30%) Design, administer, secure, and optimize SQL Server and Azure SQL databases. Develop database objects including stored procedures, views, functions, validation rules, and data models. Monitor database performance, backups, security, and availability while ensuring data integrity and compliance. 3. Reporting, Analytics & Data Integration (20%) Develop reporting solutions, dashboards, and data models supporting budgeting, forecasting, financial management, and program performance. Design and maintain ETL/ELT processes and data integration pipelines. Support Microsoft Fabric, Power BI, and related analytics platforms where applicable.  4. Innovation, AI & Continuous Improvement (10%) Identify opportunities to improve business processes through automation, reusable digital tools, and emerging technologies. Support the responsible implementation of AI-enabled capabilities including natural language queries, automated reporting, forecasting insights, data quality monitoring, and decision-support tools. Apply AI-assisted development tools to improve software quality, testing, documentation, and productivity. 5. Collaboration, Documentation & Support (5%) Collaborate with business stakeholders to gather requirements, validate solutions, and support implementation. Prepare technical documentation, deployment guides, user documentation, and operational procedures.  Participate in testing, code reviews, release management, and continuous improvement initiatives. WORKING & LIVING CONDITIONS Location: Remote, within Canada Expected percentage of travel time: Up to 10%   REQUIREMENTS Promote and maintain an organizational culture that advances gender equality, reduces power abuse and inequalities, and fosters trust and safety.  Create an environment within CARE's workplaces, programming, and communities where CARE works that is free from sexual harassment, sexual abuse and sexual exploitation and child abuse (SHEA-CA).  Ensure high standards of prevention and response measures for SHEA-CA are in place consistent with the CARE International (CI) Safeguarding Policy and Safeguarding Code of Conduct.  COMPETENCIES Employees Accountability Achieving Results Communication Solving problems Collaboration Adaptability QUALIFICATIONS REQUIRED Proven experience as a Developer, Database Administrator, or similar role with Microsoft SQL Server. Strong T-SQL skills and experience with database performance optimization.  Experience with Azure SQL or ability to learn and apply Azure SQL concepts quickly. Experience with Power Apps and familiarity with the Microsoft Power Platform.  Web development experience using technologies such as JavaScript/TypeScript, .NET, REST APIs, HTML, and CSS.  Understanding of software development lifecycle practices, including Git, testing, documentation, deployment, and release management.  Proven ability to design practical database-driven solutions, reporting workflows, and user-facing features from business requirements.  Strong analytical, troubleshooting, and problem-solving abilities.  Effective communication skills and ability to work with both technical and non-technical stakeholders.  Strong ownership and ability to work independently under tight timelines. Collaborative mindset with strong attention to detail, especially around data quality, security, and usability.  Ability to balance technical implementation with user needs, operational constraints, and long-term maintainability.  Comfort working in an evolving environment where requirements, data sources, and AI-enabled opportunities may develop over time. Commitment to responsible, secure, and practical use of technology to improve efficiency and decision-making. DESIRED Experience with Microsoft Fabric, Power BI, or other analytics and reporting platforms.  Experience with CI/CD pipelines such as Azure DevOps or GitHub Actions.  Knowledge of data governance, privacy, security, and access management best practices.  Experience with integration patterns, APIs, data movement, orchestration, and system interoperability.  Demonstrated understanding of responsible AI use in development workflows, analytics, reporting, or digital service design.  Experience designing scalable tools or platforms that can be reused across multiple projects or business areas EDUCATION & TRAINING REQUIRED Post Secondary education in a relevant area of study or equivalent combination of education and work experience