- Key Responsibilities:
- O365 Installation and Configuration:
- Install and configure Office 365 applications for users, ensuring proper deployment across various devices and platforms (Windows, Mac, Mobile).
- Handle O365 license management, activation, and provisioning of user access.
- Set up and configure O365 services like Exchange Online, OneDrive, Teams, SharePoint Online, and other cloud applications.
- Ensure Office 365 compatibility with existing IT systems and software tools used within the organization.
- Configure O365 security settings and ensure that security policies such as data loss prevention (DLP) and encryption are properly implemented.
- O365 Troubleshooting and Support:
- Provide technical support for O365 users, addressing issues related to installation, functionality, and performance.
- Troubleshoot and resolve installation issues, login problems, and application errors for O365 applications like Word, Excel, Outlook, Teams, and others.
- Manage O365 account issues, including password resets, account synchronization problems, and permission issues.
- Coordinate with Microsoft support when necessary for advanced troubleshooting and resolution of complex technical issues.
- Monitor O365 performance to ensure the environment is running smoothly and make adjustments as necessary.
- VBA Script Development and Maintenance:
- Develop, debug, and maintain VBA scripts for automating tasks within Excel, Outlook, Access, and other Office 365 applications.
- Customize VBA macros to automate repetitive tasks, improve data processing, and integrate Office tools with other business applications.
- Create and maintain customized Excel reports, dashboards, and data processing tools using VBA scripting to enhance business operations.
- Optimize existing VBA scripts for performance improvements and ensure they meet user requirements.
- Troubleshoot and debug VBA scripts to resolve issues and improve functionality.
- User Training and Documentation:
- Provide training and support to end-users on O365 applications and VBA scripts to ensure they are effectively using the tools for their daily operations.
- Create and maintain documentation for O365 deployments, VBA scripts, troubleshooting procedures, and common issues.
- Develop and deliver training materials and sessions to educate users on Office 365 features and best practices for using VBA automation tools.
- Collaboration and Reporting:
- Work closely with other IT teams (security, infrastructure, and support) to ensure that O365 configurations align with organizational policies and security protocols.
- Provide regular status updates and reports on ongoing installation, support activities, and troubleshooting efforts to management.
- Collaborate with business stakeholders to identify automation needs and develop solutions using VBA scripting.
- Continuous Improvement:
- Stay up to date with the latest O365 updates and VBA scripting techniques, integrating new features and capabilities into the organization's O365 environment.
- Continuously monitor and improve O365 performance, ensuring that all services are being utilized optimally.
- Suggest and implement improvements to the O365 configuration and VBA scripts based on feedback from end users and internal teams.
- Required Qualifications:
- Bachelor's degree in Information Technology, Computer Science, Business Systems, or a related field.
- 2-5 years of hands-on experience with Office 365 installation, configuration, and troubleshooting in an enterprise environment.
- Strong expertise in O365 apps such as Exchange Online, OneDrive, Teams, Outlook, and SharePoint Online.
- Proficient in VBA scripting for automating tasks in Microsoft Excel, Outlook, and other Office applications.
- Solid understanding of Office 365 security policies and configuration, including data protection, DLP, and encryption.
- Experience with PowerShell scripting for Office 365 administration tasks.
- Strong problem-solving skills with the ability to troubleshoot and resolve technical issues in O365 and VBA scripts.
Skills Required
Exchange Online, Outlook, Dlp