Propose an IT Integrated Communication Workflow Solution/Programme
Help design and implement a communication tool using Microsoft 365.
Overview
Help design and implement a communication tool using Microsoft 365.
You have:
- Proficiency in using Microsoft Lists, SharePoint, Power Automate, and Power BI.
- Experience in integrating Salesforce with communication tools for email tracking and analytics.
- Strong understanding of workflow creation and approval processes using Power Automate or similar tools.
- Ability to engage with teams to understand and translate organizational needs into technical solutions.
- Ability to troubleshoot and resolve issues effectively during the development and implementation process.
- Open to innovative solutions using free or cost-effective software while meeting organizational requirements.
Contract
This is a UNV contract. More about UNV contracts.
We are looking for a skilled Online Volunteer who can help us design and implement a tool using Microsoft 365 (including Microsoft Lists, SharePoint, Power Automate, and Power BI). If possible the tool will be integrated with Salesforce to track email marketing campaigns.
This tool will support the planning, scheduling, and approval process (by at least 3 person) for communication products such as social media posts, website content, and events. It will also enable us to track social media metrics and email campaign performance, ensuring greater efficiency in managing our communication workflows.
In particular, the Online Volunteer, who under the guidance of the External Relations Officer and in close collaboration with the IT and communications team will support us by producing one software communication tool solution and assigned with the following tasks:
- Understand WHO needs for the tool to be developed according to it. To better understand the needs and ensure the requirements is clear the Online Volunteer will have close meetings with WHO IT and Comms teams.
- Develop one software communication tool solution that includes the following key features.
Key Features of the proposed Tool/Solution
Communication Planning and Scheduling: • Microsoft Lists or SharePoint can be used to create a central communication planning tool. Or any other free software. • Users can create and manage communication plans, assign tasks to responsible persons, and set deadlines for social media posts, website updates, events, and other communication products. • Columns could include fields for the type of content (e.g., social media, press release, website), assigned person, deadlines, donors, approval by 3 at least person, actual clearance process status, impact metrics, and notes. • The tool must accept files in the following extensions: .doc, .pdf, .jpg, .png, .xls • Define roles for authors, reviewers, and approvers with real time updates on approval status; • Implement features for assigning tasks, setting priorities, and generating reminders. • Notify higher-level users for delayed approvals
Approval Workflow for Communication Products: • Set up approval workflows with a simple (‘approved click’ that can be monitored and certified) – providing notifications to approver as well as requestor. • Enable version tracking and automated status updates.
Social Media and Website Tracking: • Track performance of communication products across social media platforms (e.g., likes, shares, comments, etc.). • Provide metrics from each communication product (e.g., social media impact, website traffic) and generate statistical reports.
Salesforce Integration for Email Tracking and Campaigns: • Integrate tracking system to our newsletter (using salesforce or any other free software) to develop mailing lists, and track email marketing campaigns, open rates, click rates, and other relevant metrics.
Technical Skills
- Microsoft 365 Expertise: Proficiency in using Microsoft Lists, SharePoint, Power Automate, and Power BI to develop and customize tools.
- Salesforce Integration: Experience in integrating Salesforce (or other free software) with communication tools for email tracking and analytics.
- Workflow Automation: Strong understanding of workflow creation and approval processes using Power Automate or similar tools.
- Software Development: Skills in developing user-friendly software solutions tailored to organizational needs.
Project Management and Collaboration - Requirement Gathering: Ability to engage with teams (e.g., IT and Communications) to understand and translate organizational needs into technical solutions.
Problem Solving and Innovation - Analytical Thinking: Ability to troubleshoot and resolve issues effectively during the development and implementation process. Creativity: Open to innovative solutions using free or cost-effective software while meeting organizational requirements.
Potential interview questions
| Describe a time when you had to gather requirements for a software project. What approach did you take? | This question assesses your ability to understand and gather project requirements effectively. | Discuss your process in meeting with stakeholders and how you documented their needs. |
| How would you prioritize tasks in a project with tight deadlines? | This question reveals your project management skills and ability to work under pressure. | Pro members can see the explanation. |
| Can you give an example of a time when you had to integrate different software systems? What challenges did you face? | Pro members can see the explanation. | Pro members can see the explanation. |
| What strategies would you use to ensure team collaboration when developing a tool? | Pro members can see the explanation. | Pro members can see the explanation. |
| Describe an innovative solution you developed using cost-effective software. What was the impact? | Pro members can see the explanation. | Pro members can see the explanation. |
| How do you track the success of communication campaigns? | Pro members can see the explanation. | Pro members can see the explanation. |
| Have you ever encountered a significant obstacle while developing a software tool? How did you overcome it? | Pro members can see the explanation. | Pro members can see the explanation. |
| What experience do you have with Microsoft Power Automate or similar tools? | Pro members can see the explanation. | Pro members can see the explanation. |