RQ08841 - Solutions Designer - CRM

html Job Description

Job Title: Solutions Designer - CRM – Senior

Job ID: RQ08841

Closing Date/Time: 2025-05-15, 4:30 p.m.

Office Location: Ministry of Natural Resources and Forestry, Toronto, Guelph or Peterborough

Rate: Up to CAD $120/hr

Description

To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as-needed basis.

Responsibilities

• Undertakes the design of hosting technology solutions based on the client's service specifications, standards, policies, best practices, and cost models to meet client CRM application business requirements and project/initiative deliverables.

General Skills

• Knowledge of CRM applications, operating systems, environments, database technologies, programming languages, and communication protocols.
• Knowledge of related best practices, OPS directory/messaging standards, standard facilities architecture management, facility service delivery processes, infrastructures policies, procedures, and direction, cost models, and procurement processes.
• Ability to gather client business requirements; corporate I&IT information mandates, client information technology strategic plans, environment, and standards.
• Ability to participate in the development of solutions and provide advice on short/long-term CRM solution service development activities.
• Knowledge of leading-edge technologies design criteria, security and recovery procedures, preparation of technical specifications for installation, testing, and performance of integrated, multi-services systems; assess performance and capacity of existing systems, make recommendations for improving performance, and develop technical documentation.
• Experience planning, migrating, implementing, and sustaining large complex system development projects.
• Knowledge of technology developments, trends, and new products to evaluate application to client short and long-term technology requirements.
• Basic knowledge of project management methodology (e.g., PMBOK), analytical tools, and processes.
• Conceptual and analytical skills to assess and evaluate client needs and conduct cost/benefit analyses for new technology requirements in planning and designing solutions.
• Experience designing and developing large, complex CRM applications.
• Experience with systems evaluation to assess conditions, technical performance, and capacity of existing systems and determine the need and feasibility of expansion, renovation, or replacement.
• Excellent analytical, problem-solving, and decision-making skills, verbal and written communication skills, interpersonal skills, and negotiation skills.
• A team player with a track record for meeting deadlines.

Skills, Experience, and Skill Set Requirements General Skills:

• Experience in programming and analysis; specialized CRM software package support at the specified experience level.
• Ability to collaborate with IT Professionals throughout the Software Development Life Cycle.
• Experience in structured methodologies for the development, design, implementation, and maintenance of applications.
• Experience in design, code, test, debug, and document applications.
• Experience in the use of object and/or third-generation language development tools.
• Experience in one or more programming languages.
• Experience in application design, latest design patterns, deployment, and troubleshooting.
• Experience with relational and hierarchical database technologies.
• Experience in the use of information retrieval packages using query languages.
• Experience with one or more communications protocols.
• Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts.
• Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.
• A team player with a track record for meeting deadlines.

CRM Software Development Skills:

• Knowledge and experience with specific CRM software and anticipated future releases, high availability solution design, and implementation.
• Knowledge and experience with specific CRM enterprise architecture methodologies, design standards, and tools.
• Experience with middleware and gateways.
• Expertise in specific tools for CRM software development.

Desirable Skills:

• Knowledge and experience with programming Internet-ready applications.
• Knowledge and experience in rapid application development (RAD) methodologies.
• Knowledge and understanding of Information Management principles, concepts, policies, and practices.
• Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, and debugging.
• Ability to provide post-implementation support and resolve any post-implementation technical issues.
• Experience conducting design walkthrough sessions with the project team.
• Knowledge and understanding of Ontarians with Disability Act (ODA) and related regulations and standards.
• Ability to provide user and system documentation as required.
• A team player with a track record for meeting deadlines.
• Knowledge of integrated networking technologies, mainframe, midrange server, enterprise storage and SAN, and personal computer system technologies.
• Knowledge of related best practices, OPS directory/messaging standards, standard facilities infrastructure/architecture management, facility service delivery processes, infrastructures policies, procedures, and direction, cost models, and procurement processes.
• Knowledge of leading-edge technologies design criteria, security and recovery procedures, preparation of technical specifications for installation, testing, and performance of integrated, multi-services systems; assess performance and capacity of existing systems, make recommendations for improving performance, and develop technical documentation.

Salesforce-Specific Skills:

• Able to quickly integrate new concepts and easily understand business needs.
• Evaluating which Salesforce components and other technology products and frameworks to use based on cost-benefit analysis, risk management, and market research.
• Experience with building Salesforce solutions based on user stories and low-level designs.
• Adhere to defined coding standards and develop well-structured, maintainable, and easy-to-understand code.
• Strong experience delivering products in Agile/Scrum mode.
• Map Salesforce capabilities, features, and best practices against business and technical requirements by performing fit-gap analysis against Salesforce cloud, service, community, available tools within AppExchange, and Salesforce Platform.
• Design, develop, implement, configure, maintain, administer, and integrate solutions on Salesforce Lightning Cloud platform (LWC).
• Hands-on knowledge of Apex, Lightning, VisualForce, Salesforce APIs, data loaders, SOQL, SOSL, and web services.
• Strong understanding of Salesforce security model including sharing rules, roles, profiles, sharing settings, etc.
• Build integrations between Salesforce and external applications using REST, SOAP APIs, Auth, and Single Sign-On.
• Migrate changes from development to test to production environment(s) using CI technologies like Salesforce DX, Jenkins, and ANT.
• Experience with deployment tools such as GitLab, Jenkins, etc.

Must Have:

• 5+ years of Salesforce development experience in Public Sector Foundation and Sales Cloud with a solid understanding of when Salesforce configuration options are desirable over custom code.
• Certified Salesforce Platform Developer I or equivalent experience.
• Salesforce Certified OmniStudio Developer.
• Salesforce Certified Experience Cloud Consultant.
• Salesforce Certified Administrator.

Knowledge Transfer Requirements

• Knowledge transfer is expected to occur through the duration of the assignment through regular meetings, touchpoints, and working sessions with LRC staff.
• All design, development, and artifacts, including all relevant and complete documents, must be transferred to the ministry in the designated repositories provided.

Evaluation Criteria

1. Salesforce Experience: 30 points (weighted score)
   • 5+ years experience (including recent experience) solutioning and hands-on configuring in Salesforce.
   • Salesforce Certified Platform Developer I.
   • Salesforce Certified OmniStudio Developer.
   • Salesforce Certified Experience Cloud Consultant.
   • Salesforce Certified Administrator.
2. Design, Analysis, Development, Configuration, and Deployment: 30 points (weighted score)
   • Demonstrated experience supporting, developing, maintaining, and configuring Salesforce solutions.
   • Hands-on experience configuring and troubleshooting issues in Salesforce implementation and its integration with subsidiary systems in Development and Production environments.
   • Demonstrated experience configuring and integrating Salesforce with other applications using web services or other mechanisms.
   • Demonstrated experience designing and supporting the development of prototypes and proof of concepts.
   • Demonstrated experience conducting root cause analysis to troubleshoot and resolve defects/incidents.
   • Demonstrated experience documenting build books, working with staff on actual implementation, and documenting performance measures of the new environments.
   • Experience conducting fit/gap analysis between high-level requirements and Salesforce Public Sector capabilities.
   • Experience conducting diagnostics and determining methods to help incident management.
   • Experience implementing ODA-compliant solutions.
3. Communication and Documentation: 25 points (weighted score)
   • Excellent analytical, problem-solving, and decision-making skills.
   • Excellent communication skills, both written and verbal.
   • Experience reporting progress on deliverables to team, project leads, and management, including proactively raising risks/issues with migrations.
   • Demonstrated experience working with clients and technical teams to ensure effective resolution of defects and management of change requests.
   • Experience documenting processes and technical designs and updating build books.
   • Experience engaging with the project team to develop techniques to expedite implementation; works closely with Project Manager and lead architect and participates in the planning and design process.
   • Experience providing estimates for proposed features/enhancements and reviewing the estimates from other team members for completeness and accuracy.
4. Agile Experience: 10 points (weighted score)
   • Experience with Agile Scrum methodologies.
   • Demonstrated experience with agile sprint management, bug tracking, and testing life cycle management using Azure DevOps.
   • Thorough understanding of SDLC, specifically DEV processes in agile development environments.
5. Public Sector Experience: 5 points (weighted score)
   • Previous experience working in Government or Public Sector organizations.