Junior Solutions Consultant, Business Technology Solutions

Reports to: Product Owner, Business Technology Solutions

Language Requirement: Bilingual (English and French) – Preferred

Location: Ottawa (preferred) or remote

Employment: Full-time, 2-year term with possibility to become permanent

Hiring Salary Range: $55,000 - $65,000

Vacancy: This job posting is for a new position

Posting Date: June 11, 2026

Reply Deadline: June 26, 2026, 4:00pm ET

Organization

United Way Centraide (UWC) is Canada’s leading network of local community builders empowering people to make lasting social change in their communities. With a presence across Canada, serving over 5000 communities, our network of United Ways and Centraides tackle the most important social issue of poverty and social exclusion. Our vision is that everyone in every community has the opportunity to reach their full potential.

United Way Centraide Canada (UWCC) is the national office that provides leadership and services to UWC members across the country. Together, the staff, volunteers, and supporters of local United Ways, Centraides and UWCC form the UWC Movement.

As a Canadian Movement with a strong heritage, we value trust and integrity, volunteerism, innovation, partnership, non-partisan leadership, and diversity. It is based on these values that we improve lives and build communities.

Opportunity Profile

UWCC is seeking a motivated, early-career Junior Solutions Consultant to support the operation, enhancement, and continued expansion of its shared systems and solutions. This role contributes to UWCC’s network modernization program designed to position UWC for long-term growth and impact. Reporting into the Business Technology Solutions (BTS) team, the Junior Solutions Consultant will provide day-to-day Application Management Services (AMS) support, contribute to Salesforce enhancements, assist with data migration activities for upcoming cohorts, and help build the Data & Analytics capabilities (including Power BI dashboards) that enable an insight-driven UWC network.

An essential component of this program revolves around the development, operation, and ongoing maintenance of a shared Constituent Relationship Management (CRM) solution, its common operations centre, and the Data & Analytics products (reports, dashboards, and integrations) that surround it. The position will play an important hands-on role in keeping these capabilities healthy, accessible, and continuously improving for the network.

As an emerging member of the BTS Centre of Excellence (CoE), the Junior Solutions Consultant collaborates closely with United Ways and Centraides across the country, the Application Management Services (AMS) partner, data migration leads, and local Super Users to ensure the stable, reliable operation of the system and its integrated applications.

The successful candidate will be an analytical, curious, and detail-oriented professional with foundational experience supporting Salesforce (or a comparable CRM) environment, an eagerness to learn DevOps and data migration practices, and an interest in growing into a full Solutions Consultant role over time. This individual will be comfortable working in a dynamic multi-stakeholder environment, communicating clearly with both technical and non-technical audiences, and contributing to a collaborative, learning-oriented team.

Responsibilities

Application Management Services (AMS) Support – Tier 2 & Tier 3

• Serve as a Tier 2/Tier 3 point of contact for incoming AMS tickets, working with end users, Super-users, and the AMS partner to triage, investigate, and resolve issues in Salesforce and integrated applications within agreed SLAs.
• Demonstrate tact, professionalism, and courtesy in all communications with external partners, United Ways/Centraides, vendors, and other stakeholders.
• Reproduce, diagnose, and resolve user-reported issues across Salesforce CRM, custom configurations (CPIs, Tax Receipts, etc.), flows, and reports.
• Support the development and deployment of Salesforce enhancements – including configuration changes, flows, validation rules, page layouts, and basic Apex changes – under the guidance of the Product Owner.
• Collaborate with the AMS partner and senior team members to transfer knowledge, document recurring issues, and build internal capacity.
• Contribute to release management activities – user story testing, deployment validation, and post-release monitoring – following the team’s DevOps practices (GitHub).
• Maintain clear, timely communication with ticket requesters and Super-users, including writing user-friendly resolution notes and how-to articles.
• Identify trends across tickets and escalate systemic or high-impact issues to the Product Owner.
• Help analyze user requests to distinguish “break-fix” from enhancement work, and translate enhancement requests into clear, testable user stories for the development backlog.
• Understand, at a working level, the common and local business processes of UWCs (e.g., campaigns, pledges, tax receipts) to provide informed support and recommend practical solutions.
• Prioritize and balance a mix of support tickets, enhancement tasks, and project deliverables in a fast-paced environment.
• Build progressively deeper knowledge of the Shared CRM (Salesforce NPSP) and its integrated products (e.g., marketing automation, payment processing, document generation) to become a trusted resource for the COE.
• Provide hands-on support to onboarding cohorts of UWCs – answering AMS questions, supporting user acceptance testing, and helping new users adopt the solution.
• Follow established UWCC technical standards (Data, Architecture and Cybersecurity & Privacy) and flag exceptions or gaps to senior team members.
• Support post-release and post-onboarding user satisfaction checks, gather feedback, and feed insights back into the enhancement backlog.

Data Migration & Data & Analytics Support

• Under the super vision of Technical Consultant, BTS, support data migration activities for upcoming UWC onboarding cohorts – including data mapping, extract/transform/load (ETL) execution, data cleansing, validation, and reconciliation between legacy systems and the Shared CRM.
• Work directly with UWCs preparing to migrate – helping them understand data requirements, run validation queries, and resolve data quality issues before and after go-live.
• Support the development of Data & Analytics artifacts – including Power BI dashboards, semantic models, and underlying datasets – that surface campaign performance, donor behaviour, fundraising, and operational insights to UWCs and UWCC.
• Assist with writing Power Query (M) transformations, DAX measures, and basic SQL/SOQL queries to support reporting needs and contribute to the broader Power BI report library (e.g., EN-series specifications) following UWCC’s naming and DevOps standards.

Qualifications

• 2–3 years’ experience in a CRM administration, application support, business analyst, or junior developer role – exposure to Salesforce (NPSP a plus) and to AMS/ticketing environments highly desirable.
• Post-secondary degree or diploma in IT, business administration, data analytics, or a related field – or equivalent practical experience.
• Working knowledge of Salesforce platform fundamentals (objects, fields, flows, reports, security model); Salesforce Administrator certification or actively working towards it.
• Foundational understanding of DevOps principles (version control, release management, environments) and willingness to learn the team’s tooling (GitHub, Copado, or similar).
• Exposure to data migration concepts (ETL, data mapping, validation, reconciliation) – hands-on experience with tools such as Data Loader, Workbench, dataloader.io, or similar is an asset.
• Familiarity with Power BI (or comparable BI tools such as Tableau, Looker) – including basic experience with Power Query (M), DAX, and connecting to source systems; ability to learn UWCC’s reporting standards quickly.
• Solid business analysis skills – ability to capture requirements, document use cases, and translate user needs into clear user stories and acceptance criteria.
• Comfortable working with data – reading and writing basic SQL/SOQL queries, profiling datasets, and identifying data quality issues.
• Strong written and verbal communication skills in both English and/or French (bilingualism considered an asset).
• Strong analytical and problem-solving skills; comfort breaking down ambiguous issues into clear next steps.
• Ability to work effectively in a complex, matrixed, multi-stakeholder organization.
• Works well under pressure and able to juggle multiple priorities (support tickets, enhancements, and project tasks) simultaneously.
• Thrives in a team setting, self-motivated, with strong attention to detail and a high level of personal accountability.
• Strong curiosity and growth mindset; eager to learn Salesforce, Power BI, data migration, and DevOps practices on the job.
• Flexible to work occasional evenings and weekends as necessary (e.g., releases, data migration cutovers), as well as to travel on occasion.

Location

United Way Centraide’s national office in Ottawa, Ontario. Works in an open space environment and may work from remote locations at times.

Diversity, Equity, and Inclusion

United Way Centraide Canada hires based on merit and is strongly committed to diversity and equity within its community and to providing a welcoming and inclusive workplace. It especially welcomes applications from Black, Indigenous and People of Colour, women, persons with disabilities, people of all sexual orientations and genders, and others with the skills and knowledge to productively engage with diverse communities.

How to apply

Please send your cover letter and resume in confidence to: [email protected].

We thank everyone for applying; however, only qualified candidates will be contacted.

Pour une copie du poste en français, veuillez consulter notre site web au https://www.centraide.ca/careers/